Power Platform Community Forum Thread Details

Hi,

I have a deskbooking app which I am building. The user can select their desk from an interactive floor plan and this writes (patches) their booking to one of three Dataverse tables; these are split by location of the office they are booking for.

I want to add some logic so that the user cannot book more than one desk per day across any of our offices (so across the three Dataverse tables). If they try to, I want an error message to display. I also want some specific users (I have their emails) to be able to book more than one desk per day, however.

Any ideas?

thanks

Categories:

Building Power Apps

Store the emails for specific people in separate database.

App.OnStart

Set(varUser,User());

Set(IsEmail,LookUp(LIstWithEmail,Email=varUser.Email).Email);

The above code will store logged in user's email into variable if he is in that specific people list.

Wherever your "Submitting to databse" code is write this before that:

Set(IsList1,LookUp(List1,Email=varUser.Email && BookingDate =Today());

Set(IsList2,LookUp(List2,Email=varUser.Email && BookingDate =Today());

Set(IsList3,LookUp(List3,Email=varUser.Email && BookingDate =Today());

If( !IsBlank(IsEmail),

Your Submit Code,

If(!IsBlank(IsLIst1) || !IsBlank(IsLIst2) || !IsBlank(IsLIst3),

Notify("You can only make one booking per day",NotificationType.Error),

Your submit code);

What the above code does is whenever user tries to make a booking it will first check all three tables weather same user has booking for the same day. If it is there it will store that value in the variable. If one of the variable has value stored in it. It will display error message. if not it will save that record. If you want to make booking procedure faster you can set this three variable on App.OnStart also