
Announcements
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
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))