Help with creating formula's for a flow

(0) Share

Report

Posted on by CuriousCat99

Hi Everyone,

I am setting up an automatic flow that will provide me with an update on Friday evening, for the progress made over the week (Mon - Fri)

Not sure if some of these are actually even possible, but would love some help in creating the formulas if they are possible.

The flow is to create a HTML report that will be sent via email to me. I think I'm right with that part, just stuck on how to get the actual info I want.

Total of reminders modified (field is called MonthListModifiedBy) - would just like a total number of all the reminders that were modified between the Mon and Fri of the current week

Total of reminders modified by different people (field is called MonthModifiedBy) - e.g. person 1 did 10 reminders, person 2 did reminders 15, etc etc

Total number of reminders that are due from the time the report is run or anytime before (field is called field_1 for the date the follow up is due)

Total number of reminders that are due the following week (field is called field_1 for the date the follow up is due)

The number of reminders that have a date in the 1st reminder column (field_10)

The number of reminders that have a date in the 2nd reminder column (field_11)

Any help would be great.

Thank you

Categories:

General Questions

All responses (4)

Answers (0)

Suggested answer

Power Apps 1919 361 on at

Like (1)

Report

Help with creating formula's for a flow

Hi @CuriousCat99, then as suggested by @Gabriel G., you can use List items with filters for each requirement and use the shared video (Power Automate: Group By, SUM, COUNT in 6 steps! No Apply To Each | Runs super fast ) to calculate your metric and send the reports.
CuriousCat99 6 on at

Like (0)

Report

Help with creating formula's for a flow

Hi @Power Apps 1919

My source data is a SharePoint list.

Thanks :)
Suggested answer

Gabriel G. 732 Super User 2025 Season 2 on at

Like (0)

Report

Help with creating formula's for a flow

Hi there,

All of this is possible :)

You select the proper connector to get records you need for your report and then you use the output of these actions to get all of your values needed. Let me try to make an example with Dataverse connector: (it is in french but I think you can easily find your path through english :D)

You need a 'List rows' or 'Find record by id' or anything that fit the most your needs

Make sure to filter your query to get appropriate records (filter use odata in this connector, you can easily find odata doc online)

And then, you will be able to get output values in further actions as dynamics content:

I hope it helps!
_________________________________________________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
Suggested answer

Power Apps 1919 361 on at

Like (0)

Report

Help with creating formula's for a flow

Hi @CuriousCat99,could you share what your data source is (e.g. SharePoint list, Dataverse table, Excel file, SQL, etc.)?

Yes this is entirely doable with a Scheduled-based flow. By scheduling it to run every Friday evening, you can pull your records, you can use Filter array or odata queries to filter data, then stitch them into an HTML report with create html table action and email it back to u.
reference video to help you build the aggregation functions:
Power Automate: Group By, SUM, COUNT in 6 steps! No Apply To Each | Runs super fast

Please give the mentioned solution a try and let me know whether it works for you.
If it solves your issue, feel free to mark this thread as answered.
Please make sure to like the response!
Thanks!
- Hemanth Sai