I am working on a flow which gets items from a sharepoint list, based on certain conditions but most importantly when the due date (date-arrivee) is 7 days from now. This is because basically I want to send an email reminder for the item in the list 7 days before its date (its basically the day when new employee starts) => SO i want to be sent a reminder 7 days before the employee arrives
However when I try to run it it seems I am having problems with the date field. Here is what I wrote in my query:
The error:
The date column, its set to date and time but in settings time is set to not included
All column names have been checked and are correct.
You will need to use the internal column name of for all columns entered into the Filter Query field. Keep in mind that the internal column name may not always match the name displayed in your Sharepoint list.
If you aren't sure how to get the Internal Column name, you can refer to this section of one of my YT Tutorials.
Not sure how to write a filter query? Check out this YT short.
Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.
First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.
IN THIS VIDEO:
✓ How to send multiple list items in a single email with a Power Automate Flow
✓ How to create a dynamic date range
✓ How to use the Convert Time Zone action
✓ How to use a Filter Query in the Get Items action
✓ How to count number of items in an array
✓ How to use the Select action to extract a users display name and email address
✓ How to create a unique list of email addresses
✓ How to use the Create HTML Table action
✓ How to customize the HTML Table with CSS styles
✓ How to use the Send an email (V2) action
✓ How to use the Append to String Variable action
✓ How to create a custom list of items for an email
✓ How to use the Send an email (V2) action
✓ How to display singular or plural text based on the number of items returned
Hope this helps! Consider giving me a ❤️ if you liked my response!
👉 Level up your Power Automate skills by checking out my tutorials on YouTube 👉 Tips and Tricks on TikTokand Instagram
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
14
Share
Report
All responses (
Answers (
