web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Display item to correc...
Power Apps
Unanswered

Display item to correct admin team

(0) ShareShare
ReportReport
Posted on by

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.

 

Categories:
  • v-jefferni Profile Picture
    Microsoft Employee on at

    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 Profile Picture
    on at

    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.

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 139

Last 30 days Overall leaderboard