Forum Discussion
Error when using Power Automate to push data when an Micorsoft Bookings appointment is created
Hi all,
I'm using Power Automate to fill a row of an Excel sheet with the data from Microsoft Bookings appointments. I use the trigger "When an appointment is created". I copied the SMTP address from the "Configuration" tab in the Bookings backend. When I tested this earlier, everything seemed to work properly, and I got the data in the Excel sheet.
This morning I checked back to the overnight results - where several appointments were made, I received the following Error Details:
Status(StatusCode="PermissionDenied", Detail="Invalid authority. Accessing user not part of bookings calendar")
Weird because I am administrator for the Bookings calendar.
Anyone who can help me with this?
1 Reply
- Just curious, are you still getting this issue? What did you do to fix it? We might be doing something similar as you with an Excel sheet too.
If you resubmit the failed Flow run, does it work? I had a Flow that also failed if multiple people were submitting (not Bookings, but Forms). If the Flow run is resubmitted, then it will work. It just needed time to run through and process each run.
This doesn't fix the initial issue, but there is a "resubmit" Flow step. I haven't tried it out, but I'm thinking that would work too.
