Send Reminder Email once a week based on SP list value: No luck

[Diablos]

Hello All, 

i am looking to send a reminder email once a week if a value in a SP list hasn't changed.

I have a list of projects and who they are assigned to(Email)  some are not assigned as an FYI. 

If the status value (Choice drop down)  is/or one of 2 values i want an email to go out. If it is not the specified values i dont want the email to go out. 

I have the recurrence set up but i canty get the conditions to work. Plus in the email the status value is always the same for some reason.

Thank you

[DamoBird365 · Accepted solution]

Hi @Diablos 

You could probably do away with your condition and filter as part of your get items.

I have filtered my Choice list, where there is a Choice column with Choices 1,2,3.

My filter will only return 2 items based ont he following list:

Here is the example get items:

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[Diablos]

Hello DamoBird365,

I have never used that option in Power automate. I think i typed it in wrong. 

I received bad request s an error.

I have a column named 'Status' 

[DamoBird365]

Hi @Diablos 

Your query looks good, the column name must match the internal name as stored on the list.  You can check the internal name by looking at the list settings, clicking on the column and looking at the URL.

Is your status column called status or something else?

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

[Diablos]

@DamoBird365 

I got an error. The get item worked but my next action after that is to send an email reminder. 

The emails sent but i still got an error. 

[DamoBird365]

Hi @Diablos 

One of your emails is empty. Go through each of the 5 apply to each loops and you will find the failed one.

Damien

[Diablos]

Ok, I understand. So the flow will still run and send the email to the list items that have an email but not send to ones that don't have an email attached.

Is that correct?

[DamoBird365 · Accepted solution]

Hi @Diablos 

If you return 5 rows and 1 has a missing email, the flow will still attempt to use the row without an email and return an error.  If you want to prevent this from happening, which would be best practice, you could either try an additional filter on the get data action (emailfield ne '' or emailfield ne null) and combine that with your other requirements OR you can use the filter array action and filter the values from the get data action, where the email is not equal to null/empty '' and use the results of the filter array in your apply to each.

For get data you would end up with something like:

(choice eq 'choice1' or choice eq 'choice7') and (emailfield ne '' or emailfield ne null)

Damien 

[Diablos]

@DamoBird365 

Thank you so much for your help. This worked out perfect. 

[Diablos]

@DamoBird365 

I cant seem to filter out the ones that are null 

I tried your example it didn't work I think I typed it in wrong. 

The below is what I have. It runs but gives me an error. for some of the blank fields.