Answered

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

(0) Share

Report

Posted on by 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

All responses (9)

Answers (1)

Rob_CTL on at

Like (0)

Report

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

Thanks @Anthony_Dob that answered my question perfectly
Verified answer

AnthonyD 559 on at

Like (1)

Report

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

Also,

This topic has the same issue: https://powerusers.microsoft.com/t5/Building-Power-Apps/Powerapps-passing-datafields-to-PowerAutomate-and-getting-this/td-p/776381

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
AnthonyD 559 on at

Like (0)

Report

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

@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
Rob_CTL on at

Like (0)

Report

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

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

Thanks!
Rob_CTL on at

Like (0)

Report

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

Thanks for the help @Anthony_Dob @Anonymous but all the options result the same error.
AnthonyD 559 on at

Like (0)

Report

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

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

Best Regards,
Anthony
Community Power Pla... on at

Like (0)

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

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.
Rob_CTL on at

Like (0)

Report

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

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.
Community Power Pla... on at

Like (0)

Report

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

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.