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:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (1)

Mira Ghaly 11,409 Moderator on at

Like (0)

Report

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

@gefer_romero131

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

Was this reply helpful? Yes No
Verified answer

takolota1 4,944 Moderator on at

Like (1)

Report

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

@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.

Was this reply helpful? Yes No
gefer_romero131 6 on at

Like (0)

Report

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

Hi, it's from Excel

Was this reply helpful? Yes No