Email Needed SharePoint List Items with Power Automate
Question details
The user wants to email all SharePoint grocery list items marked Needed to one or more recipients.

- Product
- SharePoint and Power Automate
- Device & OS
- not provided
- Scenario
- A grocery list has a choice column that identifies items to include in an email.
- Observed behavior
- The desired email contains the list items whose choice value is Needed.
Confirm that the SharePoint list has a single-choice column with the exact value Needed, and identify the column's internal name in the list settings. Make sure your Power Automate connections can read the list and send email.
Filter SharePoint items and email them with Power Automate
Use a cloud flow to collect matching items and send them in a single email without a temporary list.
In Power Automate, select Create and choose Instant cloud flow for a manual run or Scheduled cloud flow for recurring emails.
Add the SharePoint Get items action and select your Site Address and List Name. Under advanced parameters, enter a Filter Query such as NeedOrNot eq 'Needed', replacing NeedOrNot with your choice column's internal name.
Add the Data Operations Create HTML table action. Set From to the Get items value output, then choose Custom columns and add the item fields you want recipients to see.
Add Outlook Send an email (V2). Enter one or more recipients in To, add a subject, and insert the Create HTML table output into the email body.
Select Save, then Test the flow. Check the run history and received email to confirm that only Needed items appear.

Manage a Grocery List in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for an easy transition. You can filter a spreadsheet grocery list manually, although WPS does not replace the SharePoint Power Automate flow.

Frequently Asked Questions
Do I need a temporary SharePoint list?
No. The Get items output can go directly into Create HTML table and then into the email body.
How do I send the list to several people?
In Send an email (V2), enter the recipients in the To field, separated by semicolons.
How can I avoid sending an email when no items are Needed?
Add a Condition after Get items to check whether the length of its value output is greater than zero. Put Create HTML table and Send an email (V2) in the true branch.
Why does the filter query fail?
Check the choice column's internal name in SharePoint list settings and confirm that the choice text is exactly Needed. The example query assumes a single-choice column.




