Hi All,
I have a PowerApp form with 3 column - Goods/Services, Category, VendorName.
| Control | Goods/Services | Category |
| Value | Goods | A, B, C |
| | Services | D, E, F |
if(Goods is selected){
apply filter on Category[] to load: [A,B,C];
}
else{
apply filter on Category[] to load: [D,E, F];
}
Filtered Vendors are rendered from a Vendor database where it need to filter based on the category of Goods/Services selected. Below is the Vendor database list sample.
| Vendor | Category of Goods(multi-select) | Category of Services(multi-select) |
| Vendor1 | B, C | F |
| Vendor2 | | D, E |
| Vendor3 | A, C | |
| Vendor4 | A, B, C | D, E, F |
The expected functionality is "Get the list of vendors who provide the selected Category of Goods/Services."
Eg: if end user select Goods and Select Category A, Vendor should load : Vendor3, Vendor4.
if end user select Services, and select Category F, Vendor should load: Vendor1, Vendor 4
How to implement this with usual practice without getting delegation warning?
Is such complexity be implementable using REST API or POwerAutomate?
Please suggest.
@WarrenBelz @Ethan_R @ShaneYoung @RezaDorrani @PowerApp4
