Hi all,
I have run into a slight problem with my Power Automate Flows.
What am I trying to achieve: I am primarily trying to create a way that when a excel file is saved into this folder, the flow will trigger, find the static table name (Currently Table1) extract the row objects and upload it to either a List (Goal) or another excel document (if easier).
The Problem is: That when I go through this process, I can not create a List Item nor update a excel row item because I do not get the table values. (Due to it only triggering when a new item is added, is my assumption)
The Process should be like this:
When a new excel file is created/added to a SharePoint Online Folder.
Get <Table1>
Extract data from Table1
Upload it to either a SharePoint List that I have. Or to a Online Excel file that I have in a subfolder.
I can create a flow that is triggered when a new file is added to a folder,
I can get access to the table in question.
I can extract that whole data (No column specific information just the data, i.e. <Odata, Name, Email, Phone #, etc>
But being able to add the data individually to separate columns or anything else is where I am struggling.
Please let me know if more information is required, and I will aim to supply it.
Many thanks.
