cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EV0910 Helper I
Helper I

Re: avoid double write on excel from different users

Spoiler
 

Yes I did , before the checks , but I think the write operation is slow and in the meantime the second user can do refresh 

 

EV0910 Helper I
Helper I

Re: avoid double write on excel from different users

could be good if there is an operation to do a wait(random) , just to reduce the probability 

Do you know if it is possible to do ? 

 

Thanks 

eka24 Community Champion
Community Champion

Re: avoid double write on excel from different users

How long will you wait and what if the other user is also waiting? How many users will wait at the same time?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

eka24 Community Champion
Community Champion

Re: avoid double write on excel from different users

If you use a Datasource like SQL, you can prevent duplicate entry whether user Patch at the same time or not. One Will be rejected.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

EV0910 Helper I
Helper I

Re: avoid double write on excel from different users

Yes I know , but I don't have a DB in this moment

Highlighted
WarrenBelz Community Champion
Community Champion

Re: avoid double write on excel from different users

@EV0910 ,

You might consider converting to SharePoint

View solution in original post

EV0910 Helper I
Helper I

Re: avoid double write on excel from different users

No, could I solve the issue ? 

Why Sharepoint could solve the issue ? 

Read and write are atomic? 

Thanks

Elia 

WarrenBelz Community Champion
Community Champion

Re: avoid double write on excel from different users

@EV0910 ,

Both myself and @eka24 are trying to tell you the same thing - there is no solution for this with an Excel data source.

EV0910 Helper I
Helper I

Re: avoid double write on excel from different users

yes, I understood , my question was related to Sharepoint.

If I use a sharepoint list I can solve the problem ? 

Thanks again 

 

WarrenBelz Community Champion
Community Champion

Re: avoid double write on excel from different users

@EV0910 ,

Yes - that was my recommendation.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,397)