I have a flow where the trigger is an order is placed in a folder on Sharepoint.
What I would like to do is extract certain aspects of the order, ie certain cells(no tables in the files), and use that information to update a table of all the orders. From what I researched, the only thing that could this is AI Builder, or am I missing something?
If not if I was create a table in the order form, which populated with the information I need, is there a way to look at the same table in each new file that is submitted, bearing in mind that the file name will always be different?
Thanks in Advance
@Skybluekid then you could convert to CSV and Parse the CSV as described above.
It is just a normal xlsx file. There are not any tables in the file that I can use.
Hi @Skybluekid
If your data is not in a table data type, then the native Excel connector can't help. What file type is your excel file?
If its a CSV, you can use Encodian's Parse CSV action to get the CSV data as a JSON to use in your flow.
If its not a CSV, you would first have to convert it to a CSV using Encodian's Convert Excel action.
We are working on a "Convert Excel to JSON" action however this is not currently available.