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?
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
@Gti182 You don't need all these loops. What is the Compose action for ? I don't see a select action as well.
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.'.'."
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 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"
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, 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?
@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?