Announcements
HiI am using Excel data source - I have the date picker in PowerApps - I select the date and the time from the dropdowns, when I submit the form it captures the date but the time is 1 hour out (2am becomes 1am).How can I get it so the time shows exactly what had been selected in the dropdowns? My PC is set to UK and everything else is as far as I can see.
Many thanks
Hello @russelln1 ,I understand your frustration. I had the same issue recently when i was scheduling a community event.The UK timezone is advanced by 1 hr because of the time of the year. It is Summer time in UK, hence 1hr more than usual.Just see how you can play with it to get your values right. It is not a bug though.You can read more here British Summer Time - WikipediaAccept this as a solution if it works for you.
Not helping! I know how the UK summertime works. - what I want is for the time to display the same as what the user has selected in the form on Powerapps . i.e. if they select 02.15 then I want the data source to show 02.15 and not 01.15
I think unless you use a work-around for the meantime.How are you submitting the data to excel? Are you doing a patch? or Submit.If it is a patch, you can add this piece of code to the time column.
DateAdd(YourTimeHere,1,Hours)
It is a temporal solution until the summertime is over...
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 392 Most Valuable Professional
11manish 181 Super User 2026 Season 2
MS.Ragavendar 112 Super User 2026 Season 2
