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 Apps / SharePoint Date Field ...
Power Apps
Answered

SharePoint Date Field Strange Issue

(0) ShareShare
ReportReport
Posted on by 704

I'm experiencing some strange issues in my PowerApp and I'm not sure if it's a bug or if I'm just missing something.  

 

I have a very simple application with a form with a data source that points to a SharePoint list. There is a date field in this form.  First, everything submits correctly when running the app in Edit mode.  I run into this issue whe running the published version.  When published I noticed that it's submitting the item but the date field isn't being populated.  I started to de-construct the app to see what the issue could be.  I noticed when I removed my Navigate function from my submit button that the date was populated correctly.  I've attached a screenshot of my button with the navigation function.  It's simply navigating to a screen with one label that says "success".  If I remove the Navigate from my button it submits correctly.  I cannot figure out for the life of me why this would be.  Any ideas?

Screen Shot 2018-04-10 at 3.02.33 PM.png
Categories:
I have the same question (0)
  • Shanescows Profile Picture
    2,218 Most Valuable Professional on at

    That is weird. What if you put something else between the functions?

     

    Submit(Form1);false;Navigate(Screen3,Cover)

     

    I just made that up (might be a typo) but might be worth a shot. 

  • aprildunnam Profile Picture
    704 on at

    Good suggestion. Unfortunately just tried it and that didn't work either.  This is a weird issue.  One of my clients was having the issue so I decided to see if I could re-produce it on my environment and I did.  Really makes me think it's some kind of bug because I have several other PowerApps that have submit buttons with navigate functions that works.  I also discovered another strange issue if you set a default value in a SharePoint Date field, it shows up a day earlier in the PowerApp.  Lots of strangeness going on!

  • Shanescows Profile Picture
    2,218 Most Valuable Professional on at

    When working with SharePoint you have to account for the time zone. 🙂 SharePoint stores things as UTC. So if your timezone is UTC -5 (Eastern) then when you set the date to be 4/11/2018 0:00:00 (midnight) SharePoint will display that for an Eastern Time Zone user as 4/10/2018 19:00:00. 

     

    At least I fixed one part of the issue.

  • Verified answer
    aprildunnam Profile Picture
    704 on at

    Wanted to update this thread in case anyone else runs into the issue.  I went ahead and submitted a ticket and had a call with support.  Turns out this is a known issue.  Apparently it isn't recommended to use a Navigate function after the SubmitForm.  Engineering says best practice is to handle your Navigation on the OnSuccess property of your form.  I've written a blog post that explains the issue and solution in more detail:

     

    http://www.sharepointsiren.com/2018/04/powerapps-bug-sharepoint-date-field-not.html 

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!

Leaderboard > Power Apps

#1
wolenberg_ Profile Picture

wolenberg_ 119 Super User 2026 Season 1

#2
WarrenBelz Profile Picture

WarrenBelz 107 Most Valuable Professional

#3
Haque Profile Picture

Haque 103

Last 30 days Overall leaderboard