Hi,
I have option set field on one screen based on the value selected in option set I want to filter data in gallery in other screen.
Screenshot of Logic:
Screenshot of Error:
Thanks in Advance
Hi @vaishalivyas1,
Could you please share more details about which control you are working with?
I suspect here you are working with the Gallery2 control, if this is the case, then the formula should be changed in the following way:
if(DataCardValue5.Selected.OptionValue = 100000000, SortByColumn(filter('Project Task Billing Codes',
statecode=0 && _cf_projecttaskid_value= Gallery2_1.Selected.cf_projecttaskid),
"cf_name"), SortByColumns(Filter('Project Task Billing Codes',
_cf_projecttaskid_value= Gallery2_1.Selected.cf_projecttaskid),
"cf_name") )
The Error should be caused by refering the own value of the gallery control, and this is not supported.
A control can't have its own items property refering to its own property value.
Regards,
Michael
In Gallery2 I have Project Task and in Gallery2_1 I have Project case. based on value selected in option set on EditScreen1 I want filtered results on Gallery 3.
I have had similar problems when passing a variable from screen 1 to screen 3 (by using a intermediate screen 2).
I learned to never selfassign any variables: for example don't use -> varExtern : varExtern
Try to use it as follows:
Screen1 : Navigate(Screen2;Fade;{varExtern : 'my assigned variable'})
Screen2 : Navigate(Screen3;Fade;{varExternal : varExtern})
Screen3 : here you can use varExternal
User | Count |
---|---|
142 | |
137 | |
78 | |
74 | |
73 |
User | Count |
---|---|
230 | |
177 | |
68 | |
68 | |
59 |