Create and Populate Excel file from template

Question

I am quite new to Azure Logic Apps. What I am trying to do is open an Excel file, populate fields in this file with some JSON values, and save it as a new Excel file.
{
"Email": "******@xxxxxxxx.com",
"Name": "Test Account",
"Phone": "999-999-9999"
}

For example, in the JSON above I’d like to save “Name” to cell A3, “Phone” to C5, etc.

I suspect step one would be to get the file contents, but I’m at a loss figuring out how to populate the file with data.

I see there is an action called Plumbsail Documents which looks to do what I want, but it requires a subscription and I’d really like to avoid subscriptions if possible.

Thank you for any assistance.

Answer 1

@Kuzlotsky, Gerald Thanks for reaching out. There is no out of box connector published from Microsoft that can help you with your scenario. We do have the excel connector to perform the operation such as Get tables, update row etc., but not with the template. If you need to update the existing excel table, then you need to have your custom logic to get the table first and then try to leverage the update row action for each Json value as per your columns defined in your table.

Alternative if the connector cannot help you then you need to offload this functionality with your custom logic/code to azure function or any other http call and call azure function from logic app.