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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Powerapps will not tra...
Power Apps
Answered

Powerapps will not transfer data correctly in a sharepoint list

(0) ShareShare
ReportReport
Posted on by 18

Hello,

I am currently building a timesheet and wanted to add data values for date, hour, minutes, and AM/PM. It was placed in military time which worked with sharepoint list however I wanted to change it to AM/PM. I found a forumn online that linked some code to be inputed that will change everything from military to AM/PM. (One of the snippets attached) It worked, however when data is entered into the powerapp and sent to the sharepoint list, the list will pick everything up (hourly, date, minutes) EXCEPT the input of AM/PM. I am confused on what to do. Below I attached some snippets of what the app looks like, the code I used from a staff member to enter, and the default value of the AM/PM value. 

 

Thank you,

Nick 

 

UPDATE: 

 

Now for some reason, when I enter in the check-out time and check-in time, the sharepoint list will only paste the Check-out time for both Check-out and Check-in time columns. AM/PM is still in the same current state. 

UPDATE.PNG

snip of power app.PNG
snip of power app edit.PNG
snip of Time code.PNG
Categories:
I have the same question (1)
  • Verified answer
    Nickb11 Profile Picture
    18 on at

    EDIT: Problem has been fixed. 

     

    Needed to change: 

    DateValue1.SelectedDate + Time(If(AmPmValue1.Selected.Value = "PM", 12, 0) + Mod(Value(HourValue1.Selected.Value), 12), Value(MinuteValue1.Selected.Value), 0)

     

    To...:

    DateValue2.SelectedDate + Time(If(AmPmValue2.Selected.Value = "PM", 12, 0) + Mod(Value(HourValue2.Selected.Value), 12), Value(MinuteValue2.Selected.Value), 0)

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @Nickb11 ,

    Have you solved your problem?

     

    If you have solved your problem, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

     

    Best regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard