Answered

cascading dropdown for sharepoint managed metadata fields

(0) Share

Report

Posted on by AlHal2

I have some managed metadata fields in a SharePoint document library or list. The first level is the department. The second level is the team.

My powerapp has a form with two combo boxes (need to be multi select) - one for dropdown one for team.

When the user selects a team, I want the default selected item in the department combo box to correspond to the appropriate team.

When the user clicks a submit button the information is uploaded to Sharepoint.

What code do I need in powerapps?

Is there a difference between how I would do this for a SharePoint list or document library?

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

AlHal2 on at

Like
a
(0)

Report
Copy link

Link copied!

Not sure if this screenshot helps.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AlHal2
Check this post https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-Multi-Select-Cascading-Dropdown/m-p/903897

Was this reply helpful? Yes No
AlHal2 on at

Like
a
(0)

Report
Copy link

Link copied!

That deals with updating the SharePoint list.
How does that help me establish the link between Department and Team.
What do I put in the OnChange event and DefaultSelectedItems property of the combos?

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlHal2 ,

I would suggest you turn the Managed Metadata field into Text fields in SharePoint and you will have far less issues - complex field types have many limitations in Power Apps and this one in particular is an historic structure not designed with Power Apps in mind.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AlHal2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
If it's a text field in Sharepoint, what do I use in Powerapps?
In other words, how do I connect powerapps to the underlying data source?

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AlHal2 ,

Not sure what you mean - connect the List as a Data Source and all fields (including the Text fields) will be available to Power Apps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
AlHal2 on at

Like
a
(0)

Report
Copy link

Link copied!

When you said use single line of text in Sharepoint, I thought you meant that powerapps could access the metdata independently of Sharepoint.
Any thoughts on the hidden Sharepoint list TaxonomyHiddenList?

Was this reply helpful? Yes No
AlHal2 on at

Like
a
(0)

Report
Copy link

Link copied!

When you said use single line of text in Sharepoint, I thought you meant that powerapps could access the metdata independently of Sharepoint.
Our Sharepoint lists tend to be department specific hence the use of metadata fields.
I'm looking into TaxonomyHiddenList? Have you used it in Powerapps?

Was this reply helpful? Yes No
WarrenBelz 156,100 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@AlHal2 ,

What is TaxonomyHiddenList ? Power Apps needs a data source (it has none of its own) and can be connected to Multiple lists concurrently.

Was this reply helpful? Yes No
AlHal2 on at

Like
a
(0)

Report
Copy link

Link copied!

See https://code2care.org/2015/sharepoint-managed-metadata-hidden-taxonomy-list

Was this reply helpful? Yes No