Unanswered

Updating Excel file located in Site Assets Sharepoint library

(0) Share

Report

Posted on by russellkoons

I have a flow that takes responses from a Microsoft Form and automatically adds all the information to a spreadsheet in my OneDrive. My team has recently decided we want to move all shared spreadsheets into a central location on our Sharepoint site and my teammate tasked with creating the folder put it in our Site Assets library.

I uploaded the Excel file to the new folder, but when I try to update my flow to point to this new location, Site Assets is not listed:

I tried to follow the instructions listed in this thread, but I receive this error when trying to find the file:

Is there another way to access this file in the Site Assets library? We could move the files into one of the other Document libraries that are listed, but I don't want to add extra work if it's not needed.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Shivani_PowerAp 19 on at

Like (0)

Report

Hi @russellkoons , I am facing the same issue.. Did you figure out a workaround?

Was this reply helpful? Yes No
Verified answer

russellkoons 43 on at

Like (0)

Report

Hey @Shivani_PowerAp
I ended up just having to move the folder to a different location that Power Automate could locate. Hope this helps!

Was this reply helpful? Yes No
Shivani_PowerAp 19 on at

Like (0)

Report

Hi @russellkoons , I have figured out a work around. Instead of using the excel connector to add row to the excel file that sits under Site Assets on Sharepoint, we can use "Get File content, sharepoint connector" to read the contents of of response excel file and then use "update file " sharepoint connector to write to the file under Site asset library.
Attaching screenshot for reference. Hope that will help for future.

workaround.png

Was this reply helpful? Yes No