cancel
Showing results for 
Search instead for 
Did you mean: 

Set the default value of a managed metadata field

It would be nice to be able to set a default value for a managed metadata field on a customized SharePoint list form.

Status: New
Comments
Level: Powered On

Any update since nearly 2 Years?

Level 10

Hi @NightKing,

I don't know if the Power Apps team did something since then, but I am able now to set default value for managed metadata fields.

Here is how to do it...

When you insert a datacard in your form for a managed metadata field, the Items value for the dropdown list is as follow:

Choices([@Bills].scVehicule)

So, if you want, let's say, to set a default value to your managed metadata field, do it by putting a formula like this one in the DefaultSelectedItems property of the dropdown list:

If(SharePointForm1.Mode = FormMode.New; LookUp(Choices([@Bills].scVehicule); Label="308") ; Parent.Default)

Just replace the "308" value with the label of the term you want to set as a default value.

Hope this helped.

Level: Powered On

Thanks, this seems working, except i must use comma instead of semicolon in the formula.

But i guess, that this wont work with similar Labels in a hierarchical Termset-Tree: 

 

Termset:

- Finance

 -- Admin

 -- Account

-Purchase

 -- Admin

-Marketing

 -- Account

Level 10

LOL... I knew you were going to ask about hierarchical term sets... 😁

So, for hierarchical you simply need to specify the path to the term like this:

If(SharePointForm1.Mode = FormMode.New; LookUp(Choices([@Bills].scVehicule); Path="Finance" && Label="Admin") ; Parent.Default)

And if you had more sublevels in your hierarchy, you should specify the path value this way:

Path="Level1/Level2/Level3"

Tell me if this works for you. I've just tested it on my side and it works fine. 

Level: Powered On

fantastic approach!