Unanswered

Import & Update Excel Values To SharePoint With Flow

(0) Share

Report

Posted on by fhtech

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?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Gristy 2,429 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
fhtech 30 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
fhtech 30 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
fhtech 30 on at

Like (0)

Report
Copy link

Link copied!

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.'.

Was this reply helpful? Yes No
fhtech 30 on at

Like (0)

Report
Copy link

Link copied!

Solved: the answer:

addDays(addDays(formatDateTime('1900-01-01T00:00:00'),int(items('Apply_to_each')?['ContractorAssignDate'])),-2)

Was this reply helpful? Yes No