Hi @Greeny1989 ,
Could you please share a bit more about the 'Signed Out?' column and 'Marked as safe' column in your SP List? Are they both Yes/No type column?
Based on the formula that you mentioned, I think there is something wrong with it. Actually, it is an known issue with "Yes/No" type of SP List within PowerApps app, the TRUE or FALSE value would not work with the Yes/No type column of the SP list within a Filter function.
Please check my response within the following thread for more details:
https://powerusers.microsoft.com/t5/General-Discussion/Filter-source-field-true-selects-rows-where-field-is-false/td-p/156553
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Properly-filter-SharePoint-Yes-No-column/idi-p/158375
On your side, please take a try with the following workaround:
Set the Items proeprty of the Gallery1 (first Gallery) to following:
Sort(
Filter('Site Sign In','Signed Out?' = 0 && 'Marked as safe' = 0),
Created,
Ascending
)
Set the Items proeprty of the Gallery2 (second Gallery) to following:
Sort(
Filter('Site Sign In','Signed Out?'= 0 && 'Marked as safe' = 1),
Created,
Ascending
)
Note: I suppose that the 'Signed Out?' column and 'Marked as safe' column are both Yes/No type column.
In addition, please also take a try with the following workaround:
Set the OnStart property of the App control to following:
ClearCollect(
RecordsCollection,
'Site Sign In'
)
Set the Items proeprty of the Gallery1 (first Gallery) to following:
Sort(
Filter(RecordsCollection,'Signed Out?' = false && 'Marked as safe' = false),
Created,
Ascending
)
Set the Items proeprty of the Gallery2 (second Gallery) to following:
Sort(
Filter(RecordsCollection,'Signed Out?'= false && 'Marked as safe' = true),
Created,
Ascending
)
Add the following formula within the "flow button" (which you used to mark the user as safe) to following:
ClearCollect(
RecordsCollection,
'Site Sign In'
)
then re-load your app (fire the OnStart property of the App), then check if the issue is solved.
Best regards,
