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.
The problem lies in the next step. And I can understand why this would fail on update and pass on create.
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:
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?
Solved: the answer:
the float fails as well
Are you saying don't need it or are you asking if it does need it on the update?
I changed the int to a float and still get a similar message on the update:
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.
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
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492