web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add weekdays to galler...

Power Apps

Unanswered

Add weekdays to gallery when user select datepicker.

(0) Share

Report

Report

Posted on by Powerappsuser11

237

Hi Team,

I created Time sheet app,In that my requirement is when user select date from date picker and user onselect of button(Add days).

Based on current date,remaining days dynamically added to the gallery.

scenario like this

User select date picker on monday remaining 4 days to be added to the gallery .

If User select date picker on Thursday remaining 1 day to be added to the gallery .

Saturday and sunday not to be considered.

How can achieve thisone,please help...!

user select monday dates to be like below.

user select middle of week dates to be like below

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

elseb 774 Moderator on at

Like (0)

Report
Hi

ForAll( Sequence( DateDiff( VarStartDate, VarEndOfTheWeek +1 ) ), VarStartDate - 1 + Value )

replace varStartDate with the user selected date and
varEndOfTheWeek with last day of the week (you can calculate it automatically)

and it should populate the gallery with dates.

Seb

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @elseb

Using above code getting below error
please help..!

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like (0)

Report
try this instead:
ForAll(Sequence(6 - Weekday(DatePicker6.SelectedDate)+1), DatePicker6.SelectedDate - 1 + Value)

the nr 6 represents the end of the week in this case it's Friday, Saturday is 7 and restarts at 1 on Sunday.

Seb

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @elseb

Can you provide how can add rows to the gallery.
Above code is written onselect of add days button. but I think create collection and give that collection to gallery.
Plaese help

Was this reply helpful? Yes No
Verified answer

elseb 774 Moderator on at

Like (0)

Report

that goes into items of the gallery, if you want it in onSelect you can do clearcollect(colDays, HEREGOESTHECODE) and put items of the gallery as colDays
Seb

Was this reply helpful? Yes No

Join the conversation