I have power automate which is creating excel file and exporting the sql query data into excel file. To export the data, i am using graph api excel connector. The graph api query is failing if file size exceeded 4 MB. How can i export the data using batch concept in power automate.
Asked
Active
Viewed 23 times
0
-
Do you use Excel Online (OneDrive) or Excel Online (Business)? Probably share your power automate code if possible. – user2250152 Jul 17 '23 at 10:28
-
You’ll need to batch up the calls. – Skin Jul 18 '23 at 11:01
-
Excel online(OneDrive) – Liz Jul 18 '23 at 11:21
-
there is no code, it is just query.https://graph.microsoft.com/v1.0/me/drive/items/@{substring(outputs('Get_file_metadata')?['body/Id'], add(indexOf(outputs('Get_file_metadata')?['body/Id'], '.'),1))}/workbook/tables/FATable/rows/add – Liz Jul 18 '23 at 11:38