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

Community site session details

Session Id :
Power Automate - Building Flows
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
I have the same question (0)
  • abc 123 Profile Picture
    784 Moderator on at
    For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date
    It probably wants the date in this format: 2007-04-05T14:30Z
  • doublenico79 Profile Picture
    43 on at
    For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date
    Thanks but how can i do it?
  • abc 123 Profile Picture
    784 Moderator on at
    For a selected row/sharepoint: Inputparameter 'item/Date' is required to be of type String/date
    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

Coming soon: forum hierarchy changes

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
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard