Power Platform Community Forum Thread Details

Hi all,

I have an excel table with a column called ‘date’ and another called ‘sales percentage’, there are other columns as well.

My flow is as follows:

Compose: first(split(datedifference(‘1899-12-30’,startofday(adddays(utcnow(),-1))),’.’))

i then have a ‘Get a row’ action which returns only the row where the date equals the compose output, which should be yesterdays date. (This all works fine)

i am then posting to a chat

sales percentage = and the sales percentage link.

this all works except that the return value of sales percentage is shown as 0.899 but in the excel table It says 57.2% (the column is formatted as a percentage)

i hope someone can help and I thank you for your time 👍

Categories:

Building flows