1

Hi All,

I have what would appear to be simple request but not simple for me as I don’t do code and have only just started using Lists/Form/Power Automate etc.

I’ve basically converted one of my excel documents that stores software renewal dates into a SharePoint list. The reason for this is I wanted to create a flow that interrogated the data in the list to trigger an email alert 30 days before any item on the list was due to expire.

I have seen other people trying to do the same thing and have followed their content but some of the procedures don’t appear to work for me and some of them are quite old so im sure things will have changed possibly with some syntax/commands etc.

I have attached a sample with demo date in to show the list i have created.

As mentioned the end result would be an email being fired to a particular address with the content of which item in the list is due to expire with the expiry date/product/previous cost etc. all in the email notification.

Any help would be greatly appreciated here.

TEST.xlsx (13.2 KB)

3 Spice ups
2

So you will want to use a Manually trigger a flow, then you next step is to select List rows present in a table and select your file, then Control with the output as value, the Condition, choose your row value is less than 30 under if yes, choose send me an email notification under notification and make sure to use flow checker. I hope this helps.

3

Forgive me for sounding dumb but i thought this would need to be scheduled rather than manual trigger as i want this to check periodically and alert me rather than me manually running it.

4

Yes you are correct, first start with a manually trigger to see if you can get it to work.

5

Thank you but i think it was more of an example or sometime attempting this if anyone has time or providing greater detail, as mentioned i have already followed a few tutorials but they have been unsuccessful

6

Damjo

The manual trigger is for use during development and testing, once the rest of the flow is working then we move to the automatic trigger event.

Can you provide any details on what you have in place? Show us the picture of your logic flow?

Were you able to connect to your SharePoint List and retrieve the data?

ReadSPList.png
ReadSPList.png626×588 17.9 KB

In my example here I am connecting to a SharePoint List that contains names of users that are excluded from a certain task. I am also initializing an array variable that I will use later. Notice I am manually triggering because I am still developing the solution.

Are you able to get this far?

@damjo

7

Hi, basically, I copied this exactly as it appeared to be doing exactly what I was looking for

However when inputting this expression it just said not valid so could not go any further

equals(item()?['Expiration_x0020_Date

I’m sure it’s something I’m doing and this tutorial maynot be exactly right which is why I supplied my test data to see if someone could help.

Appreciate your response this far guys

8

Did you paste your entire field content?

equals(item()?['Expiration_x0020_Date

Or should the expression have closing symbols also?

equals(item()?['Expiration_x0020_Date'])

I just checked the tutorial and it calls for an even bigger expression

@equals(item()?['Expiration_x0020_Date'], addDays(utcNow(), 7, 'yyyy-MM-dd'))

I am working to get a firewall upgrade staged for this weekend so don’t have a lot of bandwidth. If I had a little more time I would build this out myself, both to help you out and to reinforce my own skills. Happy to provide suggestions though.

@damjo

9

Hi, yes sorry I think my copy and paste didn’t work fully, yes I copied the entire thing but I’d just stated that it was not valid.

The process and objective here appeared to be identical to mine to I copied it like for like hoping it would work :frowning:

10

Are you using the suggested Calculated column for ‘Days Remaining’?

11

What is the verbiage on the failure? Can you paste it for us?

@damjo

12

I will send over the details in the morning of what I did and double check things also.