I have set up a power automate flow exporting my inspection results into an excel spreadsheet using the Safety Culture guide (Power Automate: Export inspection data to Excel Online spreadsheets... (safetyculture.com). However, the flow is exporting every single inspection ever undertaken on the template. What I would like it to do is only upload the newly conducted inspections. Can anyone help?
Help with Power Automate: Flow is exporting every inspection to a spreadsheet instead of newly conducted ones.
Best answer by lachlancast
We’ve been through something similar - instead of only returning the changed (or new) inspections since the last run, it returns all inspections.
A couple of things to check would be the ‘modified after’ filter - you could setup Power Automate to get the last successful run time (i.e. the last time it updated the spreadsheet) and use that as the ‘modified after’ filter - that should only return the inspections added/updated since the last run
You could also do this in the ‘array’ filter step (but wouldn’t be as efficient!
Sign up
Already have an account? Log in with your username and password, or with your SafetyCulture account.
Log in
Don't have an account? Sign up or log in with SafetyCulture.
Single sign-on
Log in with SafetyCultureEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.