Forum Discussion
vmmanish
Mar 31, 2023Copper Contributor
Filter data based on user login
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
- peiyezhuBronze ContributorI guess you need build a dynamic web and database like below:
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile= - NikolinoDEPlatinum Contributor
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!