web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : WMRSp06d/s8/CSDQc5fjm9
Power Automate - General Discussion
Answered

Synchro SharePoint Lists 🔁

Like (0) ShareShare
ReportReport
Posted on 17 Jan 2024 22:40:41 by 29

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…

63E5DE04-54B8-4001-83AC-0F3CCBF718C9.jpeg


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

  • SamLed Profile Picture
    2,332 Moderator on 18 Jan 2024 at 19:59:15
    Re: Synchro SharePoint Lists 🔁

    Hi @Sarahnt,

     

    You're welcome, don't forget to promote second solution as topic solution, your flow design is interesting and specific due to attachment update. It will help those who face same loop issue 😉

     

    Regards,

    Sam

  • Sarahnt Profile Picture
    29 on 18 Jan 2024 at 19:49:35
    Re: Synchro SharePoint Lists 🔁

    I'll ask the IT Team then! Thank you very much @SamLed for your time and help! It was very useful! Thank you! 🙂

  • SamLed Profile Picture
    2,332 Moderator on 18 Jan 2024 at 19:43:06
    Re: Synchro SharePoint Lists 🔁

    Hi @Sarahnt,

     

    You'll need to have administration rights on your tenant else you'll have to ask to your IT team.

     

    A service account is like any other account, you have to assign it a license, permissions, etc..

     

    Those account usually use never expire password policy/settings.

     

    Read below documentations for more information:

    1. Add users and assign licenses at the same time
    2. Set an individual user's password to never expire
    3. Set the password expiration policy for your organization
    4. Create a Flow with Service account

    ______________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

     

  • Sarahnt Profile Picture
    29 on 18 Jan 2024 at 19:21:27
    Re: Synchro SharePoint Lists 🔁

    I've never done this. It's the first time for me. How can I do this please?

     

    Is it this way: https://www.youtube.com/watch?v=2-lA8g_W68U&ab_channel=M365TechHelp

     

    Because I don't have the hand to add an environment. 

  • SamLed Profile Picture
    2,332 Moderator on 18 Jan 2024 at 19:16:04
    Re: Synchro SharePoint Lists 🔁

    Ok, that's not a good practice, to my customers I always advice to create a service account for power automate and design flow with it. I have same practice for my dev tenant. 

     

    You'll have many advantage:

    - Dedicated mailbox

    - No need to change owner when leaving organization (when they don't forget to change before deleted account, already saw that)

    - Usually that account can have high permissions, regular users shouldn't have

     

    [Edit] for your testing purpose, as you've got only one account, you have to ask somebody else to modify items and there will be no loop. Or if you can, create another account to test.

    ______________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

  • Sarahnt Profile Picture
    29 on 18 Jan 2024 at 19:10:17
    Re: Synchro SharePoint Lists 🔁

    Yes I do use the same account. Does it mean that I have to create an environment in admin.powerplateform.microsoft.com? (because I don't have any it's empty and I don't have the permission to create one)

  • SamLed Profile Picture
    2,332 Moderator on 18 Jan 2024 at 19:07:29
    Re: Synchro SharePoint Lists 🔁

    But do you use same account to edit flow and to update items ? it will not work, you have to use an account for your flows and another for updating items 😉

    ______________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

  • Sarahnt Profile Picture
    29 on 18 Jan 2024 at 19:05:24
    Re: Synchro SharePoint Lists 🔁

    Ok thanks @SamLed 

  • SamLed Profile Picture
    2,332 Moderator on 18 Jan 2024 at 19:04:40
    Re: Synchro SharePoint Lists 🔁

    Hi @Sarahnt 

     

    Nope, use only last one. 

    ______________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

  • Sarahnt Profile Picture
    29 on 18 Jan 2024 at 19:01:33
    Re: Synchro SharePoint Lists 🔁

    Did you keep both of the trigger conditions? Because by my side the loop persists if I only put@not(equals(triggerbody()?['Editor']?['Email'],'PowerAutomate@contoso.com')) 😞

     

    It may not work because I'm using a personal account... How can I fix this please?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2