Excel Read Cell Value and Send in Email

[Anonymous]

I had an excel spreadsheet that get's uploaded to OneDrive every night. I need to extract a value from the table and send that value in an email. How can I get the cell value Total and send that in an email? Here is my excel file and flow. Excel FileFlow

[manuelstgomes]

Hi @Anonymous 

The issue is in the "Get a row". You need to define the "Key Column" as the column that identifies the row and now the number of the row. When Power Automate tries to fetch a value it will search Excel's Table for a column called "Key Column" and then try to find the ID defined in "Key Value".

You need to create a new column that is the actual ID for each column and replace the "Key Column" with that created column.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[RobElliott]

@Anonymous you're almost there, in the key column type Total. In the Key Value select the Total column from the dynamic content, don't type a value in.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[Anonymous]

So I tried to specify Total as my "Key Column".

I don't follow the rest of your explanation, is there a clear example you can provide? 

[manuelstgomes]

@Anonymous 

Total is not your key column. Is the value you want to collect. You need a key column in that table. In your Excel add a new column after Column 5 and call it "ID". Then put the number 2 there and in your Power Automate in the Key Column replace the total with the ID.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[RobElliott]

@Anonymous, @manuelstgomes is right, my mistake. As far as I recall the key column needs to have unique values.

Rob
Los Gallardos

[manuelstgomes · Accepted solution]

Hi @Anonymous 

Here's an example:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
​
Cheers
Manuel

[v-alzhan-msft]

Hi @Anonymous ,

Please take a try with @manuelstgomes 's solution to add a ID column to the excel table and insert value 2 to the row with the Total value that you need.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dworthy75]

Very helpful, but can it be applied to dynamic files?

I'd like to use this on a Sharepoint site where users upload files regularly. I've tried but because it's dynamic filename the Compose *Inputs field doesn't show any excel options.

[SaiJyothi]

Hi 

For this i need fetch that file as attachement .

Will you suggest me the process

[Marcel_M]

Hello, 

it works partially for me 🙂 For each response in my form you need to choose from "Brankár" or "Hráč". I don't touch Form1 sheet but I created another sheet "brankar" where i through "countif function" count total for each postion "Brankár" and for "Hráč" in total.

I thought when i use your solution + countif it might work like:

1. response form to form1 sheet

2. countif function to update a total for position

3. your flow checks "countifed" cell so PA can work with update value ..

4. another action based on "countifed" value such as "send an email with .... once the cell is higher then 20"

any idea or suggestion pls?