Get second data from SP List

(0) Share

Report

Posted on by firda59

372

Hello,

Can anyone help me, I want to get my second data from SP List. So this is my scenario:
1. I have database 'Process Production' which has all list of 'No. Component'. This database contains sequence process of each 'No. Component'.

2. Like this:

no component	machine	process
1	aaa	blabla
1	bbb	blibla
1	ccc	blable
2	bbb	blabli
2	ccc	blabla
2	aaa	blabla
2	ddd	blabla

3. I have button submit to patch data machine in different SP List (tracking)

I know the formula for get first data form that SP List, I using this:

'Current Area': First(Filter('Process Production', 'no component' = SOPOWBS_1.Text)).'machine'

But I dont know when I want to get second data, does anyone know? Thankyou!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @firda59 ,

The second record would be

'Current Area': Index( Filter( 'Process Production', 'no component' = SOPOWBS_1.Text ), 2 ).'machine'

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Hi @WarrenBelz

Thankyou!

Was this reply helpful? Yes No