cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chase0
Frequent Visitor

Dynamic Content is empty/null when using 'When a HTTP request is received'

I've created a flow that extracts data from a Webhook and works perfectly with dynamic content and then I've created a 2nd flow similar to the 1st but the Dynamic content doesn't work at all they are both very simple flows and I can't figure out what I am doing wrong:

 

Chase0_0-1652459046541.png

 
 

Here is a section of the raw data that has been passed into the 'When a HTTP request is received'

:

Chase0_1-1652459198065.png

and here is the output of the e-mail showing the subject as null but it should be the 'dueOn' from the data above:

Chase0_2-1652459312550.png


The e-mail is being sent but as stated it is blank so I am not getting any errors. I am new to this and I'm hoping it is something simple.

I have tried the same in Zapier and it is working perfectly on that platform.

TIA
Chase



6 REPLIES 6
eliotcole
Super User
Super User

Purely going on the above, it's likely that some of the entries that are received are just blank, so you need to put logic in there that says if it's blank, then do this. That way you can either generate a little error stack for yourself to review and plug the gaps, or you can fill trivial data with a placeholder that makes sense.

 

However I'd say that realistically we'd need to see a bit more (all) of your flow edited in to your initial post, plus the actual error that you're seeing. Screenshots of both (with obfuscations for private data) will be perfect, as they'll help people here support you. 🙂

Hey Eliotcole,

thanks for the reply!

In my original post that is my entire flow, its gets info from a webhook and should send an e-mail. As I also stated in the original post my other flow with a slightly different webhook works fine and this particular webhook also works in Zapier.

Also I am not receiving an error I am just getting null information. It sends the e-mail fine but I don't get any of the dynamic content. I will check with the platform runners if the webhook is working correctly but as I can see on the raw data being pulled into the 'When a HTTP request is received' the data is there it just doesn't seem to be going into the dynamic content and as said before its working on Zapier.

I'm not sure what other information I can edit into my original post that isn't already there from the 1st screenshot you can see I am trying to add dueOn into the subject of the e-mail in the 2nd screenshot you can see that dueOn has a date from the data passed in and then on the 3rd screenshot you can see it just says 'null' in the e-mail subject. If you are able to guide me in the right direction of what other information might be useful that would be great!

v-yujincui-msft
Community Support
Community Support

Hi @Chase0 ,

 

If Dynamic content does not work, maybe you could try to write the expression manually.

In addition, you could try to recreate your flow and try it again.

 

 

Best Regards,
Charlie Choi

OK, one of a few things could be off, here, but I think that there are ways to fix all of them relatively easily. But these are still stabs in the dark, if you want to PM me the schema we can double check it.

Make A More Open Schema

Firstly, with your input schema there, make sure that any fields that you want (or all fields) can arrive empty (null).

 

Realistically you'll be fine if that schema is empty, however I see that you're not creating a ton of flow actions to put the logic in the flow. So let's work that schema so that any/all fields can accept a 'null' value.

 

So, quickly check out this answer where you'll see how you can make a field accept given types of response. Here's the dueOn field as an example:

"dueOn": {
  "type": ["string", "null"]
  },

Then your flow will *definitely* run each time, because there's a chance that with null values it might not fully trigger the flow and it won't run at all.

Conditional Logic For Null Values

You should also put in some conditional logic for anything that might be blank something. You can either do this:

  1. Verbose - With Variables and Condition actions that you then use in the email.
  2. Expression - With functions wrapped around those values you're pulling from the trigger.

Verbose Logic

Verbose is my word, here, but essentially this will ensure that if someone comes to this flow in the future, and doesn't understand the Microsoft expression writing language, then they will be able to do maintainance o the flow.

 

Use the Condition action to determine if (for example) dueOn is null. If it is, then set a dueOnVAR Variable to "Due Date Empty" and to perhaps set an emailVAR to change the send address to alert you to an error.

 

Expression Logic

Here you just need to set each field that you care about from the trigger inside an if() function with an equals() function.

 

So, here is the expression that I would use in the Subject field of the email action:

if(equals(triggerBody()?['$dueOn'], null), 'Due On Date Null', string(triggerBody()?['$dueOn']))

I am assuming that the 'dueOn' field is one of the base properties of the input, and I've put belt and braces around that to ensure that it's placed in as text if it exists.

 

Similarly, you could react to any field values that you care about being null with a strong or() statement. So, for example here, I would keep that dueOn expression in the subject, above, but also have this in the 'To' field:

if(
    or(
        equals(triggerBody()?['$dueOn'], null), 
        equals(triggerBody()?['$changeType'], null), 
        equals(triggerBody()?['$description'], null)
    ), 
    'chase@yourcompany.com', 
    'theNormalEmail@yourcompany.com'
)

This example checks the dueOn, changeType, and description, fields, and if any of them are null, it will send you an email telling you about it. I've separated out the lines to make the logic clearer.

 

Obviously with any of these I'm speaking purely via examples, not your literal values, as I don't know the schema.

Incorrectly Set Schema?

Lastly, take a close look at the Schema, when you passed the example data through to it to build it, did it perhaps have something in a field (like numbers only in a field that is usually a string, perhaps) whereby it's expecting the wrong type of information.

 

If I'm thinking right, though, then the flow wouldn't fire ... but still worth checking.

klishb
Regular Visitor

Ever figure this out?  I'm having the same problem.  Maybe I need to work on my handling of null values as well, but my received http request will also provide an inventory# string.  If I test my flow I can see it in the raw output from my http request, but for some reason the very next step doesn't have a value for inventory# in dynamic content when the flow runs.

