Update Excel file in shared folder

[skourtip]

Hi to all

I want to update one excel file in a shared folder, is there a possibility?

Thanx in advance

[creativeopinion]

Can you provide more details? Are you trying to overwrite a file or are you trying to add items to your Excel file?

[skourtip]

I want to run a script

[creativeopinion]

How do you want to trigger your flow? Will it always be the same file you want to run the script on? Or do you want to trigger your flow by selecting the file and running a script on the selected file?

[skourtip]

I just want the same file to run the script once in a day 

[creativeopinion]

You can use the Recurrence action and set the frequency to Week (if you'd like to select which days to run the flow) or to Day (if you'd like it to run every day — including weekends).

Use the Run Script action. Select your Location, Doc Library, File and Script. 

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

[skourtip]

The file i want to run the script is in a shared folder that shared to me and when i try to find it in File option I can't find the folder 

[creativeopinion]

To run an Excel script from Power Automate the script needs to be saved in Excel so it's accessible through Power Automate. 

In Excel, create a New Script and copy the script into the script editor. The script can be a created in a blank workbook or an open one it doesn't matter.

Save the script and do not change the location of where it's being saved. Leave the default location. 

Once you've done that you should see it in Power Automate.

[skourtip]

I can see the script i cannot see the shared folder to add it in the document library 

[creativeopinion]

You need to add the script to Excel and save it through Excel. 

1. In Excel, click on the Automate tab. 
2. Click on New Script.
3. Click on the Script Name to rename it.
4. Replace the default script code with your script code.
5. Press Save Script. 

Once you do that, it will be visible in Power Automate. 

[skourtip]

I get this error

[creativeopinion]

Is the script successful when you run it directly in Excel? 

[skourtip]

Yes it's successful 

[creativeopinion]

Sorry I'm stumped then. Did the script run with any errors by chance? They would appear below the code editor in Excel. 

Sometimes the script can run in Excel and still output errors. I wonder if you might have a few errors that is causing the flow not to run.