Unanswered

How to built up a forall(patch) for a dynamic request

(0) Share

Report

Posted on by ResatCanerBas

Hi there,

I am trying to build up an availability calendar for my team, and I would like to have a feature which allows users to set the availability for the user for the weekdays throughout the years.

ForAll(
 RenameColumns(
 Filter(
 _Availability,
//here is the problematic part, this is statically set
 Weekday(day_of_year) = 3 
 ),
 "ID",
 "SID"
 ),
 Patch(
 _Availability,
 LookUp(
 _Availability,
 ID = SID
 ),
 {
 All_Day_Available: false,
 Partially_Available: false,
 Unavailable: true
 }
 )
)

Users may request multiple days to be changed but I could not figure out how to set the filter query dynamically. The selected days are coming from a gallery with checkboxes.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ResatCanerBas 20 on at

Like
a
(1)

Report
Copy link

Link copied!
Here is my own resolution
//Days of the week selection, first prepare the collection If( !IsEmpty(__Selected_Days), Clear(__Selected_Days) ); // set the collection with IDs for each day If( LookUp( __Days_of_week, _day = 1, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 1 ).ID ) ); If( LookUp( __Days_of_week, _day = 2, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 2 ).ID ) ); If( LookUp( __Days_of_week, _day = 3, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 3 ).ID ) ); If( LookUp( __Days_of_week, _day = 4, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 4 ).ID ) ); If( LookUp( __Days_of_week, _day = 5, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 5 ).ID ) ); If( LookUp( __Days_of_week, _day = 6, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 6 ).ID ) ); If( LookUp( __Days_of_week, _day = 7, isChoosen ), Collect( __Selected_Days, Filter( _Availability, day_of_year >= CC_Date_Pick_1.SelectedDate, Weekday(day_of_year) = 7 ).ID ) ); //Patch the Collection ForAll( RenameColumns( __Selected_Days, "ID", "SID" ), Patch( _Availability, LookUp( _Availability, ID = SID ), { All_Day_Available: false, Partially_Available: false, Unavailable: true } ) );
I created a collection and collected all 7 cases where selected and applied patch on them.

Was this reply helpful? Yes No
Rohit Sharma354 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

I don't have an alternate solution, but your approach seems to be a good option. Let's see if any other community user has any other suggestions.

Was this reply helpful? Yes No