Unanswered

Weekly Email to be Auto Sent

(0) Share

Report

Posted on by Community Power Pla...

I am trying to build a flow that sends an email every monday morning based on a sharepoint list that has certain values in a certain column. I have built out a power app that has become our new IT helpdesk and want to send the team a weekly email of submitted tickets that are still "unassigned".

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

NWEASD 174 on at

Like (0)

Report

You should be able to do this with a filter where the assigned column name is eq to "unassigned"

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

What would the flow look like? What triggers and actions are required?

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

When you go to create your flow, you will want to make a scheduled cloud flow. You then can schedule your flow to run on a specific date and time and repeat every number of weeks on specific days.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

A basic flow could look something like this, using the filter query in Get Items as mentioned by @NWEASD

Ellis

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Is there a reference to filter and HTML tables? I have not set either up in Flows yet.

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

Would you be able to tell us the column name of the one that contains "unassigned"

Was this reply helpful? Yes No
NWEASD 174 on at

Like (1)

Report

Without knowing the field names you can do something like this.
'Tech' would be replaced with your column name which can be found by the list settings, click on the column, and it is in the address bar. If you have spaces that becomes an issue as the space is translated to x0020
Value is the list of items from the get item field that is filtered, then you can grab the information you want out of the sharepoint list that you want to email.
The output is the value from the select output above.
Create the body of the message and then select the output of the create HTML table

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Here are all of my column names. I have three options for ticket status: Open, In Progress, and Closed. I am looking to have this email be sent every Monday morning with all of the current Open and In Progress tickets.

Was this reply helpful? Yes No
NWEASD 174 on at

Like (0)

Report

You will do the same steps as before with your filter being (Ticket_x0200_Status ne 'Closed'). You can confirm the Ticket Status column by clicking on the title of the column and confirming the URL.

Was this reply helpful? Yes No