Modification of HTM table and sending by email

(0) Share

Report

Posted on by czepnik

Hi,

I'm using a solution for ending emails proposed by @v-bofeng-msft

Solved: Sending table from excel by email - Power Platform Community (microsoft.com)

But in email I have additional columns @OData.etag ItemInternalId in email.

Is there any possibility to remove these columns from email?

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (1)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey @czepnik

I assume you don't want to include a column? If yes,

You create Select Custom columns - See screenshot below:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
czepnik 21 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes

Thank you .

I added this step but now I receiving 4 emails not a 1 as it should be.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@czepnik You need to have the Send an email outside the Apply to each loop...

I would suggest Initialize a variable on the top, Set the variable insider the loop... Move the Send email action outside the loop and add the initialized variable in the email body...

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
czepnik 21 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes

I can see create table and variable , Is it possible for you to show me details of this steps?

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@czepnik - Sure...

Firstly, I have only one loop... Not sure why did I get two loop previously...

Screenshot of the entire Flow -

Initialize variable -

Create Table -

Set Variable -

Send an email outside the loop -

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
czepnik 21 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes Thank you, but unfortunately it is not working for me. I need to find a different solution

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@czepnik Can you please share the screenshot of your Power Automate?

Was this reply helpful? Yes No
czepnik 21 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes

Was this reply helpful? Yes No
Verified answer

CFernandes 8,482 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hey @czepnik Mate - Your action should be outside the For each loop...

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No