I have a timesheet process based on a feature service. The user inputs details in an Input form and submits the survey. The manger then goes into the inbox and opens a Review form, a copy of the details from the Input form, and checks a box authorising the timesheet, and submits it. This all works as I want it to.
I then have a power automate webhook which takes the relevant data from the Review form (if its been authorised) and populates an Excel spreadsheet.
I tested this Power Automate part by filling data directly into the Review survey, and it worked beautifully.
However, when I tried to test the whole process, by filling the Input form, then authorising the details in the Review form, the trigger failed and the excel spreadsheet was not populated.
Any ideas why this would be?