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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to convert the any...
Power Automate
Answered

How to convert the any value in text and add to sharepoint column.

(0) ShareShare
ReportReport
Posted on by 825

HI all, 

 

i have flow which is working along with Ms froms, such that when a response is submitted and approved, it stores the data to Sharepoint list, how ever i just notice that there was an error stating 

Create item action failed

which in more specific way I would say is failed to read text value. 


However when i tried and tested the flow i found the error that if someone is sending a form with discription as below 

 

 

Black sacks – 16.22 x 5no €81.10 + VAT
Blue roll – 9.25 x 10no €92.50 + VAT
Jay Cloths – 2.75 per packet x 2no €5.50 + VAT
Vinyl gloves – 4.25 per pk x 50no (5no cases) – €212.50 + NO VAT
Latex Gloves – 7.00 per pk x 20no (2no cases – 1 large 1 medium) €140.00 + NO VAT 

 

It fails to create a item and says invalid text value. But to my extent in forms i already have said thats a text value and not number. 

 

 

Does any one from all flow experts has an idea what can be done to fix this? that any value given as input can be converted to text so the flow runs perfect no matter what someone enters in forms. 

 

Tapesh_0-1597828151058.png

 

Thanks in advance all experts. 

 

 

 

 

Categories:
  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Tapesh 

    can you please show the rest of the screenshot?

  • Tapesh Profile Picture
    825 on at

    Hi @Mira_Ghaly 

     

    Please have a look at screenshot of the flow 

    Tapesh_0-1597828984395.png

    Tapesh_1-1597829019815.png

     

     

  • Verified answer
    Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Tapesh 

    Thought the error has more details what is the type of the Description column in sharepoint , Multi lines? If yes try to enable 

     

     

    Mira_Ghaly_0-1597829315520.png

    Also as troubleshooting try to remove the description and see if it works or no

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 259 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 227 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 134 Super User 2026 Season 2

Last 30 days Overall leaderboard