web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Retrieve index of firs...

Power Apps

Answered

Retrieve index of first matching record in table

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi , I am trying to find the index of the first matching record in a table.

So for this table,

Apple

Orange

Pear

Grape

Melon

I would like to search for "Pear" and get the record index which is 3. How can this be done? The functions such as Find(), LookUp() etc. return the record but not the record index.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous :

If your data source itself does not have an index, I suggest you use the ForAll function.I've made a test for your reference:

My data source:

ClearCollect(YourTable,["Apple","Orange","Pear""Grape","Melon"])

1\Add a text input control-TextInput3

2\Add a button and set it's OnSelect property to:

Clear(Result); /*Result is my custom collection*/ ForAll( YourTable, Collect( Result, { No: CountRows(Result) + 1, /*Create a serial number for each record*/ Value: Value } ) );

Select the button

3\Add a label control and set it's Text property to:

LookUp(Result,Value=TextInput3.Text).No

This is the serial number of the first searched record.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
Thank you very much for the detailed solution! It is exactly what I was looking for.

Was this reply helpful? Yes No

Join the conversation