SOLVED

Selecting value from tree-view for managed metadata via PowerApps edit form for SharePoint list.

%3CLINGO-SUB%20id%3D%22lingo-sub-239566%22%20slang%3D%22en-US%22%3ESelecting%20value%20from%20tree-view%20for%20managed%20metadata%20via%20PowerApps%20edit%20form%20for%20SharePoint%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-239566%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHas%20anyone%20much%20experience%20with%20setting%20up%20how%20to%20select%20managed%20metadata%20values%20via%20a%20PowerApps%20edit%20form%20for%20a%20SharePoint%20list%3F%20I'm%20having%20difficulty%20finding%20how%20to%20get%20the%20selection%20box%20to%20display%20the%20data%20in%20a%20%3CSTRONG%3Etree%20view%3C%2FSTRONG%3E%20the%20same%20as%20the%20native%20SharePoint%20edit%20%26amp%3B%20quick%20edit%20forms%20allow.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-239566%22%20slang%3D%22en-US%22%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-277179%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20value%20from%20tree-view%20for%20managed%20metadata%20via%20PowerApps%20edit%20form%20for%20SharePoint%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277179%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20can%20see%20in%20that%20video%2C%20there%20are%20lots%20of%26nbsp%3Bpossibilities%2C%26nbsp%3Bbut%20a%20classic%20treeview%20is%20tricky%2Fugly%20to%20do%20I%20am%20afraid...%26nbsp%3B%20closest%20I%20got%20was%20to%20take%20the%20output%20of%20the%20choices()%20function%20which%20will%20bring%20back%20your%20term%20set%20into%20a%20collection%26nbsp%3Band%20groupby()%20to%20then%20format%20the%20collection%20appropriately%20before%20then%20using%20a%20gallery%2Fsub%20gallery%20technique.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnfortunately%20that%20only%20works%20to%202%20levels%20deep.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20never%20took%20the%20time%20to%20find%20a%20pattern%20that%20can%20make%20it%20look%20like%20the%20classic%20tree-view%20of%20term%20sets%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-276873%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20value%20from%20tree-view%20for%20managed%20metadata%20via%20PowerApps%20edit%20form%20for%20SharePoint%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-276873%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20tried%20googling%20this%20again%20today%2C%20and%20this%20post%20was%20the%20first%20search%20result%20-%20d'oh!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20if%20maybe%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161%22%20target%3D%22_blank%22%3E%40Paul%20Culmsee%3C%2FA%3E%26nbsp%3Bhas%20an%20idea%3F%20I%20happened%20across%20this%20video%2C%20and%20seems%20like%20there's%20lost%20of%20possibilities...%20I%20just%20haven't%20found%20the%20right%20combo%20yet!%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DkfLIkn-RiSg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHave%20more%20team%20cuddles%20(and%20some%20PowerApps%20UI%20tricks%20with%20Managed%20Metadata)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1054133%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20value%20from%20tree-view%20for%20managed%20metadata%20via%20PowerApps%20edit%20form%20for%20SharePoint%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1054133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161%22%20target%3D%22_blank%22%3E%40Paul%20Culmsee%3C%2FA%3E%26nbsp%3BWhere%20can%20I%20find%20an%20example%20of%20the%26nbsp%3B%3CSPAN%3Egallery%2Fsub%20gallery%20technique%20using%20GroupBy%20as%20you%20mentioned%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1513441%22%20slang%3D%22en-US%22%3ERe%3A%20Selecting%20value%20from%20tree-view%20for%20managed%20metadata%20via%20PowerApps%20edit%20form%20for%20SharePoint%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1513441%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F33489%22%20target%3D%22_blank%22%3E%40Ian%20Bruckner%3C%2FA%3E%26nbsp%3BI%20am%20having%20a%20similar%20issue.%20The%20PowerApps%20Choice%20field%20lists%20all%20the%20managed%20metadata%20values%2C%20without%20any%20indentation%2C%20and%20in%20alphabetical%20order%20(when%20I%20have%20set%20a%20custom%20sort%20order).%20So%20two%20issues%2C%20I%20guess%3A%20how%20to%20show%20the%20indent%20(2-levels%20is%20fine%20this%20time)%3B%20and%20how%20to%20honour%20the%20sort%20order%20set%20in%20the%20TermStore%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Has anyone much experience with setting up how to select managed metadata values via a PowerApps edit form for a SharePoint list? I'm having difficulty finding how to get the selection box to display the data in a tree view the same as the native SharePoint edit & quick edit forms allow.

4 Replies
Highlighted

Just tried googling this again today, and this post was the first search result - d'oh!

 

Wondering if maybe @Paul Culmsee has an idea? I happened across this video, and seems like there's lost of possibilities... I just haven't found the right combo yet! Have more team cuddles (and some PowerApps UI tricks with Managed Metadata)

Highlighted
Best Response confirmed by Ian Bruckner (Frequent Contributor)
Solution

As you can see in that video, there are lots of possibilities, but a classic treeview is tricky/ugly to do I am afraid...  closest I got was to take the output of the choices() function which will bring back your term set into a collection and groupby() to then format the collection appropriately before then using a gallery/sub gallery technique.

 

Unfortunately that only works to 2 levels deep. 

 

I never took the time to find a pattern that can make it look like the classic tree-view of term sets :(

Highlighted

@Paul Culmsee Where can I find an example of the gallery/sub gallery technique using GroupBy as you mentioned?

Highlighted

@Ian Bruckner I am having a similar issue. The PowerApps Choice field lists all the managed metadata values, without any indentation, and in alphabetical order (when I have set a custom sort order). So two issues, I guess: how to show the indent (2-levels is fine this time); and how to honour the sort order set in the TermStore?