Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Restrict "pace" of user submitting the form

hi guys, 

i have a sharepoint form where user can request home office or holiday. Once he submits a flow starts which deducts the requested days of holiday from his "vacation days" and asks the manager for approval, if he approves all good, if rejects, days are set back...

the problem i see is that if he makes two quick requests after each other... the flow wont be able to deduct the vacation days and will therefore submit to manager the current days 2x... for example:

I have 20days of vacation available. I ask first for 20, and quickliy after again 20. Manager does not realize and approves. The flow will update the current vacation status with 0 (but will not restrict me for my second request....)

If i would wait 1 minute, between the requests, the powerapp form would tell me that i dont have the days available....

Any ideas whats the best solution?

Post Prodigy
Post Prodigy

@eka24 hey, tested the first version, i put  the variable on start:


i added the values to the submit button (maybe here i am not sure what you mean with flow button, i hope its same thing...)


but the result is, i think expected, i guess i do something wrong (its disabled all the time)




The OnStart formula should be false;



Then OnSelect of the Submit button:



The rest of What you have done is ok.


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Post Prodigy
Post Prodigy

@eka24 i tested the time related workaround...

i could not figure what you meant with the runflow.... on the submit button.



the only way how to run this thing was like

Set(varFlowStart,true); SubmitForm(SharePointForm1)

this however means that the timer is reseted every time I refresh the page (and it actually does not start since the submit form will move us to a different screen, so not sure 😞 )

The Run Flow is just an example. So it should rather be;




I don't understand the moving to the other screen bit. If the form has not finished submitting, it should not move to other screen. 


I don't know the formula you used in moving to other screen after submitting, but it should be Onsuccess of the form. So that it will only move to next screen after successful submission.


I hope you are ok with the first option?


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Post Prodigy
Post Prodigy

@eka24 I managed to do the first option with disabling the button after submitting, works but the problem remains. If the user refreshes the page the button is active again. The same problem will be with the timer.

I think i would require some solution that would look into the list of submited requests for holiday, so following conditions:

- its a holiday

- its from the user that is logged in

- it was submitted 1minute or less ago

In these 3 cases, it should do something.... like display a message or anything.. if i work out how to filter that i work out also the rest. So far the biggest problem 

Well you can try those options as well. But i dont see how setting a variable Onstart will be reversed just by refreshing a page. That cannot happen. it can only reset after restart of the app and not refresh. But can try the option you stated as well, you know what can best suit you situation.



What about looking at the Approval process? If a request more than once, the approval process should not go through if the criteria is not met. In this way no matter how many times the person request, although the balance might be misleading due to non approval on time, there will not be any issue.


Also you can have another column (may be a collection) that gives a provisional balance as against the Approved Balance. This way, the users is aware that some of the requested leaves have not been approved.



If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Post Prodigy
Post Prodigy

@eka24 yes i was thinking also in this direction of another column and compare it durring approval but does not seem to be good logic...  I have now created following formula


Filter('time restricted submission', Title = "a", 'Created By'.DisplayName=Office365Users.MyProfile().DisplayName).Created

- this gives me the date and time of the items whre column title = a, and the created by is user who is using it... now i need to add "last":

Last(Filter('time restricted submission', Title = "a", 'Created By'.DisplayName=Office365Users.MyProfile().DisplayName).Created)

- but this breaks the date format, any idea how to fix that?

I don't understand break the Date. Also what happens when you request more than twice a day 


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Post Prodigy
Post Prodigy

this should be used as filter where, when the user opens the page/application... the system will check when he submitted his last request (gets the date), now compares it to current date and time and if its more then 2min, it gives user the option...

Post Prodigy
Post Prodigy

i think i got it:

first check the column for "A" (holiday) where created by is matching the user operating the form

dropdown: Last(Filter('time restricted submission', Title = "a",'Created By'.DisplayName=Office365Users.MyProfile().DisplayName).ID)

the created date for the ID above:

Label: LookUp('time restricted submission',ID=Dropdown1_4.Selected.ID, Created)

compare the time of created above to now

Label: DateDiff(LookUp('time restricted submission',ID=Dropdown1_4.Selected.ID, Created),Now(),Seconds)


test object to show or hide:


Helpful resources

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (4,417)