Unanswered

Calculate total time during time period

(0) Share

Report

Posted on by AA-26122208-0

I'm trying to create a flow for calculating total volunteer hours during a time period. There is a start date, end date, number of hours per event, and recurrence of event (daily, weekly, semi-weekly, monthly, etc.). I like know what it needs to do but I don't know exactly how to do this... So if someone said they volunteer 1 hour weekly starting January 1 ending February 25th, it should run 1 (hour) x 4 (number of weeks) and put the 4 in the total box. Does this make sense? Can this be done?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (0)

Report

What format is the data in? Where is it stored? What do you need Power Automate for?

Was this reply helpful? Yes No
AA-26122208-0 2 on at

Like (0)

Report

It's in a sharepoint list. I originally wanted to do a calculated column but from what I looked into it sounded like what I'm looking for couldn't be done, that's why I'm using power automate. I basically just want the workflow to take the info submitted into the sharepoint list for a recurring volunteer activity, do the math for the recurrence, and update the total volunteer time in another empty column, this way when the data is exported there is already a calculated total volunteer time.

Was this reply helpful? Yes No