cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
efialtes
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!

 

38 REPLIES 38

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
Frequent Visitor

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

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?

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

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! 🙂

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!

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
Frequent Visitor

Hi merwan - done. Thanks in advance.

Hi @merwan ,

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

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

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. 

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

 

 

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

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

Scott3
Frequent Visitor

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

@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
Frequent Visitor

 
Scott3
Frequent Visitor

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
Frequent Visitor

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

cg4life09
Advocate II
Advocate II

Is this still an issue? Seems like this is an old thread but I am still getting a error when trying to update a lookup column.

 

"The 'inputs.parameters' of workflow operation 'Update_file_properties_2' of type 'OpenApiConnection' is not valid. Error details: The API operation does not allow writing a value for parameter 'item/Subject[0]/Value'. This parameter is read only."

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (27,926)