Hi all
Im doing scheduled flow to notify a user of the items that are due within the next 30 days based on the column called Due date FSSC 22000
The formula in order to send the notification is:
In other words, if the due date - today() is less or equal to 30 days, then notify. If the due date is blank or due date - today() is over 30 days then do not notify.
The email (and expected result) I would like to have sent is:
So far my flow looks like this:
I attach the raw data.
https://1drv.ms/x/s!ApgeWwGTKtFdhkLV0H1zEptJNdxO?e=PUhePd
Can you please advise how to build the flow?
Thanks all.
Solved! Go to Solution.
Hi @diegoandre10 ,
Try to create HTML table and send by email:
Best Regards,
I am getting closer to the solution. I received an email with the matrix of companies, however not all the ones that met the criteria were shown. Only 21 out of the 36 that met the criteria appeared on my email.
Here are the steps, let me know if there is something wrong:
I attach the dataset of total companies with the due date included. From 208 rows a total of 36 should meet the condition we defined.
https://1drv.ms/x/s!ApgeWwGTKtFdhkPdPd2wNt9-ORc_?e=TXBnPm
Thanks a lot!
Hello @diegoandre10
Try using the addDays() expression to todays date which can be used as utcNow() and than in your get items SharePoint , filter on the output of the addDays()
Example:
addDays(utcNow(),30,'dd/MM/yyyy')
โJosh
If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
Proud to be a Flownaut!
Hi @Jcook
Where should I include the column Due Date that will be the reference to subtract the 30 days?
And the email with the companies that meet the criteria?
Thanks.
Hi @diegoandre10 ,
Please try this configuration:
Hope this helps.
Best Regards,
Looks ok the condition of null and utc now.
But for the for the company it should not be a "static value or equal to something" within the condition
The output should be:
Give me all the company's that meet the condition of being due within the next 30 days. So this will vary on a day by day.
So I was thinking of some sort of matrix that says on the output email:
"The following companys are overdue already or due within the next 30 days"
Company | Due date FSSC 22000 |
222 | 4/1/2020 |
444 | 4/1/2020 |
555 | 2/1/2020 |
666 | 3/1/2020 |
3108 | 1/1/2020 |
3663 | 4/1/2020 |
3885 | 8/1/2018 |
6216 | 3/1/2020 |
6327 | 3/1/2020 |
6438 | 1/1/2020 |
6771 | 12/18/2019 |
6882 | 1/1/2020 |
Can you please help me? Please have a look on the dataset that contains the sample I shared on my post.
Thanks.
Hi @diegoandre10 ,
Try to create HTML table and send by email:
Best Regards,
I am getting closer to the solution. I received an email with the matrix of companies, however not all the ones that met the criteria were shown. Only 21 out of the 36 that met the criteria appeared on my email.
Here are the steps, let me know if there is something wrong:
I attach the dataset of total companies with the due date included. From 208 rows a total of 36 should meet the condition we defined.
https://1drv.ms/x/s!ApgeWwGTKtFdhkPdPd2wNt9-ORc_?e=TXBnPm
Thanks a lot!
I think i found part of the problem, when i run and test the flow:
I see only 100 items:
Could this be part of the problem?
I have 208 records.
Thanks.
For the record
I changed the threshold to 1000 and it worked!
Great catch! Everyone should remember that, by default, the SharePoint Get Items action returns only 100 rows. You can set it up to a maximum of 5000 (in most cases). If you have more than 5000 items in your list, use OData filter queries to filter the data before you get it.
Join digitally, March 2โ4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
89 | |
56 | |
39 | |
37 | |
35 |
User | Count |
---|---|
79 | |
66 | |
57 | |
51 | |
42 |