"View As" showing same user's email multiple times

I am creating a digital diary app. I have a sheet named Diary and each row is a single entry, and I use Add row action to create each entry. I have also used row ID for each entry. I sent the users email along with each entry. I then filter the list by email is signed-in user in order to show only the diary entries of the signed-in user.

When I click on View as, I see the same user’s email multiple times. May I know what is happening? Normally, each user will be shown only once. So, why is it considering each row as from a different user though with the same email.

You must have a users sheet filled up with same emails

Did you use the diary Sheet as your user profiles sheet?

Yes. Made a new User profiles sheet and now it works fine.

1 Like