Unanswered

Make parking spaces available on certain days

(0) Share

Report

Posted on by Masakichi123

Hello everyone,
I would like to ensure that certain parking spaces are only displayed on certain days in my parking booking app. I was thinking about implementing this with checkboxes that are at the relevant parking spaces and that last from Monday to Friday. If these checkboxes are checked, the corresponding yes/no field will be activated in the connected sharepoint list.

Now I just have to teach the system that if, for example, the "Monday" checkbox is checked, that this applies to all Mondays of the month, etc. How can I do this?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Let's say you have a gallery, and that is filled with records that are parking spaces. You can then have a column in your splist that stores these parking spaces called restrictedDays or whatever you like, make it a choice column. Then in your gallery where presumably you or a user can adjust availability of that spot, place 7 check boxes and label them s m t w t f s or whatever you like to signify dates this spot can not be used. In those on OnCheck place something like this

Collect(restrictionDates, 2); Patch(spListName, ThisItem, {restrictedDays:restrictionDates})

and in its OnUncheck

RemoveIf(restrictionDates, Value=2) Patch(spListName, ThisItem, {restrictedDays:restrictionDates})

where the numbers match corresponding days of week (default if you have not set yourself is Sunday 1 on through Saturday 7)

Then you just check that column when displaying to end user for the day number and put that days choice in disbaled mode if it is present and edit mode if not, or if checking day of only

Weekday(Today()) in ThisItem.restrictedDays.Value

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report
Copy link

Link copied!

@TheRobRush : Thanks for your answer. That sounds interesting. A question for understanding: Then I would only have one column, right? Would this also be saved if the parking space were available for Tuesday, Wednesday and Friday, for example? Or would I then have to define several columns?

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

This method would require a single column

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report
Copy link

Link copied!

@TheRobRush : I'm trying to implement that right now. I typed the following because he didn't want the original formula:
Collect(Verfügbarkeit;1);;Patch(Parkplätze;ThisItem;{Verfügbarkeit:ThisItem.Verfügbarkeit})

Now the system says "Title is required". But when I try to pass the title, the error persists. What am I doing wrong?

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report
Copy link

Link copied!

Sorry, i try, but that doesn`t work....

Was this reply helpful? Yes No
Masakichi123 58 on at

Like (0)

Report
Copy link

Link copied!

If I use the solution above, the tick is no longer displayed in the checkbox, the app twitches briefly and does something, but you can't see that anything has happened.

I would like to check the checkboxes first and then patch the resulting values in one go using a button. And if you uncheck the checkboxes and click on the button again, the new version will be patched. Is that possible somehow?

Was this reply helpful? Yes No