cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Send reminder using a HTML table and select

Hi all

 

I need to send a reminder to different project owners in order for them to update their sharepoint list's status projects.

 

Instead of an email per project I want a single email to be sent containing a table with all the projects they have to update.

 

The sharepoint list is the following:

 

tech all.PNG

 

And the flow is:

 

select1.PNGselect2.PNG

 

Is the filter query under get items correct? I want to call the column 'Project Owner' of sharepointlist

 

The other question is the sen email body message, will it send the table with the select fields or not?

 

Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate II
Advocate II

Re: Send reminder using a HTML table and select

Hi @diegoandre10 ,

 

Just realized I hadn't answered your 2nd question on the email action. Your Select and Create HTML table actions need not be inside a loop. You should be able to select the columns you desire by refereing to the value (output result of) Get Items action in the 'From' property of the Select Action.

 

Also, the Send Email action is soon to be deprecated (Reference link) so you'd want to use the Send an Email (V2) action and add the output of the 'Create HTML Table' action in the email body as seen below.

 

sendemflow.PNG

 

Hope this helps!

- G

 

If this answered your question, please mark the question as answered. Answered questions help users with similar asks quickly find a resolution. Thank you!

View solution in original post

10 REPLIES 10
Highlighted
Advocate II
Advocate II

Re: Send reminder using a HTML table and select

Hi @diegoandre10 ,

 

If 'ProjectOwner' is a person field and you want to filter items specifically with user email ids then your filter query within the Get Items actions should call out the 'Email' attribute. 

 

ProjectOwner/EMail eq 'useremail'  (note: 'EMail' is case sensitive)

 

Hope this helps!

- G

 

If this answered your question, please mark the question as answered. Answered questions help users with similar asks quickly find a resolution. Thank you!

Highlighted
Helper IV
Helper IV

Re: Send reminder using a HTML table and select

Hi

 

Project owner is the name of the column on the sharepoint list.

 

If i use ProjectOwner/EMail eq 'useremail'  it should work then?

 

Do you see the send email body message ok)?

 

THanks!!

Highlighted
Community Support
Community Support

Re: Send reminder using a HTML table and select

Hi @diegoandre10,

 

1. The Get items Filter query is correct. It should be ColumnName eq 'FilterValue',  and the Project Owner's Column Name should be ProjectOwner if you never renamed it.

2. The message body of send email could be an HTML table, but before you send an email with this action, you should select the Is HTML as Yes.Annotation 2019-09-20 150136.png

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

Highlighted
Helper IV
Helper IV

Re: Send reminder using a HTML table and select

Hi!

 

Thanks for your help!

 

I changed the flow but I am not getting any email.


I am doing a test on a dummy table, please notice the column Project Owner, has a space between Project and Owner

 

t1.PNG

 

The flow goes like this:

 

t2.PNG

 

t3.PNG

 

Do you what could go wrong? Also in the body message of the email should I enter something that pulls the html table?

 

Thanks a mill.

Highlighted
Advocate II
Advocate II

Re: Send reminder using a HTML table and select

Hi @diegoandre10 ,

 

Just realized I hadn't answered your 2nd question on the email action. Your Select and Create HTML table actions need not be inside a loop. You should be able to select the columns you desire by refereing to the value (output result of) Get Items action in the 'From' property of the Select Action.

 

Also, the Send Email action is soon to be deprecated (Reference link) so you'd want to use the Send an Email (V2) action and add the output of the 'Create HTML Table' action in the email body as seen below.

 

sendemflow.PNG

 

Hope this helps!

- G

 

If this answered your question, please mark the question as answered. Answered questions help users with similar asks quickly find a resolution. Thank you!

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Send reminder using a HTML table and select

Hi!

 

I created the flow as you mentioned, I didnt get any email:

 

See the flow below:

email preview.PNG

 

Thanks!

Highlighted
Community Support
Community Support

Re: Send reminder using a HTML table and select

Hi @diegoandre10,

 

Could you get any output from the Get items action?

If could, you can confirm the Send email action whether works successful, and confirm the email address is no mistake.

If couldn't, you could check the Get items filter query whether correct.

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

Highlighted
Helper IV
Helper IV

Re: Send reminder using a HTML table and select

hi @v-litu-msft 

 

Thanks for your reply, I used the solution that @gsivasai suggested.

 

Not quite sure I understand what you said hehe.

 

The flow looks like this

html1.PNG

 

 

html2.PNG

 

Appreciate your help a lot!

Highlighted
Advocate II
Advocate II

Re: Send reminder using a HTML table and select

Hi @diegoandre10 ,

 

The Send an email action need not be within an apply to each action. The 'Create HTML Table' action should have all the data you'd want to email. If the issue with the email not getting sent out persists, please ensure that get items action is returning any results at all. To do that you could view the Flow run history and expand the Get Items action to see the results generated from the get query.

Highlighted
Helper IV
Helper IV

Re: Send reminder using a HTML table and select

Hi!

 

Its wotking now! The only problem is that the email sends the complete table with everyone's projects.

 

The column name is "Project Owner"tech all.PNG

 

 

I am using under get items, filter query: ProjectOwner eq 'useremail'

 

usemail.PNG

 

Should I separate ProjectOwner as Project Owner eq 'useremail'?

 

Thanks!!

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (7,945)