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

[Tapesh]

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. 

Thanks in advance all experts. 

[Mira_Ghaly]

@Tapesh 

can you please show the rest of the screenshot?

[Tapesh]

Hi @Mira_Ghaly 

Please have a look at screenshot of the flow 

[Mira_Ghaly · Accepted solution]

@Tapesh 

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

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