Forum Discussion

ram142more's avatar
ram142more
Frequent Visitor
20 days ago
Solved

Text not shown in activator Alert msg

Hi Team,

I am trying to show failed pipeline in activator with failed pipeline name but it wont show any variable after entering @ for Pipeline.

Can anyone guide me how to show text in activator alert msg, please?

  • Hi v-kathullac​ ,

    As we get the update but not fully achieved what we want through the activator. We choose Power Automate to share the table with pipeline with status in teams.

11 Replies

  • ram142more's avatar
    ram142more
    Frequent Visitor

    Hi v-kathullac​ ,

    As we get the update but not fully achieved what we want through the activator. We choose Power Automate to share the table with pipeline with status in teams.

  • v-kathullac's avatar
    v-kathullac
    Icon for Community Support rankCommunity Support

    Hi ram142more​ ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    Regards,

    Chaithanya

  • v-kathullac's avatar
    v-kathullac
    Icon for Community Support rankCommunity Support

    Hi ram142more​ ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    Regards,

    Chaithanya

  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    Icon for Continued Contributor rankContinued Contributor

    PipelineName isn’t in the KPI/Card query, so Activator has no way to reference it. If you need PipelineName in the alert message, you have to create the alert from a table or matrix that actually includes PipelineName, Status, and LastRunTime.  Use the KPI for the summary, and use the table for the alert. That’s the right setup.

  • Hi ram142more​,

    Mauro89​'s point makes sense for a KPI/card alert, but I think the important limitation is actually the data being passed into Activator.

    When an alert is created from a Power BI visual, Activator uses the visual's underlying query and turns the returned dimensions/measures into objects and properties.

    So if your card only contains something like:

    Failed pipeline count = 3

    then PipelineName is not part of that query, which is why typing @Pipeline . . . does not offer it. Upgrading the alert in Activator cannot add a field that was not present in the original monitored data.

    I would try changing the alert source rather than the message itself. Microsoft now supports Activator alerts on table and matrix visuals, with the rule evaluated per row.

    For example, create a table containing:

    PipelineName | Status | LastRunTime

    and create the alert from that visual for rows where Status = Failed. PipelineName then becomes part of the data Activator is monitoring and can be included as context in the notification.

    Activator actions support referencing available properties with @ in the message.

    So I would keep the KPI card for the summary view, but drive the actual failure notification from a row/dimension-based visual or query that includes the pipeline name.

    AI-assisted drafting: AI was used to help structure and phrase this response. I reviewed and validated the technical content before posting.

    • ram142more's avatar
      ram142more
      Frequent Visitor

      Hi ShivekMaharaj​ ,

      Thanks for the response.

      I am using 
      Alert not allowed to create based on Table as you mentioned where i have all 3 columns. 
      It only allowed from KPI card where it only picked up numeric number only parameter.
      Please check in below screenshot. 

       

  • ram142more's avatar
    ram142more
    Frequent Visitor

    Hi Mauro89​ ,

    I think the document link share by you is to trigger another Fabric Activity not Activator.
    As simple, we have 10 pipeline which are running in ADF and create view in databricks to see list of pipeline are failed or success. base on that view we want to create alert for failed pipeline. As i am able to create alert base on count of failed pipeline through realtime monitoring dashboard. 

    but won't show the pipeline name because Alert create only on KPI, cards.