Answered

Extract rows with certain fields of column and show them in a table for an email

(0) Share

Report

Posted on by gefer_romero131

Hi everyone, I would like to know if anyone can give me an idea how I can extract with power automate certain rows that contain the same email address and only certain columns, and then put them in a table so that It can be forwarded to that specific email. Thanks in advance!

Categories:

Building flows

All responses (3)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@gefer_romero131

What is the source you are trying to extract from sharepoint , excel?
Verified answer

takolota1 4,980 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@gefer_romero131

Reza has a good video on using tables in emails: https://youtu.be/VnWg-Eox37Q
You should be able to select only certain columns for the HTML table action.

To filter to certain rows, you can use filter queries like this: https://sharepains.com/2021/01/19/filter-query-get-items-power-automate/
If the action doesn't have a built in filter query, then you can use the Filter Array action.
gefer_romero131 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, it's from Excel