Create Pivot Table & List rows present in table

[iglesias6]

Hi guys! 

Im new in Power Automate and I am having an issue trying to automate some stuff. I will explain my problem:

I have an excel file that is sent by email to me every monday, that excel file contains data without anything special, here a photo just in case:

Now I want to send an email to those who have an X (The email column is one of the last columns).

How can I do that?

I saw that If I created a Pivot Table it can be easily done. The problem there is that whenever I create the pivot table with Excel, I cannot use the "List rows present in a table" because the new table is not appearing:

How can I use this to at the same time?

As Im new, any tip or trick would be useful and if this is not possible, why?

[FLMike]

Hi @iglesias6 

Welcome. I see this often but its not a Pivot Table, its a Table wrapper. Like this.

1. Click Insert

2. Click Table, not Pivot Table

3. Select your rows (and check if one is a header row).

And save and done 🙂

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[iglesias6]

This does not help me at all. I know how to do it in excel, but I need to do this in power automate. This comment does not help me at all.

[iglesias6]

Here, Im using Power Automate to create the pivot table: 

But when I try to get the rows as I showed before, it is not appearing any table name

[FLMike]

Hi @iglesias6 

it looks like 2 different files. In the list rows you do not show a Folder Name

but in the create table you have a folder name

I believe thats why.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[iglesias6]

Im sorry, I am trying stuff in order to fix this problem but I cannot.

This is my result still:

Can someone explain me how to create a table in an excel file and then use it in a "List rows present in a table"?

[FLMike · Accepted solution]

Hi @iglesias6 

You need to use the DYnamic Output property called name from the Create Table.

Like this

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[iglesias6]

Okey, I am using that now. But I need some help with creating an expression:

The expression there is the following:

first(outputs('Get_tables')?['body/value'])

This is bringing me an Array which has the following result:

I only want to get the name. How can I get it in a compose expression?

[FLMike]

Hi @iglesias6 

wait this is a totally different problem.

please mark the answer is answered. Any more questions, please take to a different question so its can be answered independently and tracked.

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey