Unanswered

Excel list row present in a table converting percentages into decimals

(0) Share

Report

Posted on by Community Power Pla...

I have a flow set up that once a form is completed it fill's out a excel table that has formulas that gives percentages. Once that is completed it populates a Microsoft word template. I am coming across a issue where the "List row present in a table" is turning the percentages into a decimals is there a fix for this ?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report
@Anonymous

It is formatted in excel as percentage but it is actual stored in decimal , so you need to do the conversion in flow instead like below :

To format it as percentage you can use the expression below:

You can replace outputs('Compose') with your excel column

concat(string(mul(outputs('Compose'),100)),'%')

Hope this works for you!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hello @Mira_Ghaly ,

I've tried the expression and I keep getting a error. Do you have any other suggestions ?

concat(string(mul(outputs('Score'),100)),'%')

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Anonymous

Do u have a compose data operation called score outputs('score') need to have your Excel column in place where u are looping on your Excel rows.

Was this reply helpful? Yes No