Add filter from column field

[ThimiosSp]

Hi Everyone!

I have a flow on a SharePoint list with social media content articles list. Some of these articles are published (column Status = Published) others are not (column Status = Planned). All articles have a PublishedOn date field filled.

My flow sends everyday at 15:00 a reminder when an article is on the list to be Published on the next 2 days. Everything works great but I need to make this work only for items that Status field is equal to Planned.

I would appreciate your assistance.

[ThimiosSp]

Hi @Expiscornovus,

I truly appreciate your patience 🙂 Here's how the flow looks now:

After running that, i got 4(!!!) email notifications:

#1: Normal notification without any posts on it.

#2: Something failed notification

#3: Notification including only one of two posts with Status = Planned and Published On within the next two days

#4: The right email notification!!!!!

[Expiscornovus · Accepted solution]

Hi @ThimiosSp,

There is still a small error in your configuration. Like I mentioned in step 2 in my previous response, the email notification has to be outside of the apply to each loop. But make sure it's still within the If No box.

[ThimiosSp]

Works like a charm @Expiscornovus! Great guidance, thank you.

I also moved 'Couldn't send a reminder' outside all conditions thus eliminating the 'Something went wrong' notification. 

[Expiscornovus]

Hi @ThimiosSp,

Great to hear it works, happy to help you out 🙂

[ThimiosSp]

Hi @Expiscornovus,

Me again...
After removing these test posts from my list, I found out that I get a (empty) notification email and I still get a 'Something failed' notification. 

I moved the 'Send me an email notification' right after the 'Append to string variable 2' thus preventing ampty notifications.

Can't get to fix the 'Something failed' issue though. Any thoughts?

[Expiscornovus]

Hi @ThimiosSp,

Just to double check your requirement.

When do you want to send the couldn't send a reminder notification? When the previous steps have failed (because of a flow error). Or when it hasn't found any Planned items?

[ThimiosSp]

Hi @Expiscornovus

Only when something has failed.

In case of no Planned items, no notifications should be send.

[Expiscornovus · Accepted solution]

Hi @ThimiosSp,

For the has failed scenario you could use the run after setting

1. Click the ... on the Couldn't send a reminder action and click configure run after

2. Only select the has failed option.

[ThimiosSp]

That was it to the point @Expiscornovus.

Some how this was changed after copying.

Thank you.