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)))
User | Count |
---|---|
246 | |
103 | |
82 | |
49 | |
42 |