Announcements
I have an excel file which is linked to a sharepoint list which I refresh manually every morning.
Is this something that can be automatically scheduled to run that would work even if I was out of the office?
@Gti182 ,
You cannot refresh a File using Power Automate
Troubleshoot Office Scripts running in Power Automate - Office Scripts | Microsoft Learn
But you can generate a new file each day by querying the List data. Will that work?
Thanks Sudeep, that's quite interesting and surprising at the same time.
Generating a new file each day will also work, how would one go about querying the list data?
Hi @Gti182
This should work. You can set the flow to run everyday at a given time.
It will generate a new file each day by appending the date at the end of the filename.
Thanks Sudeep,
This looks like a great solution that will be suitable which i've got to work for the most part. However the data in the .csv files appear to be corrupt e.g. vendor column data should be "apple" but showing as: [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":-1,"Value":"apple"}]
is there a step i missed to remove all the red text and only show "apple"
@Gti182
The column you are referring to seems to be a Lookup or Choice column.
If that is the case, pick the property that has the word value next to it.
Thanks again Sudeep,
That makes sense and updated to suit as follows, now generating below error. I'm out of ideas 🙂
"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Create_file' at line '1 and column '1566' cannot reference action 'Create_CSV_table'. The action 'Create_CSV_table' is nested in a foreach scope of multiple levels. Referencing repetition actions from outside the scope is supported only when there are no multiple levels of nesting.'.'."
@Gti182 You don't need all these loops. What is the Compose action for ? I don't see a select action as well.
Thanks for all the help Sudeep. Apologies i was experimenting with another flow i found online and got the 2 mixed up. The solution updates for choice columns selecting "Value" option worked
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 573
Valantis 407
11manish 387
