Hi all,
Still new to Power Apps, and couldn't quite google myself out of this issue.
I have a gallery that I want to filter on partner name using text input, and using a toggle for optional inclusion of completed items.
By default the completed items are hidden.
Below code on items of BrowseGallery1 is working as intended, but has a delegation risk.
If(Toggle1.Value = false,
Filter('Learning Demand',
'Demand Status2' <> "Completed",
StartsWith('Partner Name',TextSearchBox1.Text)),
Filter('Learning Demand',
StartsWith('Partner Name',TextSearchBox1.Text)))
Who can help me solve this?
Many thanks!
Rianne
Solved! Go to Solution.
Assuming that SharePoint is your data source, the problem is that the <> is not delegable.
There's no simple workaround except to use the = operator and to specify all the other status types other than "Completed".
If(Toggle1.Value = false,
Filter('Learning Demand',
'Demand Status2' = "Started" || 'Demand Status2' = "In Progress" || 'Demand Status2' = "etc..",
StartsWith('Partner Name',TextSearchBox1.Text)),
Filter('Learning Demand',
StartsWith('Partner Name',TextSearchBox1.Text)))
Assuming that SharePoint is your data source, the problem is that the <> is not delegable.
There's no simple workaround except to use the = operator and to specify all the other status types other than "Completed".
If(Toggle1.Value = false,
Filter('Learning Demand',
'Demand Status2' = "Started" || 'Demand Status2' = "In Progress" || 'Demand Status2' = "etc..",
StartsWith('Partner Name',TextSearchBox1.Text)),
Filter('Learning Demand',
StartsWith('Partner Name',TextSearchBox1.Text)))
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
200 | |
96 | |
56 | |
51 | |
41 |
User | Count |
---|---|
265 | |
157 | |
83 | |
80 | |
56 |