Hello people,
Can I please ask for advice/hint how to complete the next challenge🙏
I am beginner in Power Apps.
Resources only SharePoint List, Power Automate (other resources are not available in my team)
I have to create a book app. 2 pages.
1st: Book a room. I created a SharePoint list, next step - form, required fields: name, number of people, date, time, room, equipment. I can`t understand how to complete the logic:
If user input number of people - 6 (he/she can choose only room A); if input = 7-10, user has choice between room B and C,(it has to depends on the availability of rooms) but if number of people is bigger than 10 - only one choice room C. All for me look more complicated because of the data card equipment: Room A - it doesn`t exist any equipment. Only B and C have this.
Also, admin people have to approve booking and user has to receive email confirmation.
I tried to create 2 separate list, filter data, apply checkboxes, radio buttons but all failed.
Are there the best option to use collections?
What tools can complete this functionality?
2nd: Hot Desk. I created a SharePoint list, form, required fields: name, number of the desk, date, time. I can`t understand how to complete the logic:
How to show the user available desks according to the user input date?
B
Also, there are some "flexible" desks can be available but admin people have to make them available and only after this user can see it, for this one challenge is possible to use 2 separate lists: one for storing data and anther for admin to approve it? Because user has to receive email confirmation.
Sorry for long message.
I have anxiety that I will fail my first serious task😪
