Share
Report
232Hello,
I have a power app where I want to display the information from my SP list based on the user that's logged in and the group that is associated with the user and record's category in my SP list. The main list that is being modified by users is my "Employee Activity List". This is connected to different sets of SP source lists. One of these lists is called "Manager Group Source List". In this list, I am setting the categories from a lookup and setting them to the group field that corresponds with those categories. I have provided detailed screenshots to show what I am trying to accomplish:
So for example, if my employee is a part of the 'Growth' category. I want it to only display records in the growth category for the user that is a part of that 'Growth' person group. (I hope this makes sense lol)
(Employee Activity List)
(Same SP list just further down the record)
(When you click the name of the manager group)
(Power Apps Screen)
(Current Function for PowerApps Screen)
SortByColumns(
Filter(AddColumns('Employee Activity List', "TextManagerGroup", 'Manager Group'.Value),
Status.Value = "Needs Approval",
),
"TextManagerGroup", Ascending,
"SubmissionDate", Descending
)
All responses (
Answers (
