Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Power Automate will not let me "Get a goal check-in" - returns a bad gateway error on "Goal ID"

(0) ShareShare
ReportReport
Posted on by

I am trying to set up some user notifications for the Power BI goals feature. I am able to fill in the workspace and Scorecard ID but when I try to connect to the Goal ID I get the following error message.

 

"Could not retrieve values. BadGateway More diagnostic information: x-ms-client-request-id is 'D37255BA-E4B5-4AC3-8482-1ED5DC91AF07'"

 

This was not an issue a few days ago when I created notifications for when the current values in a scorecard changed. However, now, I cannot connect to any Goal ID on any new workflow, regardless of which action I select.

 

I have manually refreshed Power BI but that has not fixed the issue.

 

Has anyone else seen this error message? How can I get it fixed so that I can connect to the scorecard goals again?

  • EmilioG Profile Picture
    EmilioG 8 on at
    Re: Power Automate will not let me "Get a goal check-in" - returns a bad gateway error on "Goal ID"

    Hi, @ulevi,

     

    Unfortunately, as far as I know, you need to create a flow for each goal.

     

    Regards,

     

     

  • ulevi Profile Picture
    ulevi 4 on at
    Re: Power Automate will not let me "Get a goal check-in" - returns a bad gateway error on "Goal ID"

    Than you @EmilioG !

    I guess I am maybe tackling this the wrong way.
    The challenge I am facing is that I have different Goals in the Scorecard.
    Now, I am trying to create a flow that regardless of what goal value changed, It will send an email. I don't want to create a dedicated flow for EVERY goal I have now and keep creating those for every goal that get added in the future to that Scorecard..  I want to create one dynamic flow that can cover that.. (Identify that a goal value in a particular Scorecard have changed --> send an email to notify that particular goal value have changed.)

    Have you any suggestion? 😊
       

  • EmilioG Profile Picture
    EmilioG 8 on at
    Re: Power Automate will not let me "Get a goal check-in" - returns a bad gateway error on "Goal ID"

    Hi, @ulevi,

    It's possible, but you must use a new step that could retrieve the goal name. That's because the "When current value of a goal changes" doesn't return it.

     

    In the example that I attach, I've used "Get a goal" that return the "Goal Name".

     

    I hope it help you. Regards.

     

    EmilioG_0-1712135094640.png

     

  • ulevi Profile Picture
    ulevi 4 on at
    Re: Power Automate will not let me "Get a goal check-in" - returns a bad gateway error on "Goal ID"

    @EmilioG - Is it possible on the very scenario you described in your comment to be able to send in the email notification the Goal name, (the name you see in the Scorecard), instead of its "Goal ID" ? what is the way to do that on the flow?

  • EmilioG Profile Picture
    EmilioG 8 on at
    Re: Power Automate will not let me "Get a goal check-in" - returns a bad gateway error on "Goal ID"

    Hi,

     

    I've looking for a "real and good" answer to the same problem with no results.

     

    I've solved it partially using a workaround.

     

    I created a new workflow with a trigger called: 

     
    "When current value of a goal changes"
     
    In that case, it allowed me to select the "Goad ID", so I was able to configure it. As a second action, I created a "send a email (V2)", to send me an email with the value "Changed goal Id" (@{triggerOutputs()?['body/id']}).
     
    Testing it, I received an email with the "Goal ID". Something like: e132g8a4-a7e8-4g96-bre3-a9d347e4d6c5.
     
    Using that string as "Goal ID" I could fill in the "Goal ID" for "Get a goal check-in".
     
    Crazy but it worked!
     
    I hope it could help you.
     
    Regards.
     
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics