cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VivekQibs
Level: Powered On

sending mail with list of items in sharepoint

Hi ,

 

I want to send email daily with sharepoint list of items column data value = "Due" . Can anyone help me create this flow?

 

Thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: sending mail with list of items in sharepoint

Try putting the space back in and insert _x0020_ as I mentioned above.

 

I believe Flow is looking at the SharePoint internal name - the internal name does not change even if you rename the column.

 

If this does not work, please post a screen shot of your Flow.

 

Scott

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

Scott
11 REPLIES 11
Super User
Super User

Re: sending mail with list of items in sharepoint

Here is a solution that should work for you.

I created a custom list and added a text column called "DueColumn".

When I retrieve the data from the list, I filter it so that I get only rows where DueColumn = Due.

I create an HTML table from the result of the Get Items action.

Finally, I send an email and reference the HTML table that I created.

Please note that the email has "Is HTML" set to yes.

 

For test purposes, I set my Flow to run every minute - you can set to run daily and even set the time to run.

 

DueColumn1.jpgDueColumn2.jpg

 

If this solves your issue, please mark you question as "Solved"

 

Scott

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

Scott
VivekQibs
Level: Powered On

Re: sending mail with list of items in sharepoint

Hi

 

thanks for the help.But my flow failed on "Get Items".My DueColumn in sharepoint list is selection of 3 choices "due" "na" & "booked". I write this Ticket Booking_StatusColumn eq 'Due' in filter query.Its showing an error.Please help

Super User
Super User

Re: sending mail with list of items in sharepoint

What type of column is your DueColumn?  A Choice column or a lookup?

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

Scott
VivekQibs
Level: Powered On

Re: sending mail with list of items in sharepoint

its choice

Super User
Super User

Re: sending mail with list of items in sharepoint

I updated my Flow to use a choice column called DueChoice.  Please note that I refer to "DueChoice Value" when referencing the column in the Create HTML table action.

 

DueColumn3.jpg

 

If you are still having issues, please post a screen shot of your Flow.

 

If this works for you, please mark your question as Solved.

 

Scott

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

Scott
VivekQibs
Level: Powered On

Re: sending mail with list of items in sharepoint

hi

 

is it ok if the column name is like "Ticket Booking_status ". I use Ticket Booking_statusChoice eq 'due'.

 

Please advise or do i need to change the column name.

Super User
Super User

Re: sending mail with list of items in sharepoint

If you have a space in the column name, you need to put _x0020_  in place of the space.

 

So, for a column name of Due Choice you would use this filter:

Due_x0020_Choice eq 'Due'

 

Scott

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

Scott
VivekQibs
Level: Powered On

Re: sending mail with list of items in sharepoint

dear I removed the space TicketBooking_Status eq 'due'.Still its showing error

VivekQibs
Level: Powered On

Re: sending mail with list of items in sharepoint

dear I removed the space TicketBooking_Status eq 'due'.Still its showing error

Super User
Super User

Re: sending mail with list of items in sharepoint

Try putting the space back in and insert _x0020_ as I mentioned above.

 

I believe Flow is looking at the SharePoint internal name - the internal name does not change even if you rename the column.

 

If this does not work, please post a screen shot of your Flow.

 

Scott

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

Scott
Highlighted
VivekQibs
Level: Powered On

Re: sending mail with list of items in sharepoint

Boss. its working perfectly well. The space was the only problem.Thank you soo much 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 49 members 4,252 guests
Please welcome our newest community members: