List Rows Present In A Table

(0) Share

Report

Posted on by Gwill1983

271

Hi all,

I am building a flow and I just cannot get this element of it to work.

My end goal is to automatically email all entries in the table when a new file is saved (so the file name is dynamic) but I cannot get this element to achieve what it needs to.

I cannot work out the expression required to specify the correct table within the sheet once it gets to this stage. The tables is called Email_List.

Is anybody able to help?

Flow so far is below:

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

Hi!
Have you inspected the output of 'Get tables'? Can you share a screenshot from it?
Also, can you share th current expression you are using? THe first() based expression, I mean
Finally, the excel file you are wirking with does have a single table, right?
Thanx!

Was this reply helpful? Yes No
Gwill1983 271 on at

Like (0)

Report

Hi,

Very new to power automate so will do my best to explain.

The outputs from the 'get tables' section is huge! Is there a specific section you want to see?

The expression that I am using is first(outputs('Get_tables')?['body/value'])?['id']
This is bringing up an error that says No table was found with the name '{45130758-0813-4D99-9AE4-3E076A831CAB}'.
clientRequestId: 303a145f-7bbe-4a3b-a215-742f4e3672a9
serviceRequestId: 476b0d54-f30d-4863-b31e-9ecd5c5092ad

The spreadsheet will have multiple tables in it (around 6)

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
@Gwill1983 wrote:

The expression that I am using is first(outputs('Get_tables')?['body/value'])?['id']

Hi!
No problema. I would try with name attribute instead

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

Hope this helps

Was this reply helpful? Yes No
Gwill1983 271 on at

Like (0)

Report

Apologies. When you say use the name attribute, do I enter the name of the table where you have added 'name' into the expression?

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Hi!
Just replace the expression you are using and use this instead

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

With the one you are currently using you obtain the 'id' of the first table from 'Get tables' outputs -no idea how Microsoft sorts them,so it's unclear to me if it is the one you expect-, and this new one provides the 'name' of the first table instead.
Hope this helps

Was this reply helpful? Yes No
Gwill1983 271 on at

Like (0)

Report

Thank you.

Apologies for so many questions.

How do I adjust this expression to show a different table? This pulls through as trying to find my table named Raw_Data (which is on my first tab in the spreadsheet). The table I need to reference is Email_Data which is on the fourth tab.

This is a nightmare!! 🙂

Was this reply helpful? Yes No
Verified answer

v-JessicaG-msft on at

Like (1)

Report
Hi @Gwill1983 ,

Do you want to output the data of the fourth tab in the table?

You could try this expression:

outputs('get_tables')?['body/value']?[3]?['name']

I have test for your reference, please refer to the screenshot below:

Best Regards,

Jessica Gu

Was this reply helpful? Yes No
dcrow 3 on at

Like (0)

Report

This worked for me.....FINALLY!
Thanks @efialttes

Was this reply helpful? Yes No