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 / List Gallery item from...
Power Apps
Unanswered

List Gallery item from multiple SharePoint list

(0) ShareShare
ReportReport
Posted on by 1,119

Hello there,

 

Need a helping hand again here. We are developing a Helpdesk application for various department. The User form is common across all departments. But each department has its own SharePoint list. On the user screen we have two option.

 

1. Creating a ticket

2. Viewing tickets

 

Our requirement is when user creates a ticket, based on the department, we need to patch the respected department Sharepoint list. Example, if the user raise a ticket for IT department, the IT deapartment list must be patched. If user select HR department, HR dept. sharepoint list must be patched.

 

Likewise, when the user go and view their tickets, the gallery must be pulling the data from where ever the his/her data exists in the list based on the his email id.

 

Is that possible ?

 

Plan B:

 

if i do that in single SharePoint list, we have auto ticket number generation challenge.  Because each department needs a ticket number in specific format. The department want their department id to be prefixed with the ticket number. I am not sure if this is possible, because in SharePoint list i worked on autogenerating number for predefined format, and not dynamic based on any condition.

 

Please guide which one would be feasible and most suitable.

 

 

Categories:
I have the same question (0)
  • Nogueira1306 Profile Picture
    7,390 Super User 2024 Season 1 on at

    Plan B should be better.

    For Plan A:

    Do a Switch or a If to choose the department of the user and, deppending of the department, you do a different patch. To view the tickets I would say you have 2 options:
      1. Create a screen with all departments and when the user selects one, you navigate to a certain screen that has the gallery of that department
      2. Create a nav bar with the name of the departments and, when you click on "Systems", for example, you show the Systems gallery and hide the others. When you click "Power Apps", you hide the others and show "Power apps" and so on

     

    If you need additional help please tag me in your reply and please like my reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️!

    Best regards,
    Gonçalo Nogueira

    Check my LinkedIn!

    Check my User Group (pt-PT)! 

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 474

#1
Valantis Profile Picture

Valantis 474

#3
WarrenBelz Profile Picture

WarrenBelz 375 Most Valuable Professional

Last 30 days Overall leaderboard