Forum Discussion
Non-experienced Developer Needs Your Help
Hi all, I'm trying to build a form that is connected to my files and folders in Sharepoint.
Here's how it works:
1. Employee goes to a Sharepoint site, navigate to the form page to upload marketing assets (jpeg/mp3/mp4/etc.).
2. Once uploaded, the marketing assets will be saved to the right folders according to the form field entries.
In other words, the form consists of drop-down lists that reflect the actual folder structure.
For instance, if I have the below folder structure:
Client Name > Campaign Name > Asset Name
The form will consists of 3 fields and 1 button:
- Client name
- Campaign name
- Asset name
- Upload button
I have no clue on where to start regarding this. Any tips?
Hi Keira_Low - yes I am referring to Microsoft Forms. You could create the Form and then have Flow route the documents to the correct path based on the fields they select in the Form.
Alternatively, you could set up a Drop Off Library/Content Organizer. https://support.office.com/en-us/article/Create-Content-Organizer-rules-to-route-documents-1E4D37A3-635D-4764-B0FC-F7C5356C1900
4 Replies
Hi Keira_Low - is there a business case against them directly accessing this library and navigating through the folder structure themselves to upload the files? If so, you could use Forms and Flow to route the documents, but keep in mind that Flow isn't going to be free for too much longer.
Hi, Kelly_Edinger .
In terms of business case, yes we do not want certain employees to have direct access into the folders. Hence, them uploading the files through a form is preferred.
When you say Forms, are you referring to Microsoft form?
Hi Keira_Low - yes I am referring to Microsoft Forms. You could create the Form and then have Flow route the documents to the correct path based on the fields they select in the Form.
Alternatively, you could set up a Drop Off Library/Content Organizer. https://support.office.com/en-us/article/Create-Content-Organizer-rules-to-route-documents-1E4D37A3-635D-4764-B0FC-F7C5356C1900
- If as Kelly suggests, you went with having the users simply upload files direct to the library, you could ditch the folders, and just use Choice columns for the 3 fields - then use views / filters to display the content as required.
