List objects in gallery based on dropdown control?

(0) Share

Report

Posted on by fiddlerx

103

I have added a gallery with the source from an excel online file called 'Table1'

In this file I have two columns: 'Office' and 'Week'

I would like to list the Offices that matches the selected week in the dropdown control. And the dropdown control should get the week from excel. Default value should be this ISOWeekNum.

Gallery 'Items'

Filter(Table1, 'Week' = "19", "19") <- static right now. Its week 19 so I would like to display the current week default...

Dropdown 'Items'

Table1.'Week' right now...

Need to get them to work together...

If I would like to count how many offices are tagged this week?

CountIf(Table1, 'Week' = ISOWeekNum(Date(Today)) does not seem to work, any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

iDLIR 50 on at

Like (0)

Report

Hi @fiddlerx ,

Sorry i didn't get properly your question, but if you want to get the current working week, then this formula will definitively help you out:
WeekNum( Now() ),WeekNum( Now() )+1)

Thanks,
iDLIR

if this helped fix your issue, kindly mark it as solved to help others too.

Was this reply helpful? Yes No
fiddlerx 103 on at

Like (0)

Report

It did not work well for me.,
I would like to count from this column called Week

CountIf(Table1, 'Week' = ISOWeekNum(Now())) but it does not work...

Was this reply helpful? Yes No