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

How to LookUp a SharePoint List based on column index?

Say i have a list like such:

 

Name,Age,Town

Jake,18,London

Tom,21,Paris

 

And i want to LookUp Tom's Town: LookUp(List, Name = "Jake", Town), but instead of referencing Town to get the town, i want to reference the index instead. Is this possible?

1 REPLY 1
Dual Super User
Dual Super User

Re: How to LookUp a SharePoint List based on column index?

Hi @jaiyeko 

 

By Index I assume you mean the ID column

Try

 LookUp(List, Name = "Jake", ID)

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 328 members 6,605 guests
Please welcome our newest community members: