Create excel with multiple worksheet using azure logic app

Question

Create excel with multiple worksheet using azure logic app

Ramji R 11

Hi I have 5 different set of queries which i want to run in the logic app periodically. It will be better if i create only one excel and add the query result as 5 different worksheet with different name in the logic app for easy access of data.

Is there any possibility to do that.Any link for the above scenario is appreciated.

Neeraj Joshi 0 Reputation points

2023-04-03T13:24:51.2233333+00:00

@Ramji R can you please share the Logic app designer workflow if its already resolved for you? I am struggling with same concern.

1 answer

Your answer

Neeraj Joshi 0 Reputation points

2023-04-03T13:24:51.2233333+00:00

@Ramji R can you please share the Logic app designer workflow if its already resolved for you? I am struggling with same concern.

Answer 1

MughundhanRaveendran-MSFT 12,506

Hi @Ramji R ,

Thanks for posting this question in Q&A forum.

Yes. It is possible to create multiple worksheets in the same Excel file. When you use the Office 365 Excel connector, you can choose the same excel file that is present in the Sharepoint document library and create new worksheets for different queries.

Hope this helps!

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Ramji R 11 Reputation points

2022-10-18T05:07:15.587+00:00

Hi I tried the above as of now I created a excel, inside it created a worksheet and a table.

Now I want to insert the records into the sheet table. I tried like below

, But on running the foreach insert into row throws an error like

Let me know what im missing.
MughundhanRaveendran-MSFT 12,506 Reputation points

2022-10-20T09:30:29.057+00:00

From the error message it appears that you are inserting null values. Please check the data that you are inserting

Share via

Create excel with multiple worksheet using azure logic app

1 answer

Your answer