Unanswered

How to convert Text Value tu Number in Data Table Column?

(0) Share

Report

Posted on by sashamasha

I want to sort the data table in descending order. However, the data in the column is text. How can I convert it to a number?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (13)

Answers (0)

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (1)

Report

You could loop the datatable with for each loop and use convert text to number -action
For each loop generates CurrentItem. Reference the "procent" column like so %CurrentItem['procent']%

Was this reply helpful? Yes No
sashamasha 10 on at

Like (0)

Report

It stored a separate value.
But I want to update the column value. I need to change the column data type.
Thank you for the suggestion

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@sashamasha

You just use "convert text to number" action where it will automatically takes conversion string to number in background.

Please refer the below example with screenshot:
Checking value and type after executing my first line code:

After conversion:
data type automatically changed from text to string.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

You can use Update data table item -action. Set variable that counts the current row. It starts from 0 and increases every loop.

Was this reply helpful? Yes No
NathanAlvares24 1,714 Moderator on at

Like (1)

Report

Hi @sashamasha !

Try this flow.

Use a "Loop" action to get loop index so that you can then use "Update data table item" action.

I hope this helps.

Was this reply helpful? Yes No
sashamasha 10 on at

Like (0)

Report

"Converting text to a number" works for text, but I need to change the data table column type to a number so that I can sort the data table.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (1)

Report

@sashamasha

Then follow above @eetuRobo suggested solution for the same. Use some counter variable and increment it on each iteration.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
sashamasha 10 on at

Like (0)

Report

it seems that it does not work

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@sashamasha

Sort your data table with index value not with name.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
sashamasha 10 on at

Like (0)

Report

Was this reply helpful? Yes No