Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Automated Expiration Notifications Using Microsoft Flow

Like (0) ShareShare
ReportReport
Posted on 29 May 2019 09:10:35 by 14

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

 

  • C_Mehta Profile Picture
    14 on 05 Jun 2019 at 10:27:54
    Re: Automated Expiration Notifications Using Microsoft Flow

    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.

  • Verified answer
    v-bacao-msft Profile Picture
    on 05 Jun 2019 at 08:49:24
    Re: Automated Expiration Notifications Using Microsoft Flow

    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:

    33.PNG

     

    Best Regards,

  • C_Mehta Profile Picture
    14 on 05 Jun 2019 at 07:47:28
    Re: Automated Expiration Notifications Using Microsoft Flow

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

     

     

     

    Capture.JPG

     

     

  • C_Mehta Profile Picture
    14 on 29 May 2019 at 10:50:20
    Re: Automated Expiration Notifications Using Microsoft Flow

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

  • v-bacao-msft Profile Picture
    on 29 May 2019 at 10:31:38
    Re: Automated Expiration Notifications Using Microsoft Flow

    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:
    16.PNG
    Please take a try.

     

    Best Regards,

  • C_Mehta Profile Picture
    14 on 29 May 2019 at 10:21:07
    Re: Automated Expiration Notifications Using Microsoft Flow

    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)

     

     

     

    Capture.JPG

     

     

     

  • Verified answer
    v-bacao-msft Profile Picture
    on 29 May 2019 at 10:03:25
    Re: Automated Expiration Notifications Using Microsoft Flow

    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.

    14.PNG

    Please refer to the screenshot below to configure Condition:

    15.PNG

    Expression:

    length(body('Filter_array'))

    Hope it helps.

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started