Answered

Create HTML Table after Apply to each to send email

(0) Share

Report

Posted on by hjoshi4u26

Hello 😊 So I am facing a blocker in one of my flows. I am fetching the data from Azure DevOps from the Query Results.

The field 'Assigned To' contains the value in the format 'NameSurname<EmailId>' for e.g., 'XyzAbc<xyzabc@domain.com>'. Before creating the HTML table and sending it in the email, I have to separate both the Full name and EmailId, which I have done using Apply to each step.

I get Full Name in Compose_2 and emailId in Compose_4. Now I need to create a HTML Table which will have the Work Item ID, Full Name and EmailId columns. For that I need to first map the columns and outputs in Select. But I do not know what to use as an input in Select..? I have faced this scenario 1st time. Any help will be much appreciated 👍

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @hjoshi4u26

select expects input as array
in your case, initialize a variable at start of flow which is of array datatype, in the apply to each, append the json object as element to the that array variable, and then use that array variable as input to select item.

But i would suggest this way to make flow faster.

here in select action
here item() represent each element from value array object from which we are extracting a particular value using key , here i am not sure about the column name of WorkItem ID, so make changes acordingly to that.

this is for extracting name using same expresssion u have used.
split(item()?['System.AssignedTo'],'<')?[0]

same expression to capture email which you have shared
replace(split(item()?['System.AssignedTo'],'<')?[1],'>','')

at last in send email, in body i have specified this html tableby adding border to it using expression

expression:
replace(body('Create_HTML_table'),'<table>','<table border="1">')

Hope it helps
Mark it as solution if it resolves your query !

Was this reply helpful? Yes No
hjoshi4u26 on at

Like (0)

Report
Copy link

Link copied!

Thank you for solution 🙂

Was this reply helpful? Yes No