web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps PowerApps - Fortnight ...

Power Apps

Unanswered

PowerApps - Fortnight Dates

(0) Share

Report

Report

Posted on by simone-stoller

32

Hi All,

I'm attempting to build an employee hub and the first thing I'm trying to do is a timesheet that will be sent through MS teams for approval.

Is there a way to build a dropdown for fortnightly end periods rather than weekly? if I use Today() then the weeks will change on when the user logs in.

I then want to get the dates to populate across the fortnight for the employee to imput their start/end/break.

any suggestions or videos anyone can recommend?

thank you

Simone

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @simone-stoller ,

You could set the combo box's items property to:

With( {StardDate:DateAdd(Today(),1-Weekday(Today(),2) -If(Mod(WeekNum(Today()),2)=1,0,1)*7,Days)}, ForAll( Sequence(14,0,1), {Date:DateAdd(StardDate,Value,Days)} ) )

to get dates in two weeks.

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation