Automated Expiration Notifications Using Microsoft Flow

[C_Mehta]

Hello

I was wandering if i could get some help with a flow i am trying to build.  This is the first time I am using flow and i am not in any way a developer!

Our requirement is to receive an alert (to multiple people or a group email address) when a certificate is 30 days from expiring.  All infirmation regarding the certicates including expiry date is contained in a SharePoint Online list.

I tried following this link which has the exact requirement and seems perfect for my needs.

https://practical365.com/sharepoint-online/automated-software-license-expiration-notifications-using...

However I am unable to repliacte the last step where I cannot create the exact same expression within the condition. The expression @greater(length(outputs('Filter_array').body), 0) is invlaid as i think both the "outputs" and "filter_array" options are no longer vaid.

Does that mean this whole method is now obselete?  Is there another way to do this?

Thanks

[v-bacao-msft · Accepted solution]

Hi @C_Mehta ,

The method mentioned in Link is valid, but recent updates have removed advanced mode in Condition.

It also shows how to configure Expression directly without relying on advance mode.

The effect of the two mode configurations in the screenshot is the same. Currently only the following method 2 can be used.

Please refer to the screenshot below to configure Condition:

Expression:

length(body('Filter_array'))

Hope it helps.

Best Regards,

[C_Mehta]

Thanks - that's helped although I think i have an issue with another part of the flow.  I have setup the filter array as follows which is slightly different to the original link (as that was not working)

Can you check the below filter?  It should be to return any items which are 30 days from expiry (based on date in expiry column)

[v-bacao-msft]

Hi @C_Mehta ,

It is recommended to use the same Expression as in the link, and set the format in the third parameter of the addDays() function.

The premise is that Expiry field only contains Date, not including Time.

Image reference:

Please take a try.

Best Regards,

[C_Mehta]

Thanks, I actually finally got it to work by editing it in advanced mode and copying the syntax there.

[C_Mehta]

@v-bacao-msftActually i wandering if you can help me further.  I have my flow working now as per the screenshot below.  However I would like to find out how i can format the email that is created using the output from the HTML table.  I have followed and tried several different methods through various sites and blog posts.  These either do not work or lead to multiuple emails being sent as they include the "apply to each" action.

Below is my flow.  any help appreciated!

[v-bacao-msft · Accepted solution]

Hi @C_Mehta ,

Do you mean format html table or add extra HTML tags in the email body?

If you want to add grid lines to the HTML table, you could refer to a similar thread below:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-format-the-table-as-Rich-text-in-send-an-e...

In addition, we can configure the corresponding html code directly in the Body to let the Body render the expected style. Note that the Is html field needs to be set to Yes.

The configuration in this template may be used as a reference:

Best Regards,

[C_Mehta]

HI @v-bacao-msft  Great!  I had found that post and tried it and it did not work.  Trying it again and i have my flow working perfectly with the correct formatting.