Power Platform Community Forum Thread Details

Heya @musa_touray - ignore that code they provided, its not even valid Power Apps code, you can't just use .AddDays or .StartOfWeek from a selected date, those kinds of things are available in other languages like C#/Javascript - their code was clearly pulled from chatGPT

Ok, so, getting back to your issue - do you have a column in your colMyOrders called StartDate? because you have used With to create temporary variables for these dates and so the filter will effectively not be doing anything as it will be suing the temporary With variables, not the column in the order collection, anyway, we will deal with that below.

Additionally, you said you want to only allow them to select Next week's dates, as they can only select next week's food this week, but your DateAdd code is asking them to go back in time and order this week's food last week, which is of course impossible.

So, let's start with your StartDate and EndDate - we want these to run Monday-Thursday for the following week, not the previous week, as we want to check that the date the user selected is next week as they cannot order food for this week, they can only order next week's food yes?

So in my example. today is the 15th of Feb and we want the valid choices to be next week Monday to Thursday, which is the 20th to the 23rd:

Ok, so now we have a valid way to check what next week's dates are.

Now we need to check, has the user ordered food for that selected day next week already, so we need to have a column in our collection that is the OrderDate (or whatever similar name you have in your collection), then we can filter by that and check if the _selectedDate falls within the Start/End date - so if there is an order on that selected date by that user then it should be invisible as they cant' order more than once per day. Then we check is the _selectedDate within the Start/End dates and make it visible if yes.

With(
 {
 //These must always reference Today, as you always want them to
 // only select dates next week, regardless of what date Today is
 StartDate: DateAdd(Today(), 8 - Weekday(Today(), Monday), Days),
 EndDate: DateAdd(Today(), 11 - Weekday(Today(), Monday), Days)
 },
 If(
 //Here we check if the user has an order on that date
 CountRows(
 Filter( colMyOrders,
 OrderDate = _dateSelected,
 createdby.Email = currentUser.Email
 )
 )>0
 // Then we also check that the date falls within the valid range
 // i.e. the date selected must fall within Mon-Thurs next week
 &&
 _dateSelected >= StartDate
 &&
 _dateSelected <= EndDate,
 false,
 //Our visible condition should be that the dateis valid
 // i.e. the date selected must fall within Mon-Thurs next week
 _dateSelected >= StartDate
 &&
 _dateSelected <= EndDate,
 true,
 //If none of the above conditions are met, do not display
 false
 )
)

Here are some example tests I did, and you can find attached a proof-of-concept .msapp app that you can open up an look at from within the editor

Next week Friday chosen: