Unanswered

How to get value from SharePoint list based on another field value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So the idea is that upon choosing the location, the user have to choose a zone(from SharePoint list) along with the product(from the same SharePoint list) in the category on the right. Hence, certain zones(for example "2c"), will only have certain type of product(for example "hammer") and that is what i am trying to show here in the drop down box. However, currently the dropdown box for the product is showing all products in all the zones. So, how do i limit it to only showing the specific product in the specific zone.

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If there is mapping in your Master list of Location Zone and Products then you can use the below formula.

Zone items: Filter(YourDataSourceName,Location=LocationDropdownName.Selected.YourColumnNameOrValue)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry but i am quite new so i am not sure what is mapping
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In the backend list you have a structure something like below ?
Location Zone Products
Location1 Zone 1 Product 1
Location 2 Zone 1 Product 3
Location 2 Zone 2 Product 2

Then if you filter Zone dropdown based on Location 2 you will get Zone 1 and Zone 2 in dropdown.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes that was what is required of this app
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Ok, please check if below formula works for you.

Zone items: Filter(YourDataSourceName,Location=LocationDropdownName.Selected.YourColumnNameOrValue)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PriyankaGeethik

Sorry but could you reference from the bottom and help me write the line out because i am actually very new to coding and i tried but there is error from the one i tried. You can reference the below picture to help with the names of the individual items. Thank you.