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

View solution in original post

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

View solution in original post

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

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,933)