Unanswered

Problem passing null date from PowerApps to Power Automate

(0) Share

Report

Posted on by lras1202

Hi,

I have built a PowerApps form that it takes a few metadata and upload to SharePoint Doc Library using Power Automate. There is a calendar control, DOB, sometimes, DOB is unknown. So dtDOB.selectedDate has nothing in it. When I upload the record, I am receiving a message error Flow.RUN() failed {"error": "TriggerInputSchemaMismatch", "message": "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details 'String '' does not validate against format 'date'.'."}}

DOB column is a date field, not required.

Thank you in advance for helping.

Categories:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (0)

Alex-W 306 on at

Like (0)

Report
Re: Problem passing null date from PowerApps to Power Automate

Update to my previous post... using single quotes for the null date value stopped working for me. It worked fine during testing, but today I keep on getting flow errors that say, "'item/MeetingDate' is required to be of type 'String/date'. The runtime value '"null"' to be converted doesn't have the expected format 'String/date'."

I removed the single quotes from the formula and replaced it with null and now it works again.
if(equals(triggerBody()?['date'],'1999-01-01'),null,triggerBody()?['date'])
Alex-W 306 on at

Like (0)

Report
Re: Problem passing null date from PowerApps to Power Automate

@lras1202 @Priscilla
It is now January 2024 and I can't find a lot of information online about this issue. I have a workaround for this that has been working fine so far.

On the app, use the following formula for the date field section of the OnSelect formula that runs the flow. DatePicker_Meeting is the date picker data card that I tied to the date column on SharePoint. Coalesce is used to return the date "1999-01-01" if the date picker is blank.
Coalesce(Text(DatePicker_Meeting.SelectedDate, "yyyy-mm-dd"), "1999-01-01")

On the flow, I am using the Update files property action since I am working with a document library, but the following should work with a list too. I created an expression for the date field. This expression is checking if the date received from the app is 1999-01-01. If yes, updated the date field with a blank value, else use the actual date from the date picker on the app. "triggerBody()?['date']" is the dynamic content for the date input.
if(equals(triggerBody()?['date'],'1999-01-01'),'',triggerBody()?['date'])

I used 1999 for the date if the date picker is blank because the date field will never have a date from this year. Therefore, this date could be any date.

If there is a simpler way to do this, please let me know.
Priscilla804 14 on at

Like (0)

Report

Re: Problem passing null date from PowerApps to Power Automate

have you ever resolved your issue please? as i'm encountering it just now