Updating SharePoint Lookup Column with multiple

(2) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all! 🙂

I am having an issue with getting Power Automate to update a SharePoint Lookup Column.

The Lookup column is not updating even though the flow is completing successfully.

The Lookup column is configured to allow multiple values and the data I am using from PowerApps pulls the ID number from the List the Lookup column is looking at.

The value pulled from PowerApps is the ID numbers seperated by semi-colons:

I then use a compose to split the values by the semi-colon:

Then use a Select to create an array of the IDs

Once it is in an array, I use that in the column within the Update Item (which works fine for everything else i.e. Single Line of Text, Multiple Lines of Text, Multiple Choice and DateTime.

When the flow is finished running, I can see the input went in however, the output appears as blank? Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

v-bacao-msft Microsoft Employee on at

Like (4)

Report
Copy link

Link copied!

Hi @Anonymous ,

Please try the following method. You should use int() function to change the type of id to an integer.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @v-bacao-msft

Works really well thanks!

Only have one issue - when there is no value from PowerApps I get the below error:

"Unable to process template language expressions in action 'Append_to_array_variable' inputs at line '1' and column '2332': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'."

Any way around this?

Thanks

Bradley

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

You could add Condition to check if the response from PowerApps is empty.

Best Regards,

Was this reply helpful? Yes No
flowtestes 4 on at

Like (0)

Report
Copy link

Link copied!

hello
i did the same thing but doesnt work can you please help me in it

Was this reply helpful? Yes No
psmith1117 26 on at

Like (0)

Report
Copy link

Link copied!

What worked for me was using a string variable and using the concat function to create a string in the format of "#,#,"

Was this reply helpful? Yes No
psmith1117 26 on at

Like (0)

Report
Copy link

Link copied!

I checked further and this did not work. It allowed my flow to run successfully but the values were not saved.

Was this reply helpful? Yes No
raks on at

Like (0)

Report
Copy link

Link copied!

Hi @psmith1117 ,
Did you find a solution? Is it saving with your concat?

Was this reply helpful? Yes No