Expected Integer but got string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Folks,

Reading in a CSV file using the ParseCSV tool. I then read the data in and process it as a JSON, which works well until the subject error occurs. As its a text file and effectively a long text string, I guess I need to keep all values as string only, and then look to convert the field into a number or an integer (which is the best for really, big numbers?) - or am I missing something here?

Thanks

Categories:

Using flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous,

I assume that the issue is caused by the ParseCSV action to consider the subject as an integer.

As a workaround, you could initialize an array variable to store new array that restructures the JSON. Steps as below, add a Apply to each action to loop the original JSON, then add double quotes at the subject property:

{ "subject": "@{item()?['subject']}", "Name": @{item()?['Name']} }

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.

Was this reply helpful? Yes No