cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Date formatting issues - excel power apps spreadsheet

Hello, I am using the helpdesk template included in powerapps, Ive got a workflow that runs everytime someone submits a form created for a helpdesk submissions list in sharepoint. it will update my helpdesk powerapps spreadsheet with the info entered. I have a column named current date that is using date and time format from sharepoint. When the workflow passes that date to the excel spreadsheet it uses a wierd format that the powerapps spreadsheet doesnt recognize as valid for the date throwing the datecreated field off. I need it to look like 5/12/2016 and sharepoint is formatting it as 2016-05-12

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper IV
Helper IV

Re: Date formatting issues - excel power apps spreadsheet

Figured it out, infopath form was causing it, was setting current date with today() function, had to alter it to use. concat(substring(today(), 6, 2), "/", substring(today(), 9, 2), "/", substring(today(), 1, 4)) 

View solution in original post

1 REPLY 1
Highlighted
Helper IV
Helper IV

Re: Date formatting issues - excel power apps spreadsheet

Figured it out, infopath form was causing it, was setting current date with today() function, had to alter it to use. concat(substring(today(), 6, 2), "/", substring(today(), 9, 2), "/", substring(today(), 1, 4)) 

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,982)