Hi @Anonymous ,
Could you please share a bit more about the "Author" column in your SP List? Is it a custom Person type column?
If you want to filter your Gallery Items based on the creator of the List items, I think there is something wrong with your formula. I have made a test on my side, please consider take a try with the following workaround:
Modify the formula within the OnStart property of the App to following:
Set(
currentUser;
User()
);;
// get all list items
ClearCollect(
allItemsCollection;
MySPList
);;
If(
// users, who can see all the list items
currentUser.Email = "myemail@example.com" || currentUser.Email = "boss_email@example.com";
ClearCollect(
filteredCollection;
allItemsCollection
);
// filter items by current user
ClearCollect(
filteredCollection;
Filter(
allItemsCollection;
'Created By'.Email = currentUser.Email // Modify formula here. Type 'Created By' email rather than Author.Email
)
)
)
Note: If the "Author" column that you mentioned represents the System person field in your SP List, you could not reference it using "Author" column, instead, you should use 'Created By' column.
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
