Transfer new & update modified data within SharePoint List

[WydaPBI]

Hi @expert,

I need your help and expertise. I have 3 sources (with columns) as below:
SharePoint List A: Name, Date, Status

SharePoint List B: Name, Date, Status

SharePoint List AB:  Name, DateA, StatusA, DateB, StatusB

*SP List AB is the merged List from both A & B.

Expectation Result:
To create automated flow that can trigger any new data/modified from SP List A & SP List B to SP List AB (No duplication to the SP List AB).

Example data & result:
SharePoint List A: Trip A, 12/7/2023, WIP
SharePoint List B: Trip A, 13/7/2023, WIP
SharePoint List AB: Trip A, 12/7/2023, WIP, 13/7/2023, WIP

and if user changes any data in SP List A or B for example:
SP List A: Trip A, 13/7/2023, Completed
SP List B: Trip B, 13/7/2023, Completed
SharePoint List AB: Trip A, 13/7/2023, Completed, 13/7/2023, Completed

List AB will be updated to if there is new/changes to the line item in List A & List B

Thanks

[v-mengmli-msft]

Hi @WydaPBI ,

If the values in the Name column are not duplicated, you can create two flows to monitor the modification of tables A and B lists. Taking List A as an example, you can follow the following method to create another flow that monitors List B.

Best regards,

Rimmon

[WydaPBI]

Hi @v-mengmli-msft 

Thanks for the reply. List Name is not showing up in Site Address & List Name, can help me? How to put Custom value

[v-mengmli-msft]

Hi @WydaPBI ,

There is an error about your connection, please check the connection first.

Then select site and list in drop down list.

Best regards,

Rimmon

[WydaPBI]

Hi @v-mengmli-msft 

There is no error if i choose action / trigger for "When Item is created" but If i selected this trigger "When Item is created & Modified" it doesn't show Site Address and List Name in the field. So, I'm not sure why. 

[v-mengmli-msft]

Hi @WydaPBI ,

Have you tried re-creating the connection? I recommend you re-connect or create a new connection.

Did the error appear before?

[WydaPBI]

I changed to Old Designer, the connections looks ok now. I want to ask, In Update Item action for List A, I should take column name from 'Get Item' or 'When an item is Created or Modified'? because every time i selected from 'Get Items', it will auto created the 'Apply to each' on top of the 'Update Item'. Is this correct?

[v-mengmli-msft]

Hi @WydaPBI ,

The Name in filter query comes from trigger.

The outputs of "Get items" is an array, this is why it will enter a "apply to each" when you select name from "Get items".

[WydaPBI]

My flow failed. on Filter Query has error. I put in Filter Query:
Title eq '[column name in List A] <<<< It's correct right?
Title is from List AB

[v-mengmli-msft]

Hi @WydaPBI ,

Can you provide a screenshot of the filter query you are using?

Is "Title" the column name used to store names in AB list?