How to Cross Reference multiple SharePoint List Items in a Ticketing System Using Power Automate.

Question

My end goal: to create a ticketing system where Microsoft Forms generates data; that data is collected in a Master SharePoint List; the SharePoint List has a Status column with choice values for each new entry. The user should be able to change the Status choice value on each item to designate which repair center the ticket should be routed to, or that the ticket has been completed. Once the Status choice value is selected for the proper repair center, the entry item is copied to another Microsoft List for that specific repair center (and also stays in the Master List). The secondary repair center List users can then address the ticket and eventually change the Status choice value (on the secondary List) to completed, or change the status to send to a different, third repair center. When marked completed on the secondary repair center List, the workflow should cross reference and update the Status on the Master SharePoint List as well.

What I've done:

I have created a basic ticketing system, a good Form, and my Lists. I generate data using Microsoft Forms, and use Power Automate to collect the data into my Master SharePoint List. I've formatted the List to have the correct choice values in the Status column. I have created the relevant SharePoint Lists for the repair centers.

My problem:

I'm having trouble automating the copying of an entry from Master List to the Secondary List, based on the trigger of changing the Status column choice value. My problem might actually be providing the correct formula for the trigger. I've seen a few different things and am a little unclear on that formula. For one repair center sending the entry item to another repair center, I assume the automated workflow would be very similar. Any assistance on creating the correct trigger formula is appreciated!

Secondary Problem:

How can I trigger and automatically update the Status value of an entry item on the Master List, when that entry item has been updated on the Secondary List at the repair center?

Thanks in advance!

Answer 1

Hi @Wes Taylor,

Power Automate is not currently supported here on Q&A. The product group for Power Automate actively monitors questions in dedicated forums here. - https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.