Hello, i have created a powerapps which is to be used by requesters to submit tickets. And admin team works on the submitted tickets. And there are 3 different admin teams to work on the ticket at 3 levels e.g. one admin team works on ticket and assigns to next team then it should be visible to next team 2 and when team 2 work on ticket then it should be visible to team 3.
Fields used in app : Task Status, Admin Team group, Ticket assigned to Individual etc.
Could you please help how to achieve the required functionality.
Hi @AJ_vizMan ,
Basically you need to filter the tickets gallery items by task status and admin teams. So, below are the steps:
1\ Assuming you have a table which stores all users with the groups they are in, filter this table to check if current user belongs to any admin group.
OnVisible of the screen:
Set(varGroup, LookUp(UsersTable, Email = User().Email).UserGroup);
2\ Filter the tickets Gallery base on the user group and task status select dropdown:
Filter(TasksTable, 'Admin Team group' = varGroup && 'Task Status' = TaskStatusDropdown.Selected.Value)
I am not able to provide a whole solution here since this would depend on the whole scenario design and data backgrounds. You will need to provide:
1\ All the tables related to this scenario, table structure, typical data or some examples.
2\ App design including screens, controls, important control property settings.
Hope this helps.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Hi @v-jefferni - Thank you for your response.
I could see that filtration of tickets is possible by existing logic.
Sorry if you see my requirement has changed. But, requirement is that once current admin team has completed their work on ticket then they should be able to assign the ticket to next team :
To achieve this functionality, we have used 'Move to Next' button and 1st admin team person will click on it and 'Assigned to group' column should get name of next admin group. Currently, we are getting 1st admin group value using below formula :
First(SortByColumns(Filter(MassUploadCategorySubCategory, SubCategoryName = EditTicketfromSubcategoryValue.Selected.SubCategoryName),"ForSorting",Ascending).AssignedGroupName)
Image of ticket screen with 'Move to Next Button'
Have maintained admin related information in Sharepoint list
Appreciate your help. Looking forward to learn.