web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / 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) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,452 Super User 2025 Season 2 on at
    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 Profile Picture
    115 on at
    Hey,
     
    Try this formula in the OnSelect button
    Text(
        Text(
            DatePicker1.SelectedDate,
            "yyyy-MM-dd"
        ) & "T" & 
        Text(
            TimePicker.Selected.Value,
            "HH:mm:ss"
        ) & "Z"
    )
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard