Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Bookings (When an appointment is created) Trigger - the response is not in JSON format

(1) ShareShare
ReportReport
Posted on by 4

I'm trying to make a very simple automation where if someone books an appointment in my MS Bookings it will create an event on one of the shared calendars in our organization. 

My trigger is 'When an appointment is Created' and placed the bookings calendar SMTP Address (https://outlook.office365.com/owa/calendar/BookingsCalendar@grouphomes.com.au/bookings/

 

But throws an error: 

 

Error
Action 'When_a_appointment_is_Created' failed
 
Error Details
The response is not in a JSON format.


  • michaelleahy Profile Picture
    14 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    Hi, did you manage to solve this issue - I have the same problem!

  • Community Power Platform Member Profile Picture
    on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    I am still having this issue. I copied a working Flow before I started making changes.

    I looked at the link that @Darren_Carr shared.  It did say you have to be an Admin on the Bookings and that only 5 flows can be made for any calendar.  I ensured that there are only two flows using that calendar.

     

    I'm an admin on the Bookings calendar - I actually created it. Here's what I'm seeing.  The Flow is not being triggered.  When I open it from the list of My Flows, I get this error:

    I can't figure alt text - the error banner reads: Ther is a problem that needs to be fixed to trigger this flow. To see more details, open flow checker.I can't figure alt text - the error banner reads: Ther is a problem that needs to be fixed to trigger this flow. To see more details, open flow checker.

    When I open the Flow Checker, I get this

     

    There's a problem with this flow's trigger. Details: it hasn't been triggered successfully in the last 28 days.. How to fix it. To see this problem and fix it, go to the trigger.There's a problem with this flow's trigger. Details: it hasn't been triggered successfully in the last 28 days.. How to fix it. To see this problem and fix it, go to the trigger.

    When I click that link, I get a totally white area to the right of the menu panel. When I refresh, I get the flow failure screen, showing the trigger failed.  
    The run details

    ajvoraman_5-1689266203095.png

    So, I look at the trigger block

    ajvoraman_7-1689266271308.png

     

    Here's the offending raw input:

    ajvoraman_8-1689266309108.png

    On the right, the resources to help solve this ...

     

    ajvoraman_10-1689266529686.png

    I have not tried to sign out and reauthenticate - that's my next step. 

  • Darren_Carr Profile Picture
    2 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    I found this online, it may be a permissions issue.  Worth checking with your Asure Admins

     

    Use Power Automate connectors to build Bookings workflows | Microsoft Learn

  • Tauscher Profile Picture
    2 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    I'm still getting the JSON format error and have verified my smtp address (just the email address and not the full URL) and the connection is through an admin user. Anything else to check?

  • CoLenny Profile Picture
    5 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    Ok, figured this out.

    You need to have only the smtp email address in the parameter rather than the entire url as shown in the example.

     

    Entire bookings URL = https://outlook.office365.com/owa/calendar/LDev1@domain.org/bookings

    parameter should be LDev1@domain.org

     

  • CoLenny Profile Picture
    5 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    Also getting this error trying to see what the payload looks like:

    CoLenny_0-1664924827332.png

     

  • BenGarcia Profile Picture
    4 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    Here you go @Sundeep_Malik :

     

    2022-09-13_18h20_22.png2022-09-13_15h52_43.png

  • Sundeep_Malik Profile Picture
    6,480 on at
    Re: Bookings (When an appointment is created) Trigger - the response is not in JSON format

    Hey @BenGarcia 

    Can you show the flow in edit mode as well as the run where you got error if possible. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow