cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CindyZ
Level: Powered On

Using a Lookup Column to Populate a Field

I have List (List 1) and a Document Library (List 2). I'm trying to attach documents to a specific record (list 1) I've built with Power Apps and then have Flow copy those documents over into the document library with the correct metadata.  Everything is working beautifully, EXCEPT, I cannot figure out how to get the information from the List 1 (text field) to populate the List 2 (lookup column) via Flow.  Hopefully, the illustrations will help clarify.  Any guidance -- I've searched and searched and can't seem to find my answer. FlowDocumentLibrary.jpgList 2 (Document Library that requires information be populate into the lookup field.FlowLookupField.jpgThe flow on List 1

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Level 10

Re: Using a Lookup Column to Populate a Field

Hi CindyZ,

According to your description, you want to copy the Attachments from a list to a library, and update the metadata together.

There is a column named ‘Matter Name’ in list, you want to insert this value into the lookup column ‘investigation’ in the library.

I have made a flow for your scenario, please check it for a reference.

You need choose the Item Id in the Investiquation ID field.

15.PNG

Best Regards,

Zhongys

3 REPLIES 3
ck25415
Level 8

Re: Using a Lookup Column to Populate a Field

@CindyZ

 

As far as I know, in the update item action, a lookup field will only accept the values from the dropdown or you could enter the id of the lookup value if you click on custom value.

 

Thanks,

CindyZ
Level: Powered On

Re: Using a Lookup Column to Populate a Field

Thanks for your reply. I may wind up having to go with the ID.  I was sure hoping not!  

v-zhos-msft
Level 10

Re: Using a Lookup Column to Populate a Field

Hi CindyZ,

According to your description, you want to copy the Attachments from a list to a library, and update the metadata together.

There is a column named ‘Matter Name’ in list, you want to insert this value into the lookup column ‘investigation’ in the library.

I have made a flow for your scenario, please check it for a reference.

You need choose the Item Id in the Investiquation ID field.

15.PNG

Best Regards,

Zhongys

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 50 members 4,311 guests
Please welcome our newest community members: