Sync two sharepoint lists

Question

Hello,

I have created a flow to sync a master sharepoint list to a second sharepoint list when a new entry is created, I am not sure where I am going wrong and I have tried a few changes and I still can not seem to get it to work properly. If anyone could help. Below is the error message and the flow screenshots.

I have used the internal ID of the list on the master to then sync the second list to a Synced ID column. Thank you

Answer 1

Dear Holly Elliott-White,

Good day! Thank you for posting to Microsoft Community.

This forum is mainly focus on Microsoft 365 and Office in-built features.

Since your question is related to the utilization of Power Automate, I sincerely recommend you post your concern to the specific channel Microsoft Power Platform Community. Members and engineers over there are proficient in the knowledge of Power Automate issues. We are sure that our experts from that team can address your query effectively and accurately.

Thanks for your understanding and cooperation! Hope you have a nice day!

Sincerely,

Ralph | Microsoft Community Moderator

Answer 2

Hello Ralph,

Apologies for that I didn't realize there was a separate community, I shall re post in there, thank you for the help.

Answer 3

Hi Ralph,

I have posted my question in the power platform community with no response from over two weeks now, is there anyone else that could help please?

I have a number of flow issues and not getting any responses so far.

Thanks for your help.

Dear Holly Elliott-White,

Good day! Thank you for posting to Microsoft Community.

This forum is mainly focus on Microsoft 365 and Office in-built features.

Since your question is related to the utilization of Power Automate, I sincerely recommend you post your concern to the specific channel Microsoft Power Platform Community. Members and engineers over there are proficient in the knowledge of Power Automate issues. We are sure that our experts from that team can address your query effectively and accurately.

 

Thanks for your understanding and cooperation! Hope you have a nice day!

 

Sincerely,

Ralph | Microsoft Community Moderator

Hi Ralph

Answer 4

Dear Holly,

Have you solved the issue now?

I'd like to share a flow example for your reference.

For example, the master list is as follows.

The synced list is as follows.

When you add a new item in the master list, you want to add it to the synced list and update the Column1 values in item1 and item3.

You can use the flow as follows.

Filter Array: item()?['ID'] is equal to items('Apply_to_each')?['ID']

Append to Array:

{
"ID":"@{item()?['ID']}",
"Title":"@{item()?['Title']}",
"Column1":"@{first(body('Filter_array'))?['Column1']}"
}

Update item 2:

id: items('Apply_to_each_2')?['ID']

Column1: items('Apply_to_each_2')?['Column1']

Result:

Feel free to share the updates at your convenience if you need further help resolving this issue.

Sincerely

Cliff | Microsoft Community Moderator

Answer 5

Dear Holly,

Have you tried the way above? Welcome to share any updates at your convenience.

Thanks for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator