web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Run office script over...
Power Automate
Unanswered

Run office script over xlsx in hidden SharePoint forms folder

(2) ShareShare
ReportReport
Posted on by 11
Hello,
 
I want to run an office script over a xlsx file which is stored as a template in the hidden SharePoint forms folder.
The aim is to update an query inside the file on a weekly basis to provide updated values to the enduser.
 
I know the flow setup for files that are stored in the standard document library but I have no idea how to handle this with a file in the hidden forms folder.
Does anybody of you have an approach or solution?
 
Best regards
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,575 Super User 2025 Season 2 on at
     
    I have to say... I dont think I've ever been stumped this much ever.
     
    Hidden Forms folder for SharePoint.. Im not mocking, I am literally saying my brain melted and I have no idea. I dont think I've ever even heard such a thing.
     
    Ok now I have to try to figure it out. But I guess my only question is... how exactly did you tell it to hide your form somewhere that you cannot find?
  • Thomas_123_ Profile Picture
    11 on at
     
    Thank you for your reply.
    Well, it is not hidden for usage. The enduser can select it via "New" Button on the SharePoint site or in MS-TEAMS. In this case the excel file is a template.
    Unfortunately the Excel template is saved in the Forms system folder by default.
    After some unsuccessful and annoying tests in Power Automate I came to the conclusion to build a Power App based on a SharePoint list.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 429 Super User 2025 Season 2

#2
harshdeol Profile Picture

harshdeol 193 Moderator

#3
Tomac Profile Picture

Tomac 157 Moderator

Last 30 days Overall leaderboard