Forum Discussion
SharePoint Library Help Needed
I have a SharePoint Library where I would like to implement these requirements below and would appreciate your advise:
- Folders were created at the library level, which looks like the image below. I do not want people to be able to create any folders or upload documents or folders at the library level, but rather only when they open the folders. I have disabled folder creation and created a PowerApps form, so that users can only upload document, edit documents, view details of the documents when they open any of the folders., but I cannot seem to find the Power Apps form when I open any of the folders and try to upload a document or view a document or edit the document details.
2. I have a choice column called Fiscal Year which has options as = FY22, FY 23, FY24, FY25, FY26. By March 2026, I would like to create an automate flow which will auto create FY27 and remove FY22 from the choice, so that the choice column is always limited to only 5 years.
1 Reply
Power Apps customized forms in SharePoint work at the library level, not at the folder level. So, they won’t show up when users upload files inside folders. They only open when creating a new document using New or when editing metadata. Because of this, when users go into a folder and click Upload, SharePoint uses its default upload experience instead of the Power Apps form. You may consider creating a full Power App (not just a form) if you want more control over uploads and metadata.
I would recommend a simple approach using library settings and permissions. This will ensure users can only upload files inside folders.
- Disable “New Folder” in Library Settings (which you have already done)
- Set read-only access at the library root level
- Give contribute/edit access at the folder level
For the Fiscal Year column, you can use Power Automate with an HTTP request to update the choice values each year (add new FY and remove the oldest), keeping it limited to 5 years.
If my post solved your issue or answered your query, please mark it as a Solution and give it a Like.
