Skip to main content

Notifications

Power Automate - General Discussion
Answered

Refresh Excel file synced to a SharePoint List

(0) ShareShare
ReportReport
Posted on by 38

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 Profile Picture
    Gti182 38 on at
    Re: Refresh Excel file synced to a SharePoint List

    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

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Refresh Excel file synced to a SharePoint List

    @Gti182 You don't need all these loops. What is the Compose action for ? I don't see a select action as well.

     

  • Gti182 Profile Picture
    Gti182 38 on at
    Re: Refresh Excel file synced to a SharePoint List

    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_0-1718094384514.pngGti182_1-1718094436087.png

     

  • Verified answer
    SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Refresh Excel file synced to a SharePoint List

    @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.

    SudeepGhatakNZ_0-1717784964835.png

     

  • Gti182 Profile Picture
    Gti182 38 on at
    Re: Refresh Excel file synced to a SharePoint List

    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"

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Refresh Excel file synced to a SharePoint List

    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.

    SudeepGhatakNZ_0-1717641539171.png

     

  • Gti182 Profile Picture
    Gti182 38 on at
    Re: Refresh Excel file synced to a SharePoint List

    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?

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Refresh Excel file synced to a SharePoint List

    @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?

     

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard