web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SharePoint List - inpu...
Power Automate
Unanswered

SharePoint List - input string was not in a correct format

(1) ShareShare
ReportReport
Posted on by 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?
 
1.png
 
Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at
    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

  • fmiatech Profile Picture
    8 on at
    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!

  • Community Power Platform Member Profile Picture
    on at
    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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard