
Announcements
I'm creating a flow that triggers when filling out a form. I have an Excel document that has two spreadsheets, one of these is where the flow feeds the form responses, after filling it out I want you to convert this file into PDF, generate the PDF file in a One Drive folder and send it to the email after that. file is deleted. I already have the flow created and I did some tests and it worked. The problem is when I fill out more answers in the form, it takes a while to update the spreadsheet and sometimes it triggers with old answers, with the answers that were stored the last time I opened it. How can I avoid this problem with Excel document updates?
follow my flow
Try breaking it into two flows: one triggers on the Form and updates the spreadsheet. The second triggers when the spreadsheet gets updated and executes the rest of the logic.