I have a flow which uses get_rows from an Excel file on One Drive
The output is shown in my flow but as it is not a specific file it does not show Dynamic Values.
The data is shown as part of the get_rows output when I run my flow.
How can I reference the columns from the get_rows output so I can save to a sharepoint list?
Could you please show a screenshot of your flow's configuration?
Further, do you want to reference the value within output of "Get rows" action and save them to a SharePoint list?
I think a "Apply to each" action could achieve your needs, please take a try with the following workaround:
Note: When you add a "Apply to each" action within your flow, you could select the dynamic values of the output of "Get rows" action within "Create item" action.
The flow works successfully as below:
The part that initially causes an issue is the Excel file, as I want to be able to use differnt excel file based on a template not just a specific one as I wil be adding a new file each week. Once I do this the Flow will run and update the data in the Sharepoint list.
I have sucessly created a flow as below but I want to use (File Identifier) for the filename and (Get Tables) to find the table name as sometimes it can be different.
What I need to know if how to reference columns manually in the create Sharepoint Item Action.
e.g. The Dynamic Content shows:
How do I replicate this using Workflow Definition Language e.g. @output(Get_Rows)['Product']
I have managed to sort a workaround but it is messy and can cause issues.
The flow currently looks like this:
I have found that if I reference an actual file in the Get Rows Action (and have access to the dynamic content as per your example) I can input the dynamic content then go back to the Get Tables action and change the Filename to (File Identifer) and the Table Name to (Name) and it works.