Power Automate

Select rows, make a table and send email

(0) Share

Report

Posted on by Billy Chan.YM

Hello all,

This is the column I would like to select and send

This is the column I would like to send to, the AB column are the main contact, and the AC column are the email who I want to CC

this is the flow that I have created, it is able for me to filter the data and multiple rows are able to merge to together as a table to send to same person instead of sending multiple mails.

When I try to put column AC IT Leader as dynamic content into the CC, it will lead to another apply to each action and it will break my flows.

I am now running out of ideas of how to put the IT leader inside, can anyone be able to help me?

Thank you so much

Billy

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

TomaszPoszytek 170 Most Valuable Professional on at

Like (0)

Report

Instead of clicking the AC column from dynamic outcomes, try using the item()?['name of AC column'] instead as an expression.

I understand the loop runs over the rows obtained from Excel, so each item() object is referring to a specific row.

Regards,

Tomasz

Was this reply helpful? Yes No
Billy Chan.YM 20 on at

Like (0)

Report

@TomaszPoszytek

Thank you for your reply

I have tried this, but it comes up with an error Action 'Send_an_email_(V2)' failed: Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'The template language expression 'item()?['"IT Leader (Email)"']' cannot be evaluated because property '"IT Leader (Email)"' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'.

Let me show you my flow details:

my original flow are giving me this result and it looks perfect for me, I am just lacking of how to send to IT leader email at the CC column of send to email V2

Was this reply helpful? Yes No
TomaszPoszytek 170 Most Valuable Professional on at

Like (0)

Report

In a completed run preview what are the outcomes being returned by the "List rows present in a table" action. Then you will know, what is the internal name for the column you want to get value from.

And only then, inside of the loop, you will be able to correctly refer it via the: item()?['INTERNAL_IT_LEADER_COLUMN_NAME']

Eventually write this value out to a Compose action, to see if it is read correctly.

Was this reply helpful? Yes No