Share
Report
2Hi,
I have a Gallery that shows dates based on a filter. First I create a sequence of the next 14 dates/days. This sequence is the source of my filter. For the filter I then take the weekdays for each of the 14 dates and want to check if for (lets say the first day is Monday) I find a checked box in the column Monday. So for each of the 14 dates I need to check if its weekday has a value in the corresponding column.
Example: 1 (so any checked value) in my desired table.column(this is where I want to look in either the monday, tuesday, wednesday, thursday or friday column based on the weekday of that date)
Filter(ForAll(Sequence(14,Day(Today())),Date(2021, Month(Now()), Value)), 1 in Table.Switch(
Weekday(Value),
2, "Monday",
3, "Tuesday",
4, "Wednesday",
5, "Thursday",
6, "Friday",
))This approach does not work. Is there any way to achieve this. Maybe with look up?
The form in powerapps should now return only the Mondays and tuesdays for the next 2 weeks because this is where the function should find checked elements.(I used german names for the days because I am german. But Montag = Monday and Dienstag = Tuesday. Sorry for that.)
All responses (
Answers (
