web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Jotform Submission Dat...
Power Automate
Unanswered

Jotform Submission Date/Time Problem

(0) ShareShare
ReportReport
Posted on by 2

I keep running into an error when I try to adjust an incoming date field from a Jotform.  Jotform, for some reason, doesn't send a time zone with their date field, so in order to get it to land on a calendar correctly, I've been using addhours to do the adjustment.  This worked without a problem until suddenly it didn't.  No change was made to the form or the incoming data - it still shows up in the incoming feed.  If I try to run the flow without adjusting the date/time, it lands on the calendar, just several hours off of the correct time.  Now, when I apply the addhours expression to the dynamic incoming date, it errors out and says that it is expecting a string value and is getting a null one.  It's not a null value - it shows up correctly in the incoming data.  What am I doing wrong?

Categories:
I have the same question (0)
  • chrismassey Profile Picture
    2 on at

    Here's a ridiculous twist: other dates and times in the form work with addhours just fine.  It's just the one field I actually need it to increment the time that it fails on.

  • takolota1 Profile Picture
    4,980 Moderator on at

    @chrismassey 

     

    I dealt with this soooooo many times with JF. It should be a simple fix though.

     

    Just set anything like that with an expression like…

    if(empty(DateDynamicContent), ‘’, DateWithNonNullExpressions)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 604

#2
Valantis Profile Picture

Valantis 502

#3
Vish WR Profile Picture

Vish WR 417

Last 30 days Overall leaderboard