Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Import & Update Excel Values To SharePoint With Flow

(0) ShareShare
ReportReport
Posted on by 30

SO I just finished watching Import & Update Excel Values To SharePoint With Flow.  This was very helpful.  I am having an issue on update_item action on the date fields.  Not sure why as the same functions I am using work fine on the create_item action.  See below:

 

The "Get Items" work fine.  It gets the value and then tests for an empty condition.

 

9-23-2019 4-31-38 PM.jpg 

 

 

The problem lies in the next step.  And I can understand why this would fail on update and pass on create.

 

9-23-2019 4-26-01 PM.jpg

 

I have the same function on the update as I do on the create.  The error message is on the int function and is as follows:

 

9-23-2019 4-56-00 PM.jpg

 

Not understanding why it would work on create and not on update.  At first, I thought this was a case of copying and pasting; but no.  I get this error regardless.   Any ideas?

  • fhtech Profile Picture
    30 on at
    Re: Import & Update Excel Values To SharePoint With Flow

    Solved:  the answer:

     

    addDays(addDays(formatDateTime('1900-01-01T00:00:00'),int(items('Apply_to_each')?['ContractorAssignDate'])),-2)
  • fhtech Profile Picture
    30 on at
    Re: Import & Update Excel Values To SharePoint With Flow

    the float fails as well

     

    InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '1' and column '2022': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
     
  • fhtech Profile Picture
    30 on at
    Re: Import & Update Excel Values To SharePoint With Flow

    Are you saying don't need it or are you asking if it does need it on the update?

  • fhtech Profile Picture
    30 on at
    Re: Import & Update Excel Values To SharePoint With Flow

    I changed the int to a float and still get a similar message on the update:

    InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '1' and column '2022': 'The template language function 'float' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
     
    Still can't determine what's going on here.
     
  • v-litu-msft Profile Picture
    on at
    Re: Import & Update Excel Values To SharePoint With Flow

    Hi @fhtech,

     

    Since the date formate is the date with time, if you create item it will not have a problem, but if you update it, the int() function can not process the string.

    You should add a format at the end of the addDays expression when you create an item, so do it need in the update item.

    addDays('1900-01-01T00:00:00Z',sub(int(item()?['Date']),2),'MM-dd-yyyy')

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Gristy Profile Picture
    2,429 on at
    Re: Import & Update Excel Values To SharePoint With Flow

    On the create side the value is null, i assume on the update site it has some value so that is likely why it is failing because it does not like the date value you are passing as a string.

     

    what type of column is it, is it date or date/time? If date/time you may need to use float as per this example: https://powerusers.microsoft.com/t5/Building-Flows/Excel-dates-turned-into-integers/td-p/130364

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492