Synchro SharePoint Lists 🔁

(0) Share

Report

Posted on by Sarahnt

Hello,

I hope you are all fine. I'm writing a post because I'm having a problem with Power Automate Flows.

My goal is to synchronize two SharePoint Lists. I've created two SharePoint Lists to assign roles to two categories of users. Some users can edit columns 1 and 2, while admins can edit columns 1, 2 and 3. My aim is to synchronize these lists so that changes in List 1 are automatically reflected in List 2. In addition, user 2, with extended rights, should be able to correct user 1's entries.

I've followed the following tutorial, but when I create two flows with this structure, they work fine but enter an infinite loop... I was wondering if you have a solution to solve this problem please because it’s been several days that I am not able to fix the issue…

Could you please help me because I really don’t know how to solve this…

Thanks in advance for your time and help.

Best regards,

Sarah

Categories:

General topics

I have the same question (0)

All responses (23)

Answers (1)

SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Sarahnt,

I guess both flows use same "When a item is created or modified" trigger, and you enter infinite loop because when you update list 1, flow update list 2 which trigger second flow to update list 1, and so on...

I've designed this solution to avoid entering infinite loop while updating a list monitored by "When a item is created or modified" trigger : Solved: No loop SharePoint update item trigger - Power Platform Community (microsoft.com)

[Edit] This solution was designed to avoid loops when updating the list in the flow triggered by this list. But it will work the same for your both flows. When flow 1 (triggered by list1) update list 2, update SystemUpdateVersion in list 2 so it will not trigger second flow. Do the opposite for second flow.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Sarahnt 29 on at

Like (0)

Report
Copy link

Link copied!

Hi @SamLed thank you for your answer and for helping me. I edited my flow as you said but the issue persists, I still do have an infinite loop…

Was this reply helpful? Yes No
Sarahnt 29 on at

Like (0)

Report
Copy link

Link copied!

My flow is as follows:

1. Once an item is edited or created - List 1 (I added the following expression as trigger condition in trigger settings as mentioned in your tutorial: @not(equals(triggerBody()['SystemUpdateVersion'],triggerBody()['{VersionNumber}']))
2. Get the items - List 2
3. Message/Compose (expression: formatNumber(add(float(triggerOutputs()?[‘body/{VersionNumber}’]),1),’F1’)
4. Condition (expression: length(outputs(‘ Obtain_items_List_2’)?[‘body/value‘]
4.1. Create item - List 2
4.2. Update item - List 2

I have an error at step 1 with the condition @not(equals(triggerBody()['SystemUpdateVersion'],triggerBody()['{VersionNumber}']))

do you know why I have an error with this condition even though I created a text column named SystemUpdateVersion in my two lists?

Thank you in advance for your help

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Sarahnt,

What is the error raised ?
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Sarahnt 29 on at

Like (0)

Report
Copy link

Link copied!

Hi @SamLed, It says that the field SystemUpdateVersion doesn't exist even though I created it...

Here is the message details: The template language expression 'not(equals(triggerBody()['SystemUpdateVersion'],triggerBody()['{VersionNumber}']))' cannot be evaluated because property 'SystemUpdateVersion' doesn't exist, available properties are '@odata.etag, Sports etc... (others fields of my list)

Was this reply helpful? Yes No
Sarahnt 29 on at

Like (0)

Report
Copy link

Link copied!

Can I please share you my screen @SamLed and show you my flows please because I really do not understand why it doesn't work... It would be really kind of you because I really do not know how to fix this issue. I tried many many times but it didn't work

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Sarahnt,

That will be useless, I mean, as you added the column after flow design, not sure trigger's has detected change. Give me a minute, trying to figure how to fix that.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Sarahnt 29 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help @SamLed. I think by showing you my screen maybe you will see if I didn't configure something well concerning the solution you proposed. Can't I show you quickely please??

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Sarahnt,

No need, I've reproduced the issue by creating a SystemUpdateVersion2 column and modified my trigger condition. I got the same error and looking for a fix.
______________________________________________________________
If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
Sarahnt 29 on at

Like (0)

Report
Copy link

Link copied!

Thanks for trying by your side too @SamLed. It's really kind of you to help!

Was this reply helpful? Yes No