Skip to main content

Notifications

Power Automate - General Discussion
Answered

Synchro SharePoint Lists 🔁

(0) ShareShare
ReportReport
Posted on 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
    SamLed 2,326 on at
    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
    Sarahnt 29 on at
    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
    SamLed 2,326 on at
    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
    Sarahnt 29 on at
    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
    SamLed 2,326 on at
    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
    Sarahnt 29 on at
    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
    SamLed 2,326 on at
    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
    Sarahnt 29 on at
    Re: Synchro SharePoint Lists 🔁

    Ok thanks @SamLed 

  • SamLed Profile Picture
    SamLed 2,326 on at
    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
    Sarahnt 29 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard