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

Community site session details

Session Id :
Power Apps - Building 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?

Categories:
I have the same question (0)
  • Shanescows Profile Picture
    2,218 Most Valuable Professional on at
    Re: SharePoint Date Field Strange Issue

    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
    Re: SharePoint Date Field Strange Issue

    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
    Re: SharePoint Date Field Strange Issue

    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
    Re: SharePoint Date Field Strange Issue

    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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 819 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 308 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 222 Super User 2025 Season 2

Last 30 days Overall leaderboard