cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Redhoezth07
New Member

Create a item from Excel File to Sharepoint List when the column is a lookup

Good day everyone,

 

I am having an issue creating a new item in my Sharepoint List taking into account my data pulled from an Excel file.

 

When I try to select the vendor ID, which is a lookup column from another sharepoint list, I am not able.

 

Redhoezth07_0-1607210375273.png

 

Is there a way to select this column from my Excel and add to this column?

 

Thank you very much.

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Redhoezth07 

The issue is that Flow wants you to provide the ID of the item in the lookup list - not the actual value.  So, you'll need to use a Get Items action with an OData filter query to find the item in your lookup list.  The assign to ID to a variable or Compose action.  When creating the SharePoint list item, reference the variable or compose action.

Here is a link for more information on creating OData query filters.

Let me know if you need more help.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

2 REPLIES 2
ScottShearer
Super User
Super User

@Redhoezth07 

The issue is that Flow wants you to provide the ID of the item in the lookup list - not the actual value.  So, you'll need to use a Get Items action with an OData filter query to find the item in your lookup list.  The assign to ID to a variable or Compose action.  When creating the SharePoint list item, reference the variable or compose action.

Here is a link for more information on creating OData query filters.

Let me know if you need more help.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Hi ScottShearer,

 

It is working. 

 

Thank you for your response.

 

 

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,157)