Skip to main content

Notifications

Power Automate - Building Flows
Answered

ITEMS DATE FROM EXCEL TO SHAREPOINT

(0) ShareShare
ReportReport
Posted on by 290

Hello,
I have an Excel Online table that I want to add Dates to a Sharepoint List, but I can only pass 2 items, not all of them.

How can I solve that?

 

fgonzalez515_0-1646369264493.png

 

fgonzalez515_1-1646369282719.png

 

fgonzalez515_2-1646369309070.png

 

fgonzalez515_3-1646369521461.png

 

 

 

 

  • Verified answer
    jedunn Profile Picture
    jedunn 123 on at
    Re: ITEMS DATE FROM EXCEL TO SHAREPOINT

    You would use an if statement to check for null values in the date item. Because I'm still learning I don't know how to do that with expressions but this article might be a place to start... Handling Excel Dates in Microsoft Power Automate (shanebart.com). There might be other helpers on the forum with previous tips for constructing if statements.

  • fgonzalez515 Profile Picture
    fgonzalez515 290 on at
    Re: ITEMS DATE FROM EXCEL TO SHAREPOINT

    Hi @jedunn,

     

    How would be the expression that indicates?

    To make it more resistant

  • jedunn Profile Picture
    jedunn 123 on at
    Re: ITEMS DATE FROM EXCEL TO SHAREPOINT

    I found the following post that may help you:

    There are also some folks posting on other sites about how to do this. I found some useful information while searching 'flow convert excel date to datetime'.

     

    It looks like the common solution is to add an expression to the create item action

    jedunn_0-1646423697606.png

     

    I used the following expression but you can make this more robust to missing/empty values with some if conditions in the expression.

    addDays('1899-12-30', int(item()['Date']), 'MM-dd-yyyy')

     

  • fgonzalez515 Profile Picture
    fgonzalez515 290 on at
    Re: ITEMS DATE FROM EXCEL TO SHAREPOINT

    Hi @jedunn 

     

    That's how it is. 

    In the two error items are in Date format in Excel Online.

     

    fgonzalez515_0-1646405503755.png

     

    fgonzalez515_1-1646405527000.png

     

     

  • jedunn Profile Picture
    jedunn 123 on at
    Re: ITEMS DATE FROM EXCEL TO SHAREPOINT

    Is the date in the Excel workbook stored in Excel's serial date format? If so, you may need to convert it before adding days. Perhaps.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard