Skip to main content

Notifications

Power Automate - Building Flows
Answered

Parse Date from email body to SharePoint List

Posted on by

Hi everyone,

 

I tried to parse date text from email to sharepoint list. I use this formula trim(split(body('Filter_array')[8],':')[1]) and when I put in create item, it has an error, 

 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OrderStartDate' is required to be of type 'String/date'. The runtime value '"27/09/2022"' to be converted doesn't have the expected format 'String/date'.

 

sarahairis_1-1665000459339.png

 

can anyone help me with this issue?

 

  • Verified answer
    sarahairis Profile Picture
    sarahairis on at
    Re: Parse Date from email body to SharePoint List

    Nevermind, I already resolved it. I just need to change the field type, instead of date and time, I change to single text

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard