Can Flow update Sharepoint Lists' LookUp Columns ?

[efialtes]

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-ee9dc...

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!

[rjj88]

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?

[merwan]

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. 

[rjj88]

Great - thank you!

[Rfla]

How soon ? 🙂 @merwan

[Rod-commtech]

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.",

[Stroos]

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.

[Rfla]

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...

[Stroos]

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.

[Stroos]

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.

[Anonymous]

@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?

[Anonymous]

Hi Merwan,

Do you plan to support these types of columns in the near future?

What about calculated columns, too? 

[merwan]

We will indeed be supporting lookup columns in the near future.Sorry no precise ETA yet, but this is in progress. As for calculated columns, they should be available as read-only dynamic outputs. Since they are calculated on the server side based on access to an item, we wouldn't expose them directly in a Flow. 

[MarceloAP]

This post was created almost 1 year ago, so I gotta ask: we still cant use flows on Lists that has Lookup Fields on it?

Im not trying to EDIT those collums, i just wanna READ OTHER COLUMNS on this List and I'm getting this:

"status": 400, "message": "The field 'XXXXX' is not supported in query. The lookup list is in another web."

[Anonymous]

Still not available?

We have a process that requires this functionality. We are trying to switch away from Nintex, but with basic functionality like this still not available, I don't think we will be able to.

[merwan]

Hey all, 

Support for people, choice, and lookup columns is in internal builds and will be released to production within the coming weeks! We realize this has been a long time coming, but we're very close 🙂

Thanks for your patience.  

Merwan

[Rod-Commtech7]

Looking forward to the release.

Will this support extend to multi-language taxonomy fields?

Regards

[merwan]

The first wave will include choice, lookup, and people with taxonomy coming a little later. 

[Rod-Commtech7]

Given the fact we can now easly create child/parent site lookup fields using a webId in the xml definition, Will the lookup columns handle/respect these parent web (cross site) lookups?

Regards

[UKCAdmin]

Is this working yet?  I have tried to do this and it gives the error below:

I have tried setting an ID manually just to see if it works.  I also changed the lookup to relate by ID, no dice.  I also tried just selecting a value from the drop down in FLOW and still the same error...

{ "status": 400, "message": "A value must be provided for item.\r\nclientRequestId: d8891172-bb6f-4228-a782-f64831029430", "source": "sharepointonlineconnectionprovider-westus.tip0-westus.p.azurewebsites.net" }