Unanswered

Getting Week Columns based on selected start date and end date in Canvas app

(0) Share

Report

Posted on by Mahesh005

I have a date pickers in canvas app to select start date and end date. week1, week2, week3, week4 has to be visible in power apps gallery or other component as shown below.

for e.g if i select date range form today i.e 18-09-2023 to 31-10-2023 then the columns in gallery has to be like given below.

week1 week2 week3 week4 week5 week6
23/09 30/09 07/10 14/10 21/10 28/10

the date mentioned below is saturday of that particular week.

for e.g if i select date range form today i.e 07-10-2023 to 28-10-2023 then the columns in gallery has to be like given below.

Week1 week2 week3 week4
07/10 14/10 21/10 28/10

Please help me achieving above requirement Thanks in advance.

Thanks & Regards,

Venkatesh

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Mahesh005 ,

Please try this

AddColumns(Filter(ForAll(Sequence(DateDiff(DatePicker1.SelectedDate,DatePicker2.SelectedDate)+1),If(Weekday(DateAdd(DatePicker1.SelectedDate,Value-1))=7,DateAdd(DatePicker1.SelectedDate,Value-1),Blank())),!IsBlank(Value)),"Week","Week"&CountRows(Filter(Filter(ForAll(Sequence(DateDiff(DatePicker1.SelectedDate,DatePicker2.SelectedDate)+1),If(Weekday(DateAdd(DatePicker1.SelectedDate,Value-1))=7,DateAdd(DatePicker1.SelectedDate,Value-1),Blank())),!IsBlank(Value)) As temp,temp.Value<=Value)))

Best Regards,

Wearsky

Was this reply helpful? Yes No
Mahesh005 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,

I need the above requirement as a columns i.e. as a headers so that one can i go and add values wrt to week1,week2 etc..

week1 week2 week3 week4 week5 week6
23/09 30/09 07/10 14/10 21/10 28/10
10 20 30 40 50 60

Thanks,
Mahesh

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mahesh005 ,

That's impossible in canvas app. You cannot create dynamic columns in table.

Best Regards,

Wearsky

Was this reply helpful? Yes No