web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Sharepoint List, Creat...

Power Automate

Unanswered

Sharepoint List, Create HTML Table then Send Email

(0) Share

Report

Report

Posted on by ByronGill

19

Good morning,

I am trying to achieve the below.

Manually Triggered,

From a SharePoint list,

- select a number of certain rows from the list, based on either the Unique ID or if the cell contains specific text,

- build HTML table of these rows, filtered to selected columns,

- send an email of this filtered table

thank you for your help.

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Hi @ByronGill ,

I've made a test for your reference:

1\I assume there is a SharePoint list

2\I assume you want to filter on column1 to get the items who's column1 contains "A"

Result

Best Regards,

Bof

Was this reply helpful? Yes No
ByronGill 19 on at

Like (0)

Report

Thank you,

I want to be able to select multiple rows in the Filter Array step, based on their Unique ID - how would I enter multiple specific values? (Example, select the rows that contain the Column ID with value of 6, 8, 10, 19, 26)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @ByronGill ,

You could edit the filter array in advanced mode.

@or( contains(item()?['Column1'], 'A'), contains(item()?['Column1'], 'B'), contains(item()?['Column1'], 'C') )

Best Regards,
Bof

Was this reply helpful? Yes No

Join the conversation