Hi,
maybe this is obvious, but i am new to powerapps. I have 2 tables:
1. Location table with just one column
Location
A
B
C
2. Transaction table
Transaction; Property; Location
Buy; House; C
Sale; Apartment; A
I want to create dropdown control, where i want to see the list of locations from table 1, which cannot be found in table 2, but there have to be condition that i will check only property "House".
Hope that makes sense
thank you
Jan
Solved! Go to Solution.
Set your items property on the dropdown to the following:
Filter(LocationTable,
!(Location in Filter(TransactionTable, PropertyType="House").Location)
).Location
This will first filter the Transaction table based on only records with property types of "House" and will feed that filtered set of locations to the IN operator of the LocationTable filter.
Notice the ! operator. This is the same as Not. (since you mention you are new to PA, just mentioning it so you don't get confused)
So, in english this filter reads as follows:
FilterTheRecords of LocationTable if the Location is NOT in the Filtered records of the Transaction table where the property type is "House".
Pretty sure that's what you're looking for.
Enjoy
Hi Randy,
that work like a charm, thank you so much, very appreciated.
Jan
Set your items property on the dropdown to the following:
Filter(LocationTable,
!(Location in Filter(TransactionTable, PropertyType="House").Location)
).Location
This will first filter the Transaction table based on only records with property types of "House" and will feed that filtered set of locations to the IN operator of the LocationTable filter.
Notice the ! operator. This is the same as Not. (since you mention you are new to PA, just mentioning it so you don't get confused)
So, in english this filter reads as follows:
FilterTheRecords of LocationTable if the Location is NOT in the Filtered records of the Transaction table where the property type is "House".
Pretty sure that's what you're looking for.
Enjoy
Hi Randy,
that work like a charm, thank you so much, very appreciated.
Jan
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
188 | |
80 | |
50 | |
38 |
User | Count |
---|---|
306 | |
251 | |
122 | |
73 | |
55 |