Announcements
Pls how can i update this data card to ensure the correct pick of either am or pm
DateValue1.SelectedDate + Time(Value(HourValue1.Selected.Value), Value(MinuteValue1.Selected.Value), 0)
Hi @majorpinpin ,
Would you please elaborate the requirement ?
if you are trying to convert a date into AM or PM below code will help.
DateTimeValue(Text("YourDateTimeValue",DateTimeFormat.LongDateTime))
Thank you
I have a sharepoint list as a data source, the start time and end time has "time and date" as data type and when connected to my powerapps gave me a dropdown of numbers. When users try to pick a start and end time, they cant differentiate when its AM or PM and this is giving the wrong total hours spent on an activity on my share point list.
So i need a function to have a dropdown of AM & PM. So i am asking if i can get a function to update the data card
Hi @PriyankaGeethik,
Based on the issue that you mentioned, do you want to change the time format from 24 hour to 12 hour?
Actually, you could change it from the SharePoint site directly.
1). Go to the gear icon and select the Site Information>View all site settings
2). Choose the Regional settings, change the time format
What's more, you should pay attention that if you just want to do date difference calculation, you could do this using the Text() function.
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 356 Most Valuable Professional
11manish 225 Super User 2026 Season 2
Mohsin Ali 211
