I'm going to do a filter with two conditions. How from 2 dropdown?
please teach me
PR No. : Code > Distinct(DataOrderMat,D3PRNumber)
Supplier Code : Code > Filter(DataOrderMat,D3PRNumber = DBLPR.Selected.Result).D3SupplierCode
GALLERY : Code > Filter(DataOrderMat, D3SupplierCode=DDSupplierCode.Selected.D3SupplierCode)
Where should I write the code?
Data
Now I have that problem. It can only filler with Supplier Code, cannot filler PR No.
Solved! Go to Solution.
Hi @Pariyes ,
Maybe you could try the following formula:
Filter(DataOrderMat, D3SupplierCode=DDSupplierCode.Selected.D3SupplierCode,D3PRNumber=DBLPR.Selected.Result)
Filter(DataSource, Condition1, Condition2)
Best Regards,
Charlie Choi
Here is great video that explains. Power Apps Sort and Filter on Multiple Columns - YouTube
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist
Hi @Pariyes ,
Maybe you could try the following formula:
Filter(DataOrderMat, D3SupplierCode=DDSupplierCode.Selected.D3SupplierCode,D3PRNumber=DBLPR.Selected.Result)
Filter(DataSource, Condition1, Condition2)
Best Regards,
Charlie Choi