Howto: flow Source List -> Target list

(0) Share

Report

Posted on by LPol

Hi to all here,

i am trying to do flow for updating an item in my List. I have one Target List (TList) and many Source Lists (SList1, SList2, ...) and i am trying to make some flow with conditions:
1) for new item in any SList copy this item to TList

2) if the item in SList exists in TList and this item inSList is changed, than update this item in TList

3) if the item in any SList is deleted, than delate it in TList

I was able to make a flow for New item:

Trigger: When an item is created: List Name = SListxy

Action: Compose, Inputs: guid()

Action: Create item: List Name = TList, (selected parametrers)

Action: Update item: List Name = SListxy ... writing output of Compose to get identifier for updating in future

Now i am not able to make a flow for updating items. Can you help me? Is my flow good for what i can do, or there is better way?

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You should use the trigger or Item Created or Modified instead

That way you can see if its been Changed or Newly Created.

I do not see an issue with your flow or logic, although having error handling would be nice.

Was this reply helpful? Yes No
LPol 12 on at

Like (0)

Report

Hi FLMike,

thank you for your reply, but i think, i don't understand, what should i do. When i change Trigger to "Created or Modified", than Flow checker informs me about the circular link. I think, that i can't use "Created or Modified", with this trigger i make a loop: Compose, GUID <-> Update item, write [Compose, GUID].

Was this reply helpful? Yes No
Suggested answer

SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @CU12081504-1 ,

Is the ID same for Source list and Target list or you have any other relationship to identify the item is same in the Target list.

If Yes , then , you will have to use two power automate flows ,

1. To Update / Create the list item in the Target list-> This you can do it by using when an item is created or modified trigger.(Consider retrieving the item with the same ID from the Target list , if the item exists then it would return the item and you can update that if it won't return an item then create a new item in the Target list).

2. To delete the item when the item is deleted from the source list , you can create another flow , with when an item is deleted trigger , and find the associated item in Target list and delete that.

Hope this helps!

Thanks,

Sanmesh

Was this reply helpful? Yes No
LPol 12 on at

Like (0)

Report

Hi @SanmeshG ,

ID in Source and Target is not the same i am going to have more Source Lists (maybe about 200) and only one Target, where i can collect all the changes from sources. Target will be not editable. I am trying to fing the best way to do it. I need to catch three events: Add new item, Update item and Delete item, all of them in any Source list.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Does it mean that for every SP List item whenever a change happens you want to create a new list item in the Target list?

How do you plan to utilize the Target SP list (Meaning how will you find out if you have to find a list item of a specific ID of list 1)? I would suggest you should have some column in which you save ID which helps you identify that the item is from , SP List1 and has an ID 4 (for example) , so one approach would be to save your list item with some unique identifier (you can consider using your 12 digit list ID - itemID ) which can be used to identify that this list item is from list 1 and has an ID of say 4.

Let me know if you have any further questions/doubts.

Thanks,

Sanmesh

Was this reply helpful? Yes No
LPol 12 on at

Like (0)

Report

... Does it mean that for every SP List item whenever a change happens you want to create a new list item in the Target list? ... YES :)

In order to utilize every item, i can use GUID() as unambiguous identifier

GUID function - Power Platform | Microsoft Learn

I have a Flow for this case:

Input in Compose is guid()

and in Update item i'm updating Source, so at the end of Flow i have the same GUID in Source and in Target.

But now i am not sure, how to do Update when i change Source.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Please use the trigger when an item is created or modified trigger ,

to delete the item use the trigger when an item is deleted

Was this reply helpful? Yes No
LPol 12 on at

Like (0)

Report

Okay, i can use the trigger when an item is created or modified. But i don't know, how to update Target when i modify Source. Maybe it is simple, i am trying to play with Power Automate for some days. Can you write me simply way, how to do it? When Source ID is not equeal to Target ID, i don't have any identifier to pair Source item with Target item. I tried to define GUID in Id, but it is not possible, it must be integer, not string ...

Was this reply helpful? Yes No
LPol 12 on at

Like (0)

Report

Now i am trying this:

Was this reply helpful? Yes No