Transfer new & update modified data within SharePoint List

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WydaPBI 51 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
WydaPBI 51 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WydaPBI ,

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

Did the error appear before?

Was this reply helpful? Yes No
WydaPBI 51 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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".

Was this reply helpful? Yes No
WydaPBI 51 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No