cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teespolyglot
Helper II
Helper II

File update issues and flow frequency

After days of teaching myself how to use Power Automate to automate some of my more routine business processes, I created a flow which, in response to a form submission, updates a row in an excel sheet, grabs the meta data and content, and emails the sheet to the user that submitted the form.

 

I have encountered a troublesome problem, however, in that the sheet that gets emailed does not always contain the correct data, instead sometimes containing the data from the previous response. I've tried to counter this by adding a delay in my flow before the file is updated and then again before the file metadata and content grab, but this is not always successful in remedying the problem, and is not ideal if I want to upscale, as there may be additional responses within the time frame of the flow.

 

If anyone has encountered this before and can offer any advice, it would be much appreciated!!    

1 ACCEPTED SOLUTION

Accepted Solutions

@teespolyglot 

Have you tried instead to create a new file each time and then deleting it at the end of the flow?

So the idea is you have a template and then Copy File and use the new copied file and delete it afterwards...

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

6 REPLIES 6
Mira_Ghaly
Dual Super User II
Dual Super User II

Hi @teespolyglot,

 

Can I ask if you replace the data in the sheet or you accumulate on it?

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi @Mira_Ghaly , thanks for your response. I'm replacing the data each time

@teespolyglot 

Have you tried instead to create a new file each time and then deleting it at the end of the flow?

So the idea is you have a template and then Copy File and use the new copied file and delete it afterwards...

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

@teespolyglot 

Sample as below:

Mira_Ghaly_0-1641354745237.png

Column1 .. Column2 are the columns in your template, Sample as below:

Mira_Ghaly_1-1641354876934.png

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Hi @Mira_Ghaly ,

 

Thanks for your continued efforts on this. It's taken me all day (my column headers were 46 sentence-like questions with dynamic input responses!), but I've finally managed to overhaul the flow so that a template is copied at the beginning and deleted at the end.

 

At first glance it appears to be running well. I'll put it to a more intensive test tomorrow (multiple different responses in a row) to see whether I still have the same problem. Fingers crossed, it's gone!

 

🙂

Hi @Mira_Ghaly ,

 

I've submitted a few responses to test it out this evening and all appears fine. Thanks ever so much for your help! 🙂

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,856)