Forum Discussion
Calculate Hours Worked for Volunteering
Chris_Clark1968 there is nothing in Forms that will stop them requesting further hours. You can email them back as part of the flow to say it's not been accepted. But I don't really think that's a very slick way of doing it. If they are all in your organisation I would consider doing it with Power Automate where you would be able to prevent them requesting more hours if their current total for the period has reached 7.5. They would see their hours on screen and the submit button would only be enabled if their hours were less than 7.5.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott
Thanks for your reply.
Just to confirm do you mean Power Automate or PowerApp?
I'm trying to keep it simple and was hoping that I could do the calculation in SharePoint?
A common denominator would be the requesters email so was hoping to use this in a formula some how so when it reaches the 7.5 mark it would send an email to requestor and manager, but then somehow reset to 0 after the allotted period.
Or would the Powerapp route be the only viable way??