Answered

Automated Expiration Notifications Using Microsoft Flow

(0) Share

Report

Posted on by 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-microsoft-flow/

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

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

Verified answer

v-bacao-msft on at

Like (1)

Report
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,

Was this reply helpful? Yes No
C_Mehta 14 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

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,

Was this reply helpful? Yes No
C_Mehta 14 on at

Like (0)

Report

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

Was this reply helpful? Yes No
C_Mehta 14 on at

Like (0)

Report

@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!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

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-email-body/m-p/203544#M21369

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,

Was this reply helpful? Yes No
C_Mehta 14 on at

Like (0)

Report

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.

Was this reply helpful? Yes No