SOLVED

Non-experienced Developer Needs Your Help

%3CLINGO-SUB%20id%3D%22lingo-sub-787520%22%20slang%3D%22en-US%22%3ENon-experienced%20Developer%20Needs%20Your%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787520%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%20I'm%20trying%20to%20build%20a%20form%20that%20is%20connected%20to%20my%20files%20and%20folders%20in%20Sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20how%20it%20works%3A%3C%2FP%3E%3CP%3E1.%20Employee%20goes%20to%20a%20Sharepoint%20site%2C%20navigate%20to%20the%20form%20page%20to%20upload%20marketing%20assets%20(jpeg%2Fmp3%2Fmp4%2Fetc.).%3C%2FP%3E%3CP%3E2.%20Once%20uploaded%2C%20the%20marketing%20assets%20will%20be%20saved%20to%20the%20right%20folders%20according%20to%20the%20form%20field%20entries.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20other%20words%2C%20the%20form%20consists%20of%20drop-down%20lists%20that%20reflect%20the%20actual%20folder%20structure.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EFor%20instance%2C%20if%20I%20have%20the%20below%20folder%20structure%3A%3C%2FP%3E%3CP%3EClient%20Name%20%26gt%3B%20Campaign%20Name%20%26gt%3B%20Asset%20Name%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20form%20will%20consists%20of%203%20fields%20and%201%20button%3A%3C%2FP%3E%3COL%3E%3CLI%3EClient%20name%3C%2FLI%3E%3CLI%3ECampaign%20name%3C%2FLI%3E%3CLI%3EAsset%20name%3C%2FLI%3E%3CLI%3EUpload%20button%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20have%20no%20clue%20on%20where%20to%20start%20regarding%20this.%20Any%20tips%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-787520%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788246%22%20slang%3D%22en-US%22%3ERe%3A%20Non-experienced%20Developer%20Needs%20Your%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788246%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387127%22%20target%3D%22_blank%22%3E%40Keira_Low%3C%2FA%3E%26nbsp%3B-%20is%20there%20a%20business%20case%20against%20them%20directly%20accessing%20this%20library%20and%20navigating%20through%20the%20folder%20structure%20themselves%20to%20upload%20the%20files%3F%20If%20so%2C%20you%20could%20use%20Forms%20and%20Flow%20to%20route%20the%20documents%2C%20but%20keep%20in%20mind%20that%20Flow%20isn't%20going%20to%20be%20free%20for%20too%20much%20longer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788356%22%20slang%3D%22en-US%22%3ERe%3A%20Non-experienced%20Developer%20Needs%20Your%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788356%22%20slang%3D%22en-US%22%3EIf%20as%20Kelly%20suggests%2C%20you%20went%20with%20having%20the%20users%20simply%20upload%20files%20direct%20to%20the%20library%2C%20you%20could%20ditch%20the%20folders%2C%20and%20just%20use%20Choice%20columns%20for%20the%203%20fields%20-%20then%20use%20views%20%2F%20filters%20to%20display%20the%20content%20as%20required.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789091%22%20slang%3D%22en-US%22%3ERe%3A%20Non-experienced%20Developer%20Needs%20Your%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789091%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F19689%22%20target%3D%22_blank%22%3E%40Kelly%20E%3C%2FA%3E%26nbsp%3B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20terms%20of%20business%20case%2C%20yes%20we%20do%20not%20want%20certain%20employees%20to%20have%20direct%20access%20into%20the%20folders.%20Hence%2C%20them%20uploading%20the%20files%20through%20a%20form%20is%20preferred.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20say%20Forms%2C%20are%20you%20referring%20to%20Microsoft%20form%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789123%22%20slang%3D%22en-US%22%3ERe%3A%20Non-experienced%20Developer%20Needs%20Your%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789123%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387127%22%20target%3D%22_blank%22%3E%40Keira_Low%3C%2FA%3E%26nbsp%3B-%20yes%20I%20am%20referring%20to%20Microsoft%20Forms.%20You%20could%20create%20the%20Form%20and%20then%20have%20Flow%20route%20the%20documents%20to%20the%20correct%20path%20based%20on%20the%20fields%20they%20select%20in%20the%20Form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%2C%20you%20could%20set%20up%20a%20Drop%20Off%20Library%2FContent%20Organizer.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FCreate-Content-Organizer-rules-to-route-documents-1E4D37A3-635D-4764-B0FC-F7C5356C1900%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FCreate-Content-Organizer-rules-to-route-documents-1E4D37A3-635D-4764-B0FC-F7C5356C1900%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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:

  1. Client name
  2. Campaign name
  3. Asset name
  4. Upload button

I have no clue on where to start regarding this. Any tips?

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.

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.

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?

best response confirmed by Keira_Low (New Contributor)
Solution

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-...