Convert string to number

(1) Share

Report

Posted on by ckserra33

421

Hi everyone, good morning.

I am using power automate to list rows from a spreadsheet. In the spreadsheet, one of the columns is being treated as a text field, however it contains a number. I have the column type set to number, but flow still treats it as a string. I have used various methods I have found online to convert to int or float but nothing is working. Below are some of the ideas I have found.

int(trim(first(body('List_rows_present_in_a_table_Seed_Sheet')?['value'])?['DaysSinceLastCreditTran']))
int(item()?['DaysSinceLastCreditTran'])
float(item()?['DaysSinceLastCreditTran'])
 
I have tried in a compose as well as a filter array and am very frustrated at this point.

Any help would be amazing!

Thanks
 
Chris

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

ivan_apps 2,187 Moderator on at

Like (0)

Report

Can you try breaking down the individual functions in separate compose statements and let us know the results after each step? For example:

body('List_rows_present_in_a_table_Seed_Sheet')?['value']

first(body('List_rows_present_in_a_table_Seed_Sheet')?['value'])

first(body('List_rows_present_in_a_table_Seed_Sheet')?['value'])?['DaysSinceLastCreditTran']

trim(first(body('List_rows_present_in_a_table_Seed_Sheet')?['value'])?['DaysSinceLastCreditTran'])

int(trim(first(body('List_rows_present_in_a_table_Seed_Sheet')?['value'])?['DaysSinceLastCreditTran']))

After trim() you should see a string that looks like a number if everything else before that was done correctly.

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

You could convert DaysSinceLastCreditTran to an integer using the Select action along wiht an expression as shown below:

setProperty(item(),'DaysSinceLastCreditTran', int(item()?['DaysSinceLastCreditTran']))

Here it is in the new designer:

Then use the output of the Select action for the rest of the flow:

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No