FY1
Regular Visitor

Did anyone figured a way to fix this? 

 

I am having a Json object that has all its fields filled correctly, the moment I want to use the dynamic content it shows that those fields are empty.

 

Please let me know if you have any idea on how to proceed.

 

Also any idea where the dynamic content is stored so I can explore the expressions?

 

Thank you!

Helpful resources

Announcements

Power Platform Connections - Episode 7 | March 30, 2023

Episode Seven of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft MVP Dian Taylor, alongside the latest news, product reviews, and community blogs.     Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show!      Show schedule in this episode:    0:00 Cold Open 00:30 Show Intro 01:02 Dian Taylor Interview 18:03 Blogs & Articles 26:55 Outro & Bloopers    Check out the blogs and articles featured in this week’s episode:    https://francomusso.com/create-a-drag-and-drop-experience-to-upload-case-attachments @crmbizcoach https://www.youtube.com/watch?v=G3522H834Ro​/  @pranavkhuranauk https://github.com/pnp/powerapps-designtoolkit/tree/main/materialdesign%20components @MMe2K​ https://2die4it.com/2023/03/27/populate-a-dynamic-microsoft-word-template-in-power-automate-flow/ @StefanS365 https://d365goddess.com/viva-sales-administrator-settings/ @D365Goddess https://marketplace.visualstudio.com/items?itemName=megel.mme2k-powerapps-helper#Visualize_Dataverse_Environments @MMe2K    Action requested:  Feel free to provide feedback on how we can make our community more inclusive and diverse.    This episode premiered live on our YouTube at 12pm PST on Thursday 30th March 2023.    Video series available at Power Platform Community YouTube channel.    Upcoming events:  Business Applications Launch – April 4th – Free and Virtual! M365 Conference - May 1-5th - Las Vegas Power Apps Developers Summit – May 19-20th - London European Power Platform conference – Jun. 20-22nd - Dublin Microsoft Power Platform Conference – Oct. 3-5th - Las Vegas    Join our Communities:  Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community    If you’d like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions.       

Announcing | Super Users - 2023 Season 1

Super Users – 2023 Season 1    We are excited to kick off the Power Users Super User Program for 2023 - Season 1.  The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts.      Super User Season 1 | Contributions July 1, 2022 – December 31, 2022  Super User Season 2 | Contributions January 1, 2023 – June 30, 2023    Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile.  Power Apps  Power Automate  Power Virtual Agents  Power Pages  Pstork1*  Pstork1*  Pstork1*  OliverRodrigues  BCBuizer  Expiscornovus*  Expiscornovus*  ragavanrajan  AhmedSalih  grantjenkins  renatoromao    Mira_Ghaly*  Mira_Ghaly*      Sundeep_Malik*  Sundeep_Malik*      SudeepGhatakNZ*  SudeepGhatakNZ*      StretchFredrik*  StretchFredrik*      365-Assist*  365-Assist*      cha_cha  ekarim2020      timl  Hardesh15      iAm_ManCat  annajhaveri      SebS  Rhiassuring      LaurensM  abm      TheRobRush  Ankesh_49      WiZey  lbendlin      Nogueira1306  Kaif_Siddique      victorcp  RobElliott      dpoggemann  srduval      SBax  CFernandes      Roverandom  schwibach      Akser  CraigStewart      PowerRanger  MichaelAnnis      subsguts  David_MA      EricRegnier  edgonzales      zmansuri  GeorgiosG      ChrisPiasecki  ryule      AmDev  fchopo      phipps0218  tom_riha      theapurva  takolota     Akash17  momlo     BCLS776  Shuvam-rpa     rampprakash  ScottShearer     Rusk  ChristianAbata     cchannon  Koen5     a33ik  Heartholme     AaronKnox  okeks      Matren   David_MA     Alex_10        Jeff_Thorpe        poweractivate        Ramole        DianaBirkelbach        DavidZoon        AJ_Z        PriyankaGeethik        BrianS        StalinPonnusamy        HamidBee        CNT        Anonymous_Hippo        Anchov        KeithAtherton        alaabitar        Tolu_Victor        KRider        sperry1625        IPC_ahaas      zuurg    rubin_boer   cwebb365   Dorrinda   G1124   Gabibalaban   Manan-Malhotra   jcfDaniel   WarrenBelz   Waegemma   drrickryp   GuidoPreite    If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances.  Once they are received the list will be updated. 

Register now for the Business Applications Launch Event | Tuesday, April 4, 2023

Join us for an in-depth look into the latest updates across Microsoft Dynamics 365 and Microsoft Power Platform that are helping businesses overcome their biggest challenges today.   Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating, and creating using AI-powered capabilities, driving productivity with automation—and building towards future growth with today’s leading technology.   Microsoft leaders and experts will guide you through the full 2023 release wave 1 and how these advancements will help you: Expand visibility, reduce time, and enhance creativity in your departments and teams with unified, AI-powered capabilities.Empower your employees to focus on revenue-generating tasks while automating repetitive tasks.Connect people, data, and processes across your organization with modern collaboration tools.Innovate without limits using the latest in low-code development, including new GPT-powered capabilities.    Click Here to Register Today!    

Check out the new Power Platform Communities Front Door Experience!

We are excited to share the ‘Power Platform Communities Front Door’ experience with you!   Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well.   Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities.     Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.      Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023

We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida.   Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more.   Register today: https://www.powerplatformconf.com/   

Users online (2,033)