Expected Record Value error, on updating Managed Metadata field SharePoint

(0) Share

Report

Posted on by Iantaylor2050

531

Hi All,

I have a powerapps form with SharePoint as the datasource. NewForm has a combobox, which gets values from SharePoint Managed Metadata column named TagsCollection. Items property of the combobox is set to SPListName.TagsCollection.

Update property of the datacard is set to below formula

If(
 IsBlank(ComboBox1.Selected.TagsCollection), 
 ComboBox1.SearchText,
  ComboBox1.Selected.TagsCollection
)

Based on above formula, user can add new tag to the TagsCollection as well as select existing tags from the TagsCollection .

However the above Update property throws error "Expected Record Value".

Need inputs on where I am wrong ?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Prakash4691 1,332 on at

Like (0)

Report

Hi @Iantaylor2050 ,

Modify the formula to Combobox1.Selected. It expects a record.

Regards,
Prakash

Was this reply helpful? Yes No
v-albai-msft on at

Like (0)

Report

Hi @Iantaylor2050,
Currently we cannot add new Managed Metadata terms through PowerApps. We can only select existing terms on PowerApps side.
This is because when you create a new term/tag, it will be granted with a unique TermGuid(by system). Below is the example, all terms are created from SP side.
Although we can use {Label:ComboBox1.SearchText} to remove the error message in formula bar, however, this text cannot be saved into SP list because of the different format.
You can vote for this existing idea from below link which is similar to yours:
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Metadata-tag-option/idi-p/124783
Best regards,
Allen

Was this reply helpful? Yes No
Iantaylor2050 531 on at

Like (0)

Report

Hi @v-albai-msft

Thanks for the above response. I have written a Power Automate to add new term to termstore. Power Automate is running fine and successfully adds new term to the termstore.

I tested this by passing textbox input to the Power automate, which successfully adds to the termstore.

However, when i try to pass combobox SearchText value, it always passes empty value in Power Automate. Any idea where I am going wrong ?

Was this reply helpful? Yes No