Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Contract About To Expire Notification Using SharePoint Metadata

(0) ShareShare
ReportReport
Posted on by 42

Hello, 

 

In the SharePoint library, there is metadata labeled as "Contract Expired Date" I'm trying to get the flow to go through all the contents (ie. folders) in the library and find if a contract is about to expire in 14 days. If so, it will send an email to the "Responsible Party" (another metadata). So far, I have it structured like this, but it's not emailing me any notifications even though I know there is one. If possible, please show a step-by-step procedure. Thanks in advance!

 

IceQueen_0-1623795244591.png

 

  • IceQueen Profile Picture
    42 on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    @v-bofeng-msft 

    The one on the right is sort of cut off - I have 

    startOfDay(items('Apply_to_each')?['ContractEndDate'])
    which causes the entire flow to fail. 
     
    Note: The metadata variable is "Contract End Date/Review Date" - not sure if I was supposed to write the whole thing in the square brackets/. 
    IceQueen_0-1624391674374.png

     

  • v-bofeng-msft Profile Picture
    on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    Hi @IceQueen :

    vbofengmsft_0-1624325343962.png

    vbofengmsft_1-1624325441229.png

    Best Regards,

    Bof

     

  • IceQueen Profile Picture
    42 on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    Hello, 

    I think I figure it out now. However, my only remaining concern is that I wanted the flow to send an email when there are 14 days before the contract expiration date. (So, don't email contracts expiring in 13 days). I modified the second condition from "greater than" to "equal to." But, it seems to also want the time (hour:minutes:seconds] to be equal too now, is there a way around this? 

    IceQueen_0-1624304657977.png

     

  • v-bofeng-msft Profile Picture
    on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    Hi @IceQueen :

    I've made a test but it worked well on my side.

    vbofengmsft_0-1624242867990.pngvbofengmsft_1-1624242890790.png

    Please check if there are any eligible files in your library

    Best Regards,

    Bof

     

     

     

  • IceQueen Profile Picture
    42 on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    After running the flow. it seems to still have the same result. I added a notification action to the "If No: part of the condition to see what the flow is transversing through and it only pops up Folder names. Thus, while Folders are being avoided, it does not have any file names that should have failed. (Note: Files inside of the failed folders.) That leaves me to think that it only transverses the folders for some reason...or it's not transversing through folders it failed?

  • IceQueen Profile Picture
    42 on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    Sorry for the late reply. Will test it right now!

  • v-bofeng-msft Profile Picture
    on at
    Re: Contract About To Expire Notification Using SharePoint Metadata

    Hi @IceQueen :

    Please try this:

    v-bofeng-msft_1-1623814712373.png

    Best Regards,

    Bof

     

     

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,596 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,928 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow