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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / For a selected row/sha...
Power Automate
Unanswered

For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date

(1) ShareShare
ReportReport
Posted on by 43
Hello,
 
I have an excel document with a few columns including a date and time column.

For a selected line (my trigger) my flow will feed a word template while creating a sharepoint list and sending an email.
 
In the email, no worries, I have the "date and time" field.
But it blocks in the recording in the sharepoint list with the following message:
The 'inputs.parameters' of workflow operation 'Update_file_properties_2' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Date' is required to be of type 'String/date'. The runtime value '"30/7/24 12:00 AM"' to be converted doesn't have the expected format 'String/date'.
 
After browsing the web, I see that in "lists rows", it is possible to select in DateTime Format "iso 8601" but in the trigger "For a selected row", I do not have this option...and I loop on this error.
 
A huge thank you for your help
Categories:
I have the same question (0)
  • abc 123 Profile Picture
    789 Moderator on at
    It probably wants the date in this format: 2007-04-05T14:30Z
  • doublenico79 Profile Picture
    43 on at
    Thanks but how can i do it?
  • abc 123 Profile Picture
    789 Moderator on at
    The Text() function has presets. Try the UTC.
     
    If not, there are a host of date functions that will help you dissect a date, and then you can put it into the desired format.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard