
I am trying to read rows from an excel table (the table exists!) and populate a sharepoint list. I get this to work if i specify the actual file in the List rows present in a table - it reads the column headers, BUT when i use the dynamic file selected in the trigger, it fails to read the column headers.
I found a work around that is to set up the create item action with an actual file and then return it to a dynamic file. However, i find this to be not robust enough.
Any tips on this issue? cheers
Hi @FbK1000
You need to add "Get file properties" action to get the file identifier and use this file identifier in "List rows present in a table" action to get the records.
Here is an example:
Add "Get file properties" before "List rows present in a table" action. Pass the ID from the trigger.
Pass the file identifier to the 'File' parameter from the output of previous action:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.