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

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (4,688)