SOLVED

Sharepoint List with dynamic forms

%3CLINGO-SUB%20id%3D%22lingo-sub-1196470%22%20slang%3D%22en-US%22%3ESharepoint%20List%20with%20dynamic%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196470%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20an%20order%20intake%20system%20that%20uses%20a%20sharepoint%20list%20to%20ingest%20orders.%20Users%20fill%20out%20a%20sharepoint%20list%20form%20and%20then%20a%20flow%20fires%20to%20do%20several%20tasks.%26nbsp%3B%20Thats%20all%20working%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20order%20form%20takes%20in%20several%20order%20types%2C%20lets%20say%20creatives%2C%20collateral%2C%20and%20signage.%26nbsp%3B%20These%20order%20types%20share%20some%20fields%2C%20but%20have%20some%20fields%20that%20are%20unique%20to%20each%20order%20type.%20What%20I'd%20like%20to%20accomplish%20is%20to%20enter%20in%20the%20shared%20field%20values%2C%20the%20select%20from%20a%20drop%20down%20the%20order%20type.%20Based%20on%20that%20order%20type%2C%20reveal%20only%20those%20fields%20that%20are%20relevant%20to%20the%20chosen%20order%20type.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20how%20to%20accomplish%20this%3F%26nbsp%3B%20Your%20advice%20and%20insight%20is%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1196470%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1196684%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20with%20dynamic%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196684%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%2F225477%22%20target%3D%22_blank%22%3E%40Todd%20Morris%3C%2FA%3E%26nbsp%3Byou%20can't%20do%20this%20with%20a%20default%20SharePoint%20form%20so%20this%20would%20need%20a%20PowerApps%20customised%20form%20which%20will%20happily%20display%20fields%20based%20on%20what%20is%20selected%20in%20a%20dropdown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20live%20example%20we%20use%20is%20shown%20below%20that%20displays%20or%20hides%20the%20%22Web%20link%20for%20install%22%20field%20depending%20on%20how%20the%20Custom%20Install%20toggle%20is%20set%20(but%20could%20equally%20be%20a%20dropdown).%20The%20%3CEM%3EVisible%3C%2FEM%3E%20property%20of%20the%20Web%20link%20for%20Install%20field%20uses%20the%20following%20syntax%20for%20this%3A%20%3CSTRONG%3EIf(togCustomInstallEdit.Value%3Dfalse%2Ctrue%2Cfalse)%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22visibleProperty2.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173661iE16DCFD54BC7AF38%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22visibleProperty2.png%22%20alt%3D%22visibleProperty2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1196996%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20with%20dynamic%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196996%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20Rob!%26nbsp%3B%20much%20appreciated%2C%20i%20will%20give%20it%20a%20go%20in%20Power%20Apps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We have an order intake system that uses a sharepoint list to ingest orders. Users fill out a sharepoint list form and then a flow fires to do several tasks.  Thats all working fine.

 

This order form takes in several order types, lets say creatives, collateral, and signage.  These order types share some fields, but have some fields that are unique to each order type. What I'd like to accomplish is to enter in the shared field values, the select from a drop down the order type. Based on that order type, reveal only those fields that are relevant to the chosen order type.  

 

Any ideas on how to accomplish this?  Your advice and insight is appreciated!

 

 

2 Replies
Highlighted
Solution

Hi @Todd Morris you can't do this with a default SharePoint form so this would need a PowerApps customised form which will happily display fields based on what is selected in a dropdown.

 

A live example we use is shown below that displays or hides the "Web link for install" field depending on how the Custom Install toggle is set (but could equally be a dropdown). The Visible property of the Web link for Install field uses the following syntax for this: If(togCustomInstallEdit.Value=false,true,false)
visibleProperty2.png

 

Rob
Los Gallardos 

Highlighted

@Rob Elliott 

 

Thank you, Rob!  much appreciated, i will give it a go in Power Apps.