SharePoint List - input string was not in a correct format

(1) Share

Report

Posted on by zwornik80

102

My Flow failed during "Create item" step. Below is screen with an error. I think it is because Ã in string

"Ãland Islands". But I ma not 100% sure as logging does not say so explicitly. Is there a way to skip/silence this error?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

efialttes 14,756 on at

Like (2)

Report
Re: SharePoint List - input string was not in a correct format

Hi!

Just for troubleshooting purposes, I would try to replace temporarily current 'Country name' input, assign a dummy text instead and reexecute the flow? So if 'Create item' now works, you will 100% sure the problem is due to the special character

Now let's assume your hypothesis is confirmed. Let's also assume your flow currently assigns as the input to 'Country name' SP column a string variable called 'myInputCountryName'

You can get rid of this special character by assigning the following WDL expression instead:

replace(variables('myInputCountryName'),'Ã','A')

Hope this helps

Was this reply helpful? Yes No
fmiatech 8 on at

Like (1)

Report

Re: SharePoint List - input string was not in a correct format

Were you able to find the solution to this problem? I am running into the same problem with a create item on Sharepoint. It works on one of my lists, but the other two throw this input error. Just wondering if you found a way to fix the problem. Thanks!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: SharePoint List - input string was not in a correct format

You need to make sure that format of each column in your SP list is correct. ie. if input filed on MS form is date format but SP list has a number format and you are trying to put there that date...then it won't work and show you this error.
Cheers
Rafal

Was this reply helpful? Yes No