I'm trying to create a flow that'll extract data from MS List to an Excel table, so I can create some KPI's.
I got the Title to be imported correctly, but neither the Category (Drop down) or Start date/Completed date are transferred to the table.. I'm at a loss, I've tried Chatgpt, looking through forums etc. and I simply cannot get it to work, does anyone know a fix to this?
The flow is setup as follows:
Trigger: "When an item is created or modified" in Sharepoint (Where the list originates)
Next step is "Add a row into a table"
The parameters are setup to link to each column needed in the table by this command
The easiest way to do this is to create a view in the SharePoint list with the columns you need in the KPI report. Then use the Export to Excel feature (Export to Excel from SharePoint or Lists - Microsoft Support) in SharePoint to create the Excel file. When you do this, it creates a live connection to the data in the list. Then to refresh the data, you just need to go to the data tab in Excel and click refresh. What is your reasoning to do this through a workflow?
If you still think you need a workflow, show your workflow and the configuration of the actions. Also show the how the data looks in the SharePoint list so we can tell what type of data the columns contain. Unless we can see what you're doing, it is hard to tell what is wrong.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
10
Share
Report
All responses (
Answers (
