Error saving SelectedDate to SharePoint document library column (TriggerInputSchemeMismatch) using Flow

[Rob_CTL]

Hi, 

I am submitting an image from PowerApps into a SharePoint document library, the image saving is working great but I am trying to capture the value of a Date Picker and update a column within the document library.  I am calling a Flow that does the image save to the document library then does a file properties update which I was hoping would update a column called "Date" with the value from the PowerApps date picker. 

I am calling Flow with the following:

MileageRecord-MileageImageUploadtoDocumentLibrary'.Run(varUser.FullName & "- Start - " & date_newrecordday_date.SelectedDate & ".jpg",varStartDayMileageBase64Only, date_newrecordday_date.SelectedDate)

However I am getting the following error in PowerApps, this is before the Flow is even triggered.

'TriggerInputSchemaMismatch' Message: The input body for the trigger 'manual' of type 'Request' did not match its schema definition.  Error details: String 13/5/2022 does not validate against format date

It looks like the output from SelectedDate is a string rather than a Date format, is there an easy way I can convert this in the Flow command so it's passed to Flow in a format it's happy with?

Any help gratefully received.

Rob

[Anonymous]

This looks like it is a mismatch between date formats,
You have a valid UK date which is 13/05/2022 whereas the expected result is 05/13/2022.

Which date are you passing in you might just need to convert your dates to the US time format.

[Rob_CTL]

Thanks for the reply @Anonymous  the thing that is standing out is the word "String" so it looks like the output is a String rather than a Date format, but I might be reading the error wrong.

[Anonymous]

Ji @Rob_CTL the error message is stating that your string 13/05/2022 does not match a valid date hence it is failing to write to the list.

Ive hit this a couple of times before and SelectedDate usually works  but could you try running

Text(date_newrecordday_date.SelectedDate, mm/dd/yyyy)

Not tried this in real life but this is just off the top of my head
Other option that seems to work for me is to write the record then pick the date up from the flow.

[Anthony_Dob]

Have you tried setting the SelectedDate to a variable and sending this in your flow? Might just do the job.

Best Regards,

Anthony

[Rob_CTL]

Thanks for the help @Anthony_Dob @Anonymous but all the options result the same error.  

[Rob_CTL]

Hi, I'm still fighting with this one, anybody with some other ideas?

Thanks!

[Anthony_Dob]

@Rob_CTL ,

Let's begin in the beginning. Is the order of the values which you return in your flow in the correct order? Flows will expect values to be in a particular order. Sure you did not put them in the wrong order?

Best Regards,

Anthony

[Anthony_Dob · Accepted solution]

Also,

This topic has the same issue: https://powerusers.microsoft.com/t5/Building-Power-Apps/Powerapps-passing-datafields-to-PowerAutomat...

This was solved with the following youtube video (watch at 6:50): https://www.youtube.com/watch?v=emAhLzVG9bM

Best Regards and good luck,

Anthony

[Rob_CTL]

Thanks @Anthony_Dob that answered my question perfectly