Answered

Flow to send an email based on sharepoint column vs now. (Takes a long time to run)

(0) Share

Report

Posted on by Community Power Pla...

Hi there,

I'm new to flow and have been tasked with creating a flow which emails users when the sharepoint column 'Expiry' is due to expire in the next 4 months. The flow should email each user once.

To achieve this I have created a conditional flow. But I'm having some issues filtering the sharepoint data and running the flow.

The conditions required are for the Expiry date to be in the next 120 days, and for the TEST LICENSE STATUS to be set as 'Notification Not Sent'

After the flow retrieves the relevant sharepoint records and emails the user. The flow should update the sharepoint record to 'Notification 1 Sent'. Which will prevent the user from receiving further emails.

I will then be creating another flow for escalation purposes which follows the same structure, with different staff being contacted when within one month of expiry for example.

Here are some images of the flow:
NOTE Recurrence is set at 1 year so the flow won't run automatically during testing

Any help would be greatly appreciated!

Ross

All responses (4)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Flow to send an email based on sharepoint column vs now. (Takes a long time to run)

@Anonymous

Great work! And +1 for the use of Scope!

On the OData, I've seen a few threads on how spaces in SharePoint column headers cause trouble. I wouldn't be surprised if that's the thing giving you grief. Here's a thread on the topic: OData syntax for sharepoint column with a space - Get Items action.

Keep at it! You're making great progress.

-Ed
Community Power Pla... on at

Like (1)

Report

Re: Flow to send an email based on sharepoint column vs now. (Takes a long time to run)

@edgonzales You the man haha!

I used to the filter array and it worked first try!

Here's how it looks.

Thanks a million,
Ross
Community Power Pla... on at

Like (0)

Report

Re: Flow to send an email based on sharepoint column vs now. (Takes a long time to run)

Hi @edgonzales
Thanks for getting back to me!

Originally I tried using an oData filter query. However, I was unable to get the 'And' operator working.

Might have to look at how the filter array works. But I was looking to keep this as simple as possible as I will be handing this over to a different department once development is complete.

See below for images.
Verified answer

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Re: Flow to send an email based on sharepoint column vs now. (Takes a long time to run)

@Anonymous

Hi there. There are a couple of ways to approach this, but I think one reason it's taking so long is that it is grabbing ALL of the rows, and then looking at each one to see if it meets the condition (one at a time).

You might consider either an OData filter on the Get Items step (Click on "Show advanced options" and then use the "Filter Query" bit), or add a "Filter Array" action after.

Give either of those a go and see if that changes anything.

Keep us posted.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.