Sending mail on Adding new item in SharePoint

[KiranKolusu1]

Hi guys,

I have a list in my SharePoint, where I have 2 columns called Country, Industry. Now I have 5 different values for country and 5 values for Industry. Now in total I have 5*5 i.e, 25 combinations, now everytime I add a row in my list I want to send a mail where the body, subject, To are same but CC should vary according to the combination of country, industry. Is there a way to initialize a variable and set CC values for each condition and at last send  a mail. If yes please let me know how.

Thanks in advance.

@efialttes  @CFernandes 

[tom_riha · Accepted solution]

I'd create a configuration list for that, a separate list that would contain 3 columns: country, industry, CCusers. As you said, the list would contain 25 items.

Then in the flow, before sending the email, you would use 'Get Items' action on the configuration list with Query Filter 'country eq '[Country]' and industry eq '[Industry]'. That should give you just 1 item with the proper combination. You can then use the CCusers output of that action as the CC in your email.

note: [Country] and [Industry] are dynamic content from your flow