Answered

Date/Time correct in power apps gallery but not the form

(0) Share

Report

Posted on by Emily2

Hi,

I'm relatively new to PowerApps. I've built a canvas app with a screen where on the left is a gallery and the right shows the form related to the item selected in the gallery. One of the pieces of data that appears in the gallery and the form is a date+time. The source of the data is a sharepoint list.

In the gallery, the date+time correctly reflects what's in the Sharepoint site (the sharepoint site doesn't show the correct time the email was actually received but that's a problem for another day). See below:

However when I click on this entry and look at the form it tells me:

This entry is fine:

Gallery -

Form -

But this entry isn't:

Gallery -

Form -

So I think the form doesn't like when the hour or minute of the time starts with a '0'. But why not? This is what I can't figure out. Ideas much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Emily2 ,

Could you share the formula and screenshots?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Emily2 41 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-xiaochen-msft
Thank you so much for responding, and apologies for not getting back sooner. There's too much sensitive data in the screenshot to be able to send one over easily, even blanked out. But I have been able to resolve this this afternoon with an If function.
The Default property of the hour and minute values was:
Minute(Parent.Default)
I have now changed it to the below, which works well.
If(Minute(Parent.Default)<10,Concatenate("0",Text(Minute(Parent.Default),"#")),Text(Minute(Parent.Default),"0"))

Thanks again for responding! Emily

Was this reply helpful? Yes No