cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AJ_vizMan
Helper I
Helper I

Display item to correct admin team

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.

 

2 REPLIES 2
v-jefferni
Community Support
Community Support

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.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

AJ_vizMan
Helper I
Helper I

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'

AJ_vizMan_4-1629375999825.png

Have maintained admin related information in Sharepoint list

AJ_vizMan_5-1629376159172.png

Appreciate your help. Looking forward to learn.

 

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (807)