Forum Discussion
Permisions view
There's not a great way to do this natively in SharePoint. You'd have to add a field for the manager to the SP list and set it with Power Automate (there's a "get manager" action). Once you have it populated, you can set the filter for the view to be Manager = [Me] OR <name of your other user field> = [Me].
It's much easier to do this type of thing using row-level security in Power BI, if you're open to that route. Power BI can connect to SP lists as a source and display clickable links to the items in a table, much like a view, and you can add some other data visualizations as a bonus.
Alternately, you could also do it in a canvas Power App probably, but it'd take quite a bit longer to set up if you're not a frequent Power Apps user already.
I tried to get this from powerautomate to power apps but I dont know how I can do this.Because I stay in point where I get records from my team member and i dont know how i can put this collection back to powerapp
- If you're already using Power Automate, you can skip the Power Apps bit entirely and just send the data back to the SharePoint list. So for a given item (on created or modified trigger), "get manager" for the people field on the item, then do an "update item" and feed it the manager email address from the "get manager" step and have it put it into a people column (you'd need to add the field to the list if it doesn't exist already). Then just use that field in the view filters.