Power app Filter with two conditions from 2 dropdown.

[Pariyes]

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.

[365-Assist]

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

[v-yujincui-msft · Accepted solution]

Hi @Pariyes ,

Maybe you could try the following formula:

Filter(DataOrderMat, D3SupplierCode=DDSupplierCode.Selected.D3SupplierCode,D3PRNumber=DBLPR.Selected.Result)

Filter(DataSource, Condition1, Condition2)

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup#step-by-st...

Best Regards,
Charlie Choi