cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

This is a known issue that we're working to address which occurs if you edit a Flow that uses a Choice field. To workaround the issue, please delete and recreate the Update item or Create item action in your Flow. 

 

Apologies for the inconvenience. 

 

 

posterme
Level: Powered On

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi,

 

unfortunately, this doen't work for me. I recreated the complete flow-process. 

I want to add the answers from Forms into a sharepoint lists; if i add only value in default text fields - all works.

If I want to add Value to a Choice-Field -> Error: A value must be provided for item. clientRequestId

 

Choice fields are configured, that own values are allowed...

 

BR,

Philip

Anonymous
Not applicable

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi Merwan,

 

Supposedly, "People" can be used as dyanmic outputs in other actions.

 

I have a list with a person column, which the user fills in.

When the item is created, Flow should pick up the person field, and send an email to the person specified in the field.

 

However, when I make the flow:

When an item is created or modified in the list

Send an email

and look for dynamic content for the To field, there is no dynamic content. I can't pick up the Person from the list

 

Is this expected behaviour?

Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi @Anonymous, People fields are indeed supported as dynamic outputs in other actions. For example, I have a Person field called "Backup Engineer" in my list. In Flow, the Backup Engineer field is shown along with properties like DisplayName, Department, JobTitle, and most importantly Email.

 

To help troubleshoot, can you please send us screenshots of your list schema (similar to the second screenshot below) and your Flow definition (like the first screenshot) at Microsoft Flow Developers <flowdev@service.microsoft.com>? 

 

PeopleDynamicOutputs.png

 

ListSchemaExample.png

 

Anonymous
Not applicable

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi Merwan!

 

Sorry I wasn't able to find and remove my comment after I had posted it. Turns out I had a problem with my connections which resulted in gateway issues so I couldn't find any dynamic content. It's working beautifully! 🙂

Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi @posterme, can you send us a screenshot of your list schema and your flow at Microsoft Flow Developers <flowdev@service.microsoft.com>? I wasn't able to repro the below. Thanks!

Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi @posterme, can you send us a screenshot of your list schema and your flow at Microsoft Flow Developers <flowdev@service.microsoft.com>? I wasn't able to repro the below. Thanks!

posterme
Level: Powered On

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi merwan - done. Thanks in advance.

bloodoff
Level 8

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi @merwan ,

That known issue is still happening, isn't it?

It is at least to me now (March 2018).

Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hi @bloodoff, unfortunately the issue still repros. A previous fix introduced a regression and was subsquently rolled back. We are working on a new fix that will address this issue in the coming weeks. 

SantoshR
Level: Powered On

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Is this still the case?

Are we able to read Lookup columns in SharePoint library inside MS Flow?

We are specifically looking to read Approval Status column which is added to Library after applying Versioning settings

 

 

bloodoff
Level 8

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

@SantoshR Lookup columns in general - yes we can read and write those.

Approval Status - not yet, as far as I know, but I think I saw it would be available soon 🙂

Power Automate Staff merwan
Power Automate Staff

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

@KeremY - to comment on the visibility of the Approval Status column. The issue should no longer be happening. 

Scott3
Level: Power Up

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Is it Possible to Update SharePoint List LookUp Column using Flow, where the LookUp Value is coming from a Microsoft Form?

bloodoff
Level 8

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

@Scott3

If I understood you correctly, then yes, it is possible. If I got it wrong, please let me know.

1) Aux list with colors

1.png

2) Main list with a LookUp column that gets them from Aux list.

2.png

3) MS Forms form with 3 color choices

3.png

4) Flow you need to create

4.png

5) Result

5.png

Scott3
Level: Power Up

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

 
Highlighted
Scott3
Level: Power Up

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Thank you very much for the assistance! It did work. The only caveat was that the list that I used twas created by the "Import" app using the .xls/.xlsx , whiche does not seem to create a distinguished 'Title' Column. So I was able to create the list again and 'import from CSV' App which did exactly what was needed. Thanks again!

Dandalf
Level: Powered On

Re: Can Flow update Sharepoint Lists' LookUp Columns ?

Hello! Sysadmin from the far future here, wondering if this functionality was ever added.

 

I'm looking to update a people lookup column with data from a flow. Ideally I would update that column directly from powershell, but that functionality doesn't seem to exist in a reasonable form, so I'm using powershell to make a list item which triggers a flow to make another list item. Thanks 🙂

 

Dan

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: 366 members 6,840 guests
Please welcome our newest community members: