cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
efialtes
Level 8

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
Microsoft Employee

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?

Power Automate Staff merwan
Power Automate Staff

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. 

Microsoft Employee

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Great - thank you!

Rfla
Level 10

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

How soon ? 🙂 @merwan

Rod-commtech
Level: Power Up

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

Stroos
Level: Powered On

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.

Rfla
Level 10

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

Stroos
Level: Powered On

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.

 

Stroos
Level: Powered On

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

CyMarven
Level: Powered On

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?

dimitarsm
Level: Powered On

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? 

 

 

Power Automate Staff merwan
Power Automate Staff

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
MarceloAP
Level: Power Up

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

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.

Power Automate Staff merwan
Power Automate Staff

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

Rod-Commtech7
Level: Power Up

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Looking forward to the release.

Will this support extend to multi-language taxonomy fields?

 

Regards

Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

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

Rod-Commtech7
Level: Power Up

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

 

UKCAdmin
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 189 members 5,382 guests
Please welcome our newest community members: