Unanswered

How to remove decimal points in html table email

(0) Share

Report

Posted on by georginahaylett

I have a flow where I send an email monthly to managers reminding them of overdue appraisals. It works perfectly until I ask it to add a calculated column which is the number of days the appraisal is overdue by. It then gives me values with 13 characters and a decimal point which I need to remove. I have tried to follow different solutions however all of them are telling me to use an 'apply to each' function which I do not want to do as I do not want to apply to each value, the email will send multiple times if I do this. I would like to know if there is any way I can use 'select' to get the array of days overdue, then take the days and remove the decimal points to put them in the corresponding row in my email table. See below flow:

as you can see in flow 3 i can get the values however i cannot work out ho email 1.PNG o to remove the decimal points without applying to each or only retreiving the first value, as seen in 'email 1'

flow1 flow1 flow2 flow2 flow3 flow3 flow4 flow4

any help would be greatly appreciated... i'm banging my head against a wall!

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @georginahaylett

The idea is correct -

What if you pass the actual value number to the Compose action and then add another Compose action and put in your Formula?

int(outputs('Compose_2'))

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
georginahaylett 23 on at

Like (0)

Report
Copy link

Link copied!

Hi @CFernandes

Thank you for this, however I have multiple values which will need to go into each corresponding row in the table when the email is sent out, how will this work with each number value?

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @georginahaylett

I think the reason your flow is failing because you need an array index [0] ....[1]

What we can try is to Intialize a variable to 0 - Increment the Variable inside the Do While and set the value to the to the array[]

Now I do not have your actual setup but this is my theory.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
georginahaylett 23 on at

Like (0)

Report
Copy link

Link copied!

Hey @CFernandes

Just a little confused on the compose action, what would i put in place of your 'xyz'? do i need to add just the name of the filter array, or do i need the column too? And how would i order this?

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
Copy link

Link copied!

Hey @georginahaylett

Were you ever able to figure this out? I seem to be having the same problem with my HTML output from a Flow email.

Was this reply helpful? Yes No
georginahaylett 23 on at

Like (0)

Report
Copy link

Link copied!

Hey! No, never got to the bottom of this unfortunately. I removed the column in the end! It was driving me mad! I know I'll need it in the future so I'll definitely have to revisit at some point - not looking forward to that haha!

Was this reply helpful? Yes No
RADical 164 on at

Like (0)

Report
Copy link

Link copied!

Hey @georginahaylett,

Ok...So after beating my head against the wall a bit more, I think I finally figured it out. My flow is a bit different because I used a Select action to remap data fields.
I used this Expression in the value field:
substring(item()?['colname'],0,indexOf(item()?['colname'],'.'))

Let me know if that works for you as well.

Was this reply helpful? Yes No
elkhawase2 45 on at

Like (0)

Report
Copy link

Link copied!

It didn't work for me in convert to HTML step as it gave an error
Unable to process template language expressions in action 'Convert_to_HTML' inputs at line '0' and column '0': 'The template language function 'indexOf' expects two parameters: the string as the first parameter, the value to find the index of as the second parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#indexof for usage details.'.

Was this reply helpful? Yes No