Create Pivot Table & List rows present in table

(0) Share

Report

Posted on by 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?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
iglesias6 50 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
iglesias6 50 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
iglesias6 50 on at

Like
a
(0)

Report
Copy link

Link copied!

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"?

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
iglesias6 50 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No