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

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Rob_CTL on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
AnthonyD 559 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Best Regards,
Anthony

Was this reply helpful? Yes No
Rob_CTL on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Rob_CTL on at

Like
a
(0)

Report
Copy link

Link copied!

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

Thanks!

Was this reply helpful? Yes No
AnthonyD 559 on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Verified answer

AnthonyD 559 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Rob_CTL on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Anthony_Dob that answered my question perfectly

Was this reply helpful? Yes No