Hi everyone,
I’m having a problem with my web application.
First, let me explain quickly what my application does.
Basically, it’s a web app that allows employees to book a meeting room.
Employees must fill a form with these data:
- Date
- Starting time
- Ending time
- Number of participants
- Department
After clicking on the “Searching” button, the app will display a window with a list of available meeting rooms in accordance with the data previously filled and sent the Power Automate Flow. The functional flow is supposed to only propose room that are available, since it asks the SharePoint list that contains all the reservation. There must be no duplicated reservation.
Then, they must choose a meeting room, and the app will display one last window with the reservation details, so the user can double check his reservation data before “Confirming”.
From a SharePoint, PowerApps and Power Automate point of view, I am the administrator, and there is a bunch of users.
Here is the main problem I have:
- There are many cases of duplicated reservation. That includes reservation for the same room, during the same slot, from different people. That problem is caused by the fact that, when searching for an available room, PowerApps and the Power Automate flow responsible for filtering the available room will return room that are not available at all.
On top of that, the problem can hardly be resolved since it only happens when “Users” search for a meeting room. As a manager, I don’t get the same result and Power Automate returns only the room that are available.
I am willing to share any info, screen shot, etc… from the app, to help anyone and give more context.