Hi Folks,
I'm trying to run a script of a excel file using power automate. The excel file was created from a template in a previous step in same flow. So the scripts will not be listed in the drop down. I get the below error if I try to give the script name ( I also need to pass parameters). The "full path" is from create file action above.
I'm aware of the Run scripts from sharepoint library, which is working fine. But since it's still in preview mode, I was wondering if it's possible to use the above action itself.
Any insights?
Thanks
outputs('Get_file_propeties')?['body/{DriveItemId}']
Glad I could help! We expect the action to exit preview within the next few weeks.
Thanks for the update. That cleared all the questions I had. @FLMike - I was referring to the third point from @MichelleRanMSFT. Appreciate your inputs.
@MichelleRanMSFT - if possible, can you provide the road map or the time line on when the "Run script from SharePoint library" action will exit the preview mode (link to doc should be good, if one exists?
Thanks for the suggestions!
Hi @rbn_nue, chiming in on a few points here:
Let me know if that helps, or if you have any other questions!
Hello,
Apologies, I don't quite understand.
Are you saying that I was correct, that the Copy didn't have the script? And now you are saying you have a second "variation" of the same issue? I see the second photo, shows no script, but I am not sure if that is you doing the manual test I gave you, on the second scenario you are referring too or the first?
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
I just saw another scenario. I shared the script to the workbook, which indicated that anyone having access to this excel will have access to script. I was able to confirm this by opening the same excel which I stored in SharePoint (same tenant) using a different account (service account) and I saw below scripts associated with the workbook:
I can see it's in the other account one drive.
Now using the same service account which has access to these scripts via excel, I tried to create a flow and added run script action, pointing to the same file and I don't see any scripts!!
Could you please let me know if I'm missing something?
Thanks
Hi @FLMike
You were right, It seems the script is not available in the excel as per the new flow. The script is stored in my onedrive (Checked the excel from local machine), whereas the excel template will be stored in SharePoint of another tenant. Is there anyway I can attach the script to excel, or can the excel refer script SPO library?
Thanks
Hi,
Just to verify, can you please go look at one of the files you want to do this too and validate the script is there.
Then please create another flow, that does nothing else (Make it manual), then add a Run Script.
Also, for the details for Script, just to verify, you clicked Enter custom value and then typed it in?
If so, it should work, to the best of my knowledge, which makes me think its an issue with the file and or the script in the file. If you can do the first 2 steps above that would be super helpful.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional