I am trying to implement Multi company Management similar to BC in Power apps, I want to add to the user entity a sub grid of allowed companies and the user needs to have 1 as default.
When the user loads the CRM it will show him the records with the default company and he can always switch the company using the ribbon which till now all is fine, the issue is I need a way to filter the data for all pages which I did it using JS with SetFilterXML but the user will always have the ability to clear filter or I would have to turn it off.
Is there a way I could filter the user records retrievals from the beginning or set a filter in the view for each user without updating the saved query or any other way to achieve it??
What I am doing is possible because I saw someone who implemented this before.
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473