Power Platform Community Forum Thread Details

Hi, I am trying to set a condition in filter gallery as shown below

Sort(Filter('Exit audit data','Teamupdate condition'="Pending for action"),Created,Descending)

The 'teamupdate condition' in the SharePoint list is a conditional column with the formula provided below

=IF(AND([Last working date]<=TODAY(),[Overall status.]<>"Retained",[Teamupdate email]="Pending"),"Pending for action","No action required")

I can see three records under 'Pending for action' in SharePoint but in the Powerapps I can see only one record.

Categories:

Error in filter gallery