
Announcements
Hi,
I have a Dataverse table of the type 'Activivity' that includes a column of the type 'Choice'. In PowerApps, I can filter a gallery based on the selection from a previous gallery, but have been unable to filter the same gallery using the choice column.
I have followed some guidance here, but to no avail:
Power Apps Guide - Dataverse - How to filter Dataverse choice columns - Power Apps Guide - Blog
Details are below. Any help is welcome.
Table name: 1_Action_Trackers
Column Name: Activity_Status
Formula being used
Filter('1_Action_Trackers',Action_Owner.'Full Name'=Gallery2_1.Selected.'Full Name' && Activity_Status[@Activity_Status].Open)
Error message:
Column Activity_Status settings
Table Properties
If any folk are interested, my issue turned out to be with the column name reference. In the new powerapps view, I could not see the table reference I needed to use to construct the correct formula. In the end I was able to obtain it by going into classic view and checking the details there.
My formula to filter the gallery so only Open statecode records showed was as follows (noting it also includes a date picker function):
| If(IsBlank(DatePicker1_1.SelectedDate), Filter('1_Action_Trackers', 'Activity Status'= 'Activity Status (1_Action_Trackers)'.Open), Filter('1_Action_Trackers','Due Date'<DatePicker1_1.SelectedDate, 'Activity Status'= 'Activity Status (1_Action_Trackers)'.Open)) |