Answered

My Date Time Column from SharePoint list appears distorted on Power Apps

(0) Share

Report

Posted on by rameshmukka

1,133

I just added my DateTime Column from SharePoint list to Power Apps form. I dont know why it came as distorted when I open the calendar to select a date. Its not at all clear. Have anyone experienced this or know the cause? Please help.

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

Verified answer

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka ,

I have tried adding the same on my app but it is working as expected. See the below:
Please go ahead and remove the control and try adding again.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RameshMukka ,

Do you mean that the Date Picker control does not work as expected in your canvas app?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The Date Picker control generated from Date time field in my SP List works well:

Please consider add a new Date Picker control in your canvas app, then check if the issue still exists. If not, as an fixed solution, please unlock the Schedule field data card in your Edit form, then remove the original Date Picker control from it, instead, add a new Date Picker control inside it, then re-bind the new Date Picker control with the Update property of the Schedule field data card.

Set the Update property of the Schedule field data card to following:

DatePicker1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)

Set the DefaultDate property of the new added DatePicker control to following:

Parent.Default

Please consider take a try with above solution, then check if the issue is solved.

Best regards,
rameshmukka 1,133 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft and @KrishnaV Thank you for your time on this. I really dont know what happened yesterday, it wasn't showing me clear calendar yesterday. Today, as you see below, its working fine without me doing any changes.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka ,

Thanks for your feedback. I think the issue that you faced may be temporary issue.

If you have solved your problem, or the solution I provided above is helpful in your scenario, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

Of course, if you have any other questions in Power Apps, please feel free to contact us here.

Best regards,
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka,

I am very happy that the issue is resolved for you. Please mark the relevant reply as solution so that the new members will make use of this.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka ,

If the reply I provided above is also helpful in your scenario, please also consider go ahead to click "Accept as Solution" to identify my reply as helpful.

Best regards,