Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Create SharePoint list lookup items from excel

I have 2 SharePoint List which using power automate to import from excel.

The 1st SharePoint list call Material Color list with data fields like below


Fabric Color CodeFabric NameColor Name
Metal-Navy BlueMetalNavy Blue


The 2nd SharePoint list call Product Colorway

Product Colorway CodeProduct NameColorway Name
Chair-Metallic ChairMetallic 
Desk-Cheery BlossomDeskCheery Blossom
Plastic Box-Pure White with BluePlastic BoxPure White


The Material Color Code and Product Colorway code from each list are the unique name.


I have another excel list which is a relationship to link up the material color and product color like below.

Excel list - Table 1

Fabric Color CodeStyle Colorway Code
Metal-Navy BlueChair-Metallic 
Metal-Navy BluePlastic Box-Pure White with Blue
Plastic-WhitePlastic Box-Pure White with Blue
Metal-RedDesk-Cheery Blossom


I also create a 3rd SharePoint list with lookup field "Material Color Code" and "Product Color code", to lookup data from both SharePoint list.  

What I want to do is to import the above excel table to the 3rd SharePoint list, then the SharePoint List can lookup the "material color code" and "product color code" from 2 SharePoint list and pull the related data.


I am using Prase Json to get the value from the flow.



But i received below error when I test the flow.



It seems the lookup field in SharePoint list contains and ID which I am not so sure how I can call the value from the ID.  Is there any one can help?  Or there is no way to import excel in this way?


Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,009)