Unanswered

How to create custom html table based on excel?

(0) Share

Report

Posted on by bairi931549

Hello Community,

I am new to Power Automate, I have a use case that I need to send a customized email to each department owner with the list of invoices they responsible for, in the form of a table. The data source is an excel document which has all invoice details and owners. Each owner has multiple invoices.

When I use create html table from data operations, a table is getting created with all rows instead of only the items that the owner responsible for. Is it possible to add some condition or a filter so that a custom html table is created for each owner?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @bairi931549 ,

You can filter data before Create Html Table action, using operation ->Filter Array action like this:

But let's go from the begining:

1. After reading the Excel file, use a select action to get the owners column and after that use:

union(body('Select'),body('Select')) (where body('Select') is the result of select action)

Having the owners list, you can use an Apply to each action to iterate through this items:

You have to adapt formula to your needs.

Please note that this approach may not work accuratelly with a large data hosted in your Excel file. For this you have to query the excel file inside Apply to each with a Excel - List rows present in a table setting the query to

owner eq 'items('Apply_to_each')['Owner']' (where items('Apply_to_each')['Owner'] is written in expression).

Hope it helps !

Was this reply helpful? Yes No
bairi931549 7 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much sir. I am almost there but can I loop through this in by Owner. My Owner should be dynamic from the excel. I could not find much excel filters. I have many PO Owners who should receive the notifications with the POs they own so I do not want to add too many FilterArray or change the flow every time and it is difficult when the owners change.

Was this reply helpful? Yes No