cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Date not passing correctly from app to flow

I've built an app with a datepicker that sends info, including this date, to a flow that places it in a sharepoint list. The following error is happening:

BCLS776_0-1603332033503.png

The request from the app shows:

BCLS776_1-1603332167857.png

 

The app is expecting to send out a date: 

BCLS776_2-1603332270321.png

The flow is set up to send this to a column in the sharepoint list that is formatted for date-only.

Can anyone tell me why this error is happening and what else I need to do to make this date readable for the flow? TIA.

 

 

4 REPLIES 4
Community Support
Community Support

Hi @BCLS776 :

I'v made a similar test but did no encounted the problem you mentioned.

I suggest you convert the text type parameter ‘triggerBody()?[’Createitem_WorkDate’]’ into a date type in flow and try again.

For example:

formatDateTime(triggerBody()?[’Createitem_WorkDate’])

 2.JPG

Best Regards,

Bof

Hi @v-bofeng-msft ,

I tried the solution with the formatDateTime expression in the flow and the same error continues to come up.
I also tried:
- Disconnecting the flow from the app and re-establishing the connection with a new Run function call

- Replacing the datepicker argument to the Run function call with a Today()

 

The result is the same in all cases: a run-time error for the app attempting to pass a string into a date column. Any other ideas?

Update: the problem has recurred, so I'm reaching out to Support now.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (47,265)