Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Reservation app / Problem with Power Automate & PowerApps

(0) ShareShare
ReportReport
Posted on by 4

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.

  • Mister_Shaik Profile Picture
    Mister_Shaik 1,006 on at
    Re: Reservation app / Problem with Power Automate & PowerApps

    Hi @RomainJG ,

     

    Thanks for providing those additional details! Now it's clear what you're doing.

     

    First thing's first, you need to understand the way instant flows are different from Scheduled and Automated flows.

     

    When you're using instant flows, they always try to run on the connections of the person who triggered it. Which means, whatever SharePoint, Outlook or other connections you're using should be accessible by the users running the flow from your Power App.

     

    In your case, users are using the Power App and the Flow is getting triggered from the app to get outlook room info. But the catch is that they need to have access to the SharePoint list being accessed in the flow.

     

    As you already have access on the SharePoint - when you use the app, the flow runs successfully.

     

    Can you confirm if the SharePoint list is Shared with the users? If it's already shared and you're still getting the errors, you can provide some screenshots of the error or error messages.

     

    Kind Regards,

    Shaik Sha
    ________________________________________________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

  • RomainJG Profile Picture
    RomainJG 4 on at
    Re: Reservation app / Problem with Power Automate & PowerApps

    Hi @Mister_Shaik

    First of all, thank you for your response, and sorry for the lateness of mine. 

    Here are the different steps and software I used for each of them. 

     

    First of all, I'm using PowerApps to collect information about Date, Hour, Area, Service, Number of participants. 
    You can find a screenshot of the form bellow (sorry it's all in french)

    RomainJG_0-1645708117151.png

     

    The "Rechercher" button (means Search) will activate a Power Automate flow that will collect the information from the PowerApps forms. 
    The Power Automate flow will basiclly put these informations collected into variables, and use them to compare them with information from the SharePoint list where all the Reservation are stored, and then return to PowerApps a list of the available room. 

     

    One more important info : I am the one that created the PowerApps application and all the Power Automate flows that revolve around it

     

    A series of tests have been made with a couple of users, and they all lead to the same conclusion : 

    The Power Automate flow works perfectly with me and not with any other users


    Do you think that it has something to do with the fact that I'm the owner and creator of the Power Automate flow ? 

     

    Best regards,
    Romain

  • Mister_Shaik Profile Picture
    Mister_Shaik 1,006 on at
    Re: Reservation app / Problem with Power Automate & PowerApps

    Hi @RomainJG ,

     

    For this entire process, what are you using at different steps/user actions?

     

    Just in case it's helpful, here's how I would've done this,

    1. In PowerApps onSelect of Search button, I'd use outlook connector's FindMeetingTimesV2 to get availability of all the rooms for selected date and time.
    2. Now I'd store it into a collection by first filtering out the unnecessary information (availability = "free", etc.,)
    3. I'll then show this into a gallery or dataTable or a Map
    4. Once user's select a particular room and hit "Book/Reserve" then I'd again do a FindMeetingTimesV2 search to check room is free when the user hit that button and if it's free I'll book it, else I'll throw a notification.

    This would make sure everything stay's inside the PowerApp itself without the need for going in for a flow, and also make sure that there are no duplicates.

     

    Hope this helps 🙂


    Kind Regards,

    Shaik Sha
    ________________________________________________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard