Hi community,
I don't able to resolve that: I have a table where I filter some records of a List. In one field I have user name but some record username are empty. With that filter the result is that the table show me only record that username are fill in, but I ha ve several record with username empty. I want see all record. Could you help me? Many thanks
Filter(myList;StartsWith(value1.Value; drpValue1.Selected.Value) &&
StartsWith(value2;txtValue2.Text) &&
StartsWith(UserID.DisplayName ;txtname.Text)
);
Hi @Giorgio67 ,
Do you mean show records that both meet the DisplayName search criteria and records that don't have user names, on basis of the first two criteria, right?
If so, please try with this.
Filter(myList;
StartsWith(value1.Value; drpValue1.Selected.Value) &&
StartsWith(value2;txtValue2.Text) &&
(StartsWith(UserID.DisplayName ;txtname.Text)|| UserID.DisplayName=Blank())
);
Hope this helps.
Sik