Filter data based on user login

Copper Contributor

Hi all, hope you are doing good. I have a query, for suppose if I host a file online and when a user login, based on their information present in the sheet, it will just show their data and not others. Kindly advise. Thanks in advance 

2 Replies

@vmmanish 

One way to filter data based on user login is by using Row-Level Security (RLS). RLS can be used to restrict data access for given users by filtering the data based on the user’s login (typically their email address) . However, this will require a model change. If you saved on Sharepoint (Row Level Security).

 

I hope this helps!

I guess you need build a dynamic web and database like below:
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile=