Share
ReportHi all,
I was looking for a way to insert rows into a Excel table in a faster way then the standard 'Add rows to Excel table'. I've stumbled onto this article by the amazing Matthew Devaney to bulk insert rows into a table using the HTTP With Azure AD/HTTP With Entra ID connector. In the example given by Matthew he uses a static Excel file and from there he retrieves the Drive Item ID, named "file":
In my solution, i am creating a new Excel file and adding Excel rows to that new Excel file. When i want to reference to the Drive Item ID, I instead see the file path in the "file":
I can't seem to find this Drive Item ID anywhere, not with any of the SharePoint 'Get file properties' or 'Get file metadata' and i'm not able to reference to it anywhere else in the flow.
Does anybody have a solution to this?
All responses (
Answers (
252
