Filter unique order numbers and transfer it to a table that will hold the unique values

[Hussein_Osseily]

Hello Everyone, 

lets say i have a table "A" That has a Column "Order Numbers" that has duplicate values 
Am trying to transfer the unique order numbers to a table "B" that will hold the unique order numbers 
what i have done so far (but didnt work): 

Created an action of type : add a new row to another table using values from this row

For a Redord of this table         Table A
Table to add to                            Table B

[ID] = UNIQUEID()

[Order Numbers] = [Order Numbers]

Prominence: Dont Display

Created another action of type : Excute an action on a set of rows 

For a record of this table       Table A

Referenced Table                    Table B

Referenced Rows = UNIQUE(Table A [Order Numbers] ) 

Referenced Action = The Action i created in Step 1
Prominence: Display as Primary

when i test the Referenced rows expressions it works and gives a list of the unique order numbers (see below)

But when i execute the action in the application nothing happens at all.

Any advice or explanation on what am doing wrong here would be highly appreciated.

Thanks in advance

[Hussein_Osseily · Accepted solution]

Dear @SkrOYC , 

Thanks for your response, I haven't met the "LOOP" you mentioned in Appsheet yet , woul you please explain me more ? 

Beside that, I have tried to approach a solution by using a BOT that will be triggered once an update happens with a condition NOT(IN([ORDER NUMBERS],Table B[ORDER NUMBERS]))

Step 2: Wait until ISNOTBLANK ([ORDER NUMBERS]) 

Step 3: Run Data Action
[ID] = [ID] (Column Type TEXT)
[ORDER NUMBERS] = [ORDER NUMBERS] 

When I Excute the data action from the application , it does the job and transfer these two columns to the meant table , but when I trigger it from the BOT Testing , I get this error below: 

Failed: Error: Perform DataAction 'UNIQUE ORDER NUMBERS' failed because Row having key '6917faea' in table 'TABLE B' in field '_RowNumber' is required to have a value

Update: _rowNumber , Unselected the required tick and it works perfectly now

Your help is highly appreciated.

Thanks in advance
 

[SkrOYC]

---

@Hussein_Osseily wrote:

Referenced Rows

---

This expects a list of ID/Keys in which the action is going to be executed.

It seems you need some kind of loop

[Hussein_Osseily · Accepted solution]

Dear @SkrOYC , 

Thanks for your response, I haven't met the "LOOP" you mentioned in Appsheet yet , woul you please explain me more ? 

Beside that, I have tried to approach a solution by using a BOT that will be triggered once an update happens with a condition NOT(IN([ORDER NUMBERS],Table B[ORDER NUMBERS]))

Step 2: Wait until ISNOTBLANK ([ORDER NUMBERS]) 

Step 3: Run Data Action
[ID] = [ID] (Column Type TEXT)
[ORDER NUMBERS] = [ORDER NUMBERS] 

When I Excute the data action from the application , it does the job and transfer these two columns to the meant table , but when I trigger it from the BOT Testing , I get this error below: 

Failed: Error: Perform DataAction 'UNIQUE ORDER NUMBERS' failed because Row having key '6917faea' in table 'TABLE B' in field '_RowNumber' is required to have a value

Update: _rowNumber , Unselected the required tick and it works perfectly now

Your help is highly appreciated.

Thanks in advance
 

[SkrOYC · Accepted solution]

The fact is that looping is an advance and kind of workaround scenario.
So don't expect it to be any easy, I'm sorry.

About this:

---

@Hussein_Osseily wrote:

Perform DataAction 'UNIQUE ORDER NUMBERS' failed because Row having key '6917faea' in table 'TABLE B' in field '_RowNumber' is required to have a value

---

It seems you have [_RowNumber] as a required field, uncheck that option.

[Hussein_Osseily]

Thanks for the resources regarding the LOOPING.

---

@SkrOYC wrote:

The fact is that looping is an advance and kind of workaround scenario.
So don't expect it to be any easy, I'm sorry.

About this:

---

@Hussein_Osseily wrote:

Perform DataAction 'UNIQUE ORDER NUMBERS' failed because Row having key '6917faea' in table 'TABLE B' in field '_RowNumber' is required to have a value

---

It seems you have [_RowNumber] as a required field, uncheck that option.

---

This solved the issue with the BOT
in addition to that, my approach above with the BOT solved my problem in getting the unique values from a table.

Thanks