Need Help Creating Automation to Copying Row of data between 2 Sharepoint Lists when Trigger is Met

[lchen26]

Hi Folks,

Bit of a Power Automate noob. I'm trying to create an automation that checks a sharepoint list (upon data addition/edit), and copies over any entries if a trigger column has been set to "Inactive".

I've set up both lists to have the same columns, including a trigger column (Choice of Active / Inactive ). However, I'm having difficulty navigating how to set up the Automation.

I've been trying to follow this tutorial, but some options referenced do not match what i am seeing (for example, I don't appear to be able to add "Dynamic Content", nor do I appear to be able to investigate columns in my destination list.

(in the screenshot below, I can only see the option to select one column titled "Email", when there should be two, since both lists contain this column)

Any pointers or tutorials would be greatly appreciated

[fchopo]

Hello @lchen26 

Could you explain in further detail? I mean, which column is present in both lists and not showed in dynamic content? Which is the type of this column?

Regards,

Ferran

[lchen26]

So I have two lists containing basic employee information, including first name, last name, email address, and a choice column for Active/Inactive status.

My first step, Get Items, is set to return all items where "Active/Inactive" is set to "Inactive". This i was able to figure out.

The next step I'm trying to set up is to set a condition to see which of those employees (derived from the source list) already appear in the destination list, as sort of a duplication check using the email address as the unique identifier. In layman's terms, I'm trying to create the expression:

[Get Items Email] is equal to [Destination Email]

However, I can't figure out how to specify the Email column from the Destination List as an argument in the conditional expression. Does that make sense? Am I even approaching this in the right way?

(FYI, my next step would to add a fork in the action so that

[if "Get Items" email exists in "Destination List" email, do nothing]
[if "Get Items" email does not exists in "Destination List" email, copy "Get Items" data line into "Destination List"])

[fchopo · Accepted solution]

Hi @lchen26 

Have a look at this example:

1) Get the items from "Managers" list where Status = "Inactive"

2) For each item (manager)

  2.1) Get the items in the Hosts list where Email=Managers list email column (in the example, "Created by Email")

  2.2. If an item is found in the hosts list (length(body('get_items_2)>0) ...

Hope it helps!

Ferran