web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Issue with Date and Ti...

Power Automate

Suggested Answer

Issue with Date and Time Formatting When Scheduling Teams Message via Power Apps and Power Automate

(0) Share

Report

Report

Posted on by Eldor488

27

Hello everyone,

I'm working on a Power Apps solution that integrates with Power Automate to schedule posts in Microsoft Teams channels. The idea is to allow users to select a team, channel, message, and a scheduled date and time for the post. However, I'm running into an issue with the date and time formatting.

The Setup:

Power Apps:
- Users select a team and channel via dropdowns.
- They then choose a date using a DatePicker and a time using a TimePicker.
- The OnSelect property of a button triggers a Power Automate flow, passing the selected team, channel, message, and the combined date and time.
- Here is the code for the on select property:
```
ScheduleTeamChannelPostfromPowerApp.Run(
    DropdownTeam.Selected.id,
    DropdownChannel.Selected.id,
    TextInputTitle.Text,
    TextInputMessage.Text,
    Text(
        DatePicker1.SelectedDate,
        "yyyy-MM-dd"
    ) & "T" & 
    Text(
        TimePicker.Selected.Value,
        "HH:mm:ss"
    )
)
```
Power Automate:
- The flow is set up to accept the date and time as a text input.
- The flow uses this input in a "Delay until" action to schedule the message.

The Issue:

Despite attempting to format the date and time in Power Apps using the Text() function (to convert the date and time to yyyy-MM-ddTHH:mm:ss), I'm receiving a schema mismatch error in Power Automate. The error specifically mentions a "TriggerInputSchemaMismatch" with details pointing to a missing or incorrect input.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

If you change your input value for the DateTime, and just hardcode a string, since it does not care which, does it still fail?

Also, have you changed the Trigger Inputs at ALL and forget to refresh the Flow IN your App? If you dont you will get that error.
Suggested answer

Robby_WW 115 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey,

Try this formula in the OnSelect button

Text( Text( DatePicker1.SelectedDate, "yyyy-MM-dd" ) & "T" & Text( TimePicker.Selected.Value, "HH:mm:ss" ) & "Z" )

Join the conversation