I am having some odd behavior ... and I want to know the best practice way for doing this ... I have a gallery that has plenty of rows.
If I select a specific aircraft in the DdAircraftFilter dropdown list there is no problem. Filter(CollectionComplianceApproval,ComplianceStatus.Value="Not Started" && Title=DdAircraftFilter.Selected.Result && IpPaxNameSearch.Text in TravelerName && IpRouting.Text in Routing && PaxOnTrip=true)
The gallery filters just fine when I select a value from the dropdown list (DdAircraftFilter) But I have AllowEmptySelection set to true for the dropdown list in the hope that if the value is empty it will show all the rows that meet the criteria ignoring the dropdown. But that's not working. This seems extreme but should I do ...
If(IsBlank(DdAircraftFilter.Selected),Filter(CollectionComplianceApproval,ComplianceStatus.Value="Not Started" && IpPaxNameSearch.Text in TravelerName),Filter(CollectionComplianceApproval,ComplianceStatus.Value="Not Started" && Title=DdAircraftFilter.Selected.Result && IpPaxNameSearch.Text in TravelerName))
That does work but is there a cleaner more efficient code way to do that... Basically it's a simple if... If(IsBlank(DdAircraftFilter.Selected), code without the filter by the dropdown value, else filter with the dropdown value
The other thing is that allow it will default to the blank row once you select an aircraft you can't go to empty again... The items value for the dropdown is ... Distinct(ComplianceApproval,Title) I figured the empty value would remain an option somehow. How do I achieve that?
Solved! Go to Solution.
Hi @sasrsc :
Could you tell me if this is what you need:
If so,I have two suggestions:
Filter(CollectionComplianceApproval,
ComplianceStatus.Value="Not Started" && (IsBlank(DdAircraftFilter.Selected) || Title=DdAircraftFilter.Selected.Result) && IpPaxNameSearch.Text in TravelerName)
Best Regards,
Bof
Hi @sasrsc :
Could you tell me if this is what you need:
If so,I have two suggestions:
Filter(CollectionComplianceApproval,
ComplianceStatus.Value="Not Started" && (IsBlank(DdAircraftFilter.Selected) || Title=DdAircraftFilter.Selected.Result) && IpPaxNameSearch.Text in TravelerName)
Best Regards,
Bof
ok, thank you that makes it easier it works which is fabulous.
Just simply saying if it's blank or the selected value. wow, so simple.
sometimes you can't see the forest for the trees.
Hadn't thought of doing a combo.
thank you v-bofeng-msft
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
195 | |
46 | |
45 | |
42 | |
36 |
User | Count |
---|---|
269 | |
82 | |
81 | |
75 | |
69 |