Problem merging two lists

Copper Contributor

Good morning.
I have a problem when integrating two Sharepoint lists, in order to automate these items in the future. I will explain further below. In a Power Apps application, integrated with Sharepoint, I have a ticket and asset management application, with the following fields: Title, problem description, priority, origin, assigned and Category. Note that these items are in Sharepoint, in the list called "Tickets".
In another list called Admins, I have the name of each Category assigned to each email corresponding to a person. What I intend to do specifically is: when selecting "Category", Sharepoint needs to identify which person is assigned without me mentioning their email, just with the "Category". How would you do it?

0 Replies