cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Flow Synchronization Issue

I’m having flow synchronization issue.  I search for a record from a list and create it if it does exist.  When this flow is called multiple times, there is an error. While the first flow is still running, the other flows do not know the record is already being created by the first flow.  This results in the other flows creating duplicates of the same record.

 

So, is there a way to synchronize the multiple flows similar to a mutex locking method?

 

Thank you

4 REPLIES 4
Dual Super User II
Dual Super User II

Hi @techuvise 

 

There is no locking mechanism in Flow by design

You would have to create a pattern to achieve it based on your requirement

 

What is triggering your fLOW?

Would it be possible to trigger your flow on a scheudle, and that one flow run handles all your item additions, that ways you wont run into lock issues

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Thank you for your response @RezaDorrani.

 

In my scenario I don’t think I will be able to have one flow handle all item additions.

 

Currently my flow is triggered whenever a "schedule record" is created (different from the “distinct location record” that is being created in the flow).

 

There are two types of records that are involved in this flow. The schedule record has the date, location, and other information needed for that day and location. The other record is the distinct location record. The flow I am working on is populating the distinct locations.

 

Once a user creates a schedule record, the flow starts and checks to see if the location in the schedule already exists in the distinct locations. If not, a new distinct location is created.

 

Since I want to have this update whenever any schedule record is created, I don’t think I can make one flow update all items.

 

Is there any other way I can accomplish this while still updating after each schedule record is created?

 

Hi @techuvise ,

 

Perhaps a more straightforward approach is to add a field that is not empty and has a unique value to the List or set a field that already exists to a field with a unique value.

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Can you explain this a little more?  Are you suggesting basically implementing a locking mechanism?

What I'm thinking is to have a field in another entity (act as the lock variable) which the flow will check before going into the part of the flow that check if this field exist in the table.  Subsequently, it will unlock this "lock variable" once it is done.  This way other flows will know by this "lock variable" if another flow is already checking this field or not.

Would that work or are you suggesting a simpler ways to implement this locking mechanism.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (26,221)