Unanswered

Contract About To Expire Notification Using SharePoint Metadata

(0) Share

Report

Posted on by IceQueen

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!

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

v-bofeng-msft on at

Like (0)

Report

Hi @IceQueen :

Please try this:

Best Regards,

Bof

Was this reply helpful? Yes No
IceQueen 42 on at

Like (0)

Report

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

Was this reply helpful? Yes No
IceQueen 42 on at

Like (0)

Report

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?

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

Like (0)

Report

Hi @IceQueen :

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

Please check if there are any eligible files in your library

Best Regards,

Bof

Was this reply helpful? Yes No
IceQueen 42 on at

Like (0)

Report

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?

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

Like (0)

Report

Hi @IceQueen :

Best Regards,

Bof

Was this reply helpful? Yes No
IceQueen 42 on at

Like (0)

Report

@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/.

Was this reply helpful? Yes No