web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Expected Integer but g...

Power Automate

Answered

Expected Integer but got string

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

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

Join the conversation