Answered

Update File Property for a term store column

(0) Share

Report

Posted on by SandraTibbs

New to Power Automate. I have looked in the community and can not find a solution that fits quite what I need. I have a automation that moves a file from one list to another after it has been approved. I need to update three columns of data for the file. Two of the columns successfully update. The last column is a term store field which has multiple values. I load a variable with the content of the original file's content. I am tried to update the copied file's column with the label, values, and Term Store GUID. I just get errors saying "The data returned from the tagging UI was not formatted correctly".

So this is what I have done so far.

How do I format the Category term store items to be able to pass it to the new file in the new directory?

Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

SandraTibbs on at

Like (0)

Report
Copy link

Link copied!

Add to my flow the Select Join statement to get the Array of information for the term store column of the original file. I pass the Join output to a variable to hold the data. The flow worked but only the last item in my category is appearing in the new file category column. How do I get all the items to load?

Original file from one list
Copied file in the other list

Was this reply helpful? Yes No
Verified answer

v-LilyW-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @SandraTibbs

Please try to initialize an Array variable, then use the Apply to each to append each value from the item into the array, after that, put the array into the field of Managed metadata column, you can refer to below screenshots:

Hope the content above may help you.

Best Regards

If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
SandraTibbs on at

Like (0)

Report
Copy link

Link copied!

Thank you for the assistance. I have enter the code above and removed my select and join. Now I get an error that states "The given guid does not exist in the term store".

This is the Category Values that loaded.
[
  {
    "Value": "InformationSystemsAdministrator|c2b78446-54e8-4764-9368-45a9e6848bdf"
  },
  {
    "Value": "IT|79397946-a932-410b-b65c-cc940e9f87ff"
  },
  {
    "Value": "Legal|0e0d2211-b585-4062-b1ff-196fdce04e8b"
  },
  {
    "Value": "QualityAsuranceInitiatives|46ad3177-9ddd-4f33-834e-ae0f84f6331f"
  }
]

Was this reply helpful? Yes No
SandraTibbs on at

Like (0)

Report
Copy link

Link copied!

Found why I was having this error. I forgot to set the field to multi-values. Once I did that then I had no issues. Thank you again for your assistance.

Was this reply helpful? Yes No