cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Can Flow update Sharepoint Lists' LookUp Columns ?

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!

 

37 REPLIES 37
Highlighted
Microsoft
Microsoft

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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?

Highlighted
Power Automate
Power Automate

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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. 

Highlighted
Microsoft
Microsoft

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Great - thank you!

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

How soon ? 🙂 @merwan

Highlighted
New Member

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

Highlighted
Frequent Visitor

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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.

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

1.png

Highlighted
Frequent Visitor

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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:

 Snip 1.JPG

 

But then ultimately resolves to only these options.

 

 

Snip 2.JPG

 

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

 

Highlighted
Frequent Visitor

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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.

Snip 1.JPG

 

Snip 2.JPG

Highlighted
Advocate III
Advocate III

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

Highlighted
Regular Visitor

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi Merwan,

 

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

 

What about calculated columns, too? 

 

 

Highlighted
Power Automate
Power Automate

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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. 

Highlighted
New Member

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

Highlighted
Anonymous
Not applicable

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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.

Highlighted
Power Automate
Power Automate

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

Highlighted
New Member

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Looking forward to the release.

Will this support extend to multi-language taxonomy fields?

 

Regards

Highlighted
Power Automate
Power Automate

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

Highlighted
New Member

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

 

Highlighted
Frequent Visitor

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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" }

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (9,521)