Hello, I have the following Flow. (The apply to each should loop through around 200 items) It works well, except for the output of the

Hi @Vstar19 , In your Create HTML table, reference @item()?['Name'] Also, I dont think you need the loop. You can move the F

Power Automate - General Discussion

Answered

Create HTML Table (Custom)

Like (0) Share

Report

Posted on 5 Oct 2021 12:41:39 by Vstar19

376

Hello,

I have the following Flow. (The apply to each should loop through around 200 items)

apply to each.PNG

It works well, except for the output of the CreateHTML

I want to put the output of the CreateHTML into a email, however, there are extra columns appearing . I only want the Name and email

On the CreateHTML i clicked Advanced Option, and selected Columns to Custom and entered

Header | Value

Name | body('Filter_array_2')?[0]?[Name]

email | body('Filter_array_2')?[0]?[emailAddress]

But it keep coming back and saying cant find Name. Any ideas?

I have the same question (0)

All responses (7)

Answers (1)

Vstar19 376 on 06 Oct 2021 at 11:34:51

Like (0)

Report

Re: Create HTML Table (Custom)

Hi.
So i have the Create HTML Table action, and it is a custom action i am using
as below
Then i am formatting the HTML in the compose directly below :
replace(body('Create_HTML_table'),'<table>','<table border="1">')

Then i am placing the formatted HTML into Send an Email V2. And yes, i am using Outlook to read the email

Was this reply helpful? Yes No
eric-cheng 5,171 on 06 Oct 2021 at 11:29:38

Like (0)

Report

Re: Create HTML Table (Custom)

Hi @Vstar19 ,

How are you composing and sending the email?

I literally copied the expression and dumped it straight into the email body and was able to click the link. Are you using Outlook to read the email?

Granted, I haven't tested this concatenated link inside a HTML table.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Vstar19 376 on 06 Oct 2021 at 11:08:33

Like (0)

Report

Re: Create HTML Table (Custom)

Hi ,

This is the exact expressions I am using

concat('<a href="https://mywebsite.com/id/',item()?['id'],'">Link</a>')

However, on the email, the word 'Link' is not clickable, this is how its displayed on the email (inside of a table)

<a href="https://mywebsite.com/id/70G90616-36F5-2YSF-88J1-20345A02DR00">Link</a>

Where the https://mywebsite.com/id/70G90616-36F5-2YSF-88J1-20345A02DR00
is clickable, but the word Link is not.

Was this reply helpful? Yes No
eric-cheng 5,171 on 06 Oct 2021 at 10:47:33

Like (0)

Report

Re: Create HTML Table (Custom)

Hi @Vstar19 ,

You are missing a few syntax characters

@concat('<a href="https://mywebsite.com/id/',item()?['ID'],'">Link</a>')

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
Vstar19 376 on 06 Oct 2021 at 10:39:03

Like (0)

Report

Re: Create HTML Table (Custom)

What am i doing wrong here : I have built the following expressiong

concat('a href="https://mywebsite.com/id/',item()['id'],'">Link</a>')

On the email, it appears as this. (Even though the link does work) - it shows the a href tags and the actual word "Link" is not clickable.

a href="https://mywebsite.com/id/70G90616-36F5-2YSF-88J1-20345A02DR00">Link</a>

How can i have it appear where it just says "Link" and when the user clicks the Link, they are taken to the URL

Was this reply helpful? Yes No
Vstar19 376 on 06 Oct 2021 at 09:23:32

Like (0)

Report

Re: Create HTML Table (Custom)

Thank you. That worked.

Another question, Is it possible to have a hyperlink on each item

For example, my solution loops for 200+ items (hence the apply to each).
Each item, the output of the HTML Editor will display a ID (the one i said i didnt need, but now i think i do)

Can i hyperlink each id to go a a url. Each URL Format will be https://domain.com/<ID>

So for all the 200 items items, there will be a hyperlink on the ID (or the Name), where the user click and they are taken to https://domain.com/>id>

Thanks

Was this reply helpful? Yes No
Verified answer

eric-cheng 5,171 on 05 Oct 2021 at 13:07:41

Like (0)

Report

Re: Create HTML Table (Custom)

Hi @Vstar19 ,

In your Create HTML table, reference

@item()?['Name']

Also, I dont think you need the loop. You can move the Filter Array and Create HTML table out of the loop.

---------------------------------------------
-------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No