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