Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Creating automated pay period selection


I'm hoping someone could point me in the right direction....

I'm building a timesheet and right now the pay period is setup to manually enter it...using start dates and end dates, and user just selects the pay period from a dropdown list.  What I would like to achieve is to have the pay period automatic (no initial setup).  

I'm not clear on how to start as we have semi monthly pay, Starting on 1st of Month and the 16th to the end of the month.

I do have a variable created in a calendar that gets the first of the month called varFirstDayofMonth ( = 1).  

I'm assuming a forall and sequence but not clear how to put it together with the two starting pay period dates each month.  Any ideas or direction would be great.  Thanks for your help.

Community Champion
Community Champion

Thank You @TB05 

Helpful resources

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,680)