Can Flow update Sharepoint Lists' LookUp Columns ?

(2) Share

Report

Posted on by efialtes

350

Hi everybody!

When designing a Sharepoint List, I added a Column as Lookup

https://support.office.com/en-us/article/Site-column-types-and-options-0d8ddb7b-7dc7-414d-a283-ee9dca891df7#__toc277149827

Then I selected this list in "Sharepoint Online-Update Item" action block, but Flow does not offer me option to modify the content of the Lookup-type Column.

The same limitation applies when I tried "Sharepoint Online-Create Item"

Is this design intent, or a bug?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (38)

Answers (0)

rjj88 Microsoft Employee on at

Like (1)

Report

Sorry - I can't answer your question but I believe I am trying to find the same answer.

I would like a final approval date to be posted back to the list item to populate a "Final Approval Date" field which would show the date value when the list item was opened again for review.

Can Flow modify fields within a SP list item?

Was this reply helpful? Yes No
merwan on at

Like (8)

Report

Flows can indeed be used to both create and modify SharePoint list items, however currently Lookup, People, and Choice columns cannot be written to. Today we only support reading from them, so they can be used as dyanmic outputs in other actions. This is a known limitation that we will be addressing soon.

Was this reply helpful? Yes No
rjj88 Microsoft Employee on at

Like (0)

Report

Great - thank you!

Was this reply helpful? Yes No
Rfla 252 on at

Like (3)

Report

How soon ? 🙂 @merwan

Was this reply helpful? Yes No
Rod-commtech 3 on at

Like (0)

Report

To add - currently unable to read Sharepoint lookup list if source for values in another site 😞
"status": 400, "message": "The field 'OfficeLookup' is not supported in query. The lookup list is in another web.",

Was this reply helpful? Yes No
Stroos 14 on at

Like (0)

Report

How is it possible to modify a list item using Flow. I don't see this as an option anywhere? I'm trying to create a daily recurring Flow that modifies column data back to "0" at a specific time each day.

Was this reply helpful? Yes No
Rfla 252 on at

Like (0)

Report

Not sure if this is what you are looking for @Stroos, but you have to select Schedule/recurrence in your first step. Then if you type in SharePoint in the next action you should see options like Uptade item...

Was this reply helpful? Yes No
Stroos 14 on at

Like (0)

Report

Yes that's exactly what I'm looking for however when I click on the SharePoint icon it flickers for a moment and shows me this:

But then ultimately resolves to only these options.

I'm starting from no template and doing a recurrence like in your screenshot.

Was this reply helpful? Yes No
Stroos 14 on at

Like (0)

Report

Disregard. I figured it out. Instead of clicking on SharePoint I have to type it out in the search and it shows me more options. I thought they did the same thing.

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

Like (0)

Report

@merwan I have been trying to get lists to update records based on updates in other lists but although I cann get flow to create records I cannot get them to update when the corresponding record in the original list is updated. Is this possible?

Was this reply helpful? Yes No