Detect Data Sequence

(0) Share

Report

Posted on by firda59

372

Hello,

I have a process sequence database, where the contents are the product name and the process name. I want when my tracking database shows the process name of product XXX in line 3, then my text input can automatically detect the process name in line 4.

When my tracking database shows the product process name XXX in line 4, my text input can automatically detect the process name in line 5.

and keep going until the final line of the process name sequence of the product, then my input text can automatically detect the words "process is complete".

This is the example of my process sequence database.

Product	machine	process
xxx	aaa	blabla
xxx	bbb	blibla
xxx	ccc	blable
yyyy	bbb	blabli
yyyy	ccc	blabla
yyyy	aaa	blable
yyyy	ddd	blablu

How to do it? Can anyone help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @firda59 ,

You can number the records sequentially in this way

ForAll(Sequence(CountRows(databaseName),1,1),Patch({ItemNo:Value},Index(databaseName,Value)))

I assume you tracking the item by select the item in a gallery(Gallery), then if you want to get the next item's process ,you could try this formula:

With( {tableAddItemNo:ForAll(Sequence(CountRows(databaseName),1,1),Patch({ItemNo:Value},Index(databaseName,Value)))}, LookUp(tableAddItemNo,ItemNo=LookUp(tableAddItemNo,Product=Gallery1.Selected.Product && machine=Gallery1.Selected.machine && process=Gallery1.Selected.process).ItemNo+1).process )

Best Regards,
Bof

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

hi @v-bofeng-msft

I write the formula in text input:
With(
{tableAddItemNo:ForAll(Sequence(CountRows(AllRecapSOW),1,1),Patch({ItemNo:Value},Index(AllRecapSOW,Value)))},
LookUp(tableAddItemNo,ItemNo=LookUp(AllRecapSOW,'# No. PO'= ListKomponen.Selected.'SO/PO/WBS' && 'Area '=ListKomponen.Selected.'Current Location' && 'Proses Name'=ListKomponen.Selected.'Proses Name').ItemNo+1).'Proses Name'
)

I got error like this: Name isn't valid. 'ItemNo' isn't recognized.

Can you help me to fix it? Thank you

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @firda59 ,

Could you please check if this record really exists?

LookUp( tableAddItemNo, ItemNo=LookUp( AllRecapSOW, '# No. PO'= ListKomponen.Selected.'SO/PO/WBS' && 'Area '=ListKomponen.Selected.'Current Location' && 'Proses Name'=ListKomponen.Selected.'Proses Name' )

Best Regards,

Bof

Was this reply helpful? Yes No