Hi,
I have this data
| PO Number | Joint Number | Detail | Name |
| 12 | g-1 | fsgs | |
| 12 | g-1 | fdfe | |
| 12 | g-2 | fesg | |
| 12 | g-3 | fwtw | |
I used this formula in gallery (which is has different datasource, not 'Welder Log'):
Patch(
'WELDER LOG',
First(
Filter(
'WELDER LOG',
'Joint Number' = ThisItem.'Joint Number',
'PO Number' = POno.Text
)
),
{Name: Welder.Selected}
)
But it just for 1 rows, I want rows who has same Joint Number & PO Number like this:
| PO Number | Joint Number | Detail | Name |
| 12 | g-1 | fsgs | |
| 12 | g-1 | fdfe | |
| 12 | g-2 | fesg | deni |
| 12 | g-3 | fwtw | deni |
Can anyone help me? thankyou!
