Urgent - Append .00 to certain values in datatable

(0) Share

Report

Posted on by Kosenurm

802

Hi there,

I am using PAD to read from a CSV into a datable.

Two columns in my datatable are numeric, but I need the datatable to apply some appendages based on the below conditions. Can anyone help me out as to how I do this please?

For each value in both the columns, if the value is "0" OR if the value contains ".", do nothing; else, append ".00" to each, in the datatable.

Many thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kosenurm

Try this flow design

Condition used is

Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
Kosenurm 802 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply.

I am actually using Launch Excel to open the CSV and then read values from it. I've used your steps as written, but it errors saying that column or property ['Size'] cannot be found.

Any ideas on this one?

Thanks
K

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Kosenurm

the Size is the name of column where i am appending the .00 depending upon the condition. Sorry i have forget to mention the structure of csv file which i am using

So in my have to do manipulation on Size column, so i have specified Size column there, in your case column name would be different so specify it accordingly inplace of Size 🙂

Hope it helps !

Was this reply helpful? Yes No