Get a row from Excel (Business) and send an email - Key Value

[jonboylib]

I'm using this flow Get a row from Excel (Business) and send an email -  https://emea.flow.microsoft.com/en-us/galleries/public/templates/ba2d107a1c394b18a6962ff25215ecfe/se... 

I'm simply trying to retrieve the value of a cell in my table (A8) and send it to myself via email. I need to automate this on a daily basis.

The cell (A8) will contain dynamic values, i.e it won't always be '66'. See attached images of my flow. 

excel table

flow

When I use the Get A Row step the Key Value field doesn't show any dynamic content - why? I've tried adding in custom values like 1, 2 and 3 but the flow fails to run with an error about that Key Value isn't found.

How can I achieve this?

Also, the term Key Value isn't very helpful 😕 

[efialttes]

Hi!
You need to assign to 'Key value' a value already existing in your 'Column1'. FRom the screenshot you shared, possible values are 56,22,99 or 66.
You should see the 'Key column' as a column that will have unique values per row. I.e. if row#1 as value of 56 for Column#1 , no other row should have value of 56 for such column.

Think on values assigned to your 'key column' as passport numbers. The number assigned to a passport should be unique, right? I.e. two persons should not share the same passport number.
Hope this makes sense

[jonboylib]

Hi @efialttes thanks for the reply.

The value in the A8 cell changes. All cell data in the table changes daily, apart from the column headers. 

[efialttes · Accepted solution]

Hi!
Understood. So, which way should you know which row you should read? Is it always the last one, in 5th position, assuming table headers are placed always in A3..F3?
If so, you can use 'List rows present in a table' action block, skip the first 4 rows and read just one row.

Please note the result from 'List rows  present in a table' is an array. In order to access column values from the row, you can use the following WDL expression to extract the row from the array:

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

..and assuming your target column is called 'Column1', you an use the following WDL expression to get its value:

first(outputs('List_rows_present_in_a_table')?['body/value'])?['Column1']

Hope this helps

[jonboylib]

Thank you for this @efialttes 

Can I ask, where do I add the WDL expression you have provided?

I added Column1 into the Select Query input and it appears to work - is this the same thing?

[efialttes]

Hi!

Select Query will simplify the challenge, good idea!

Now I would add the second WDL expression in your target field... i believe you're sending this A8 cell content via email, right?

[jonboylib]

Yes @efialttes I am sending the A8 sell via email.

It appears to be working as expected using only the Select Query. Unless I am missing something?