web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Best way to build an a...
Power Apps
Unanswered

Best way to build an app ?

(1) ShareShare
ReportReport
Posted on by 16

Hello, 

 

I am an (almost) totally newbie, but I have managed to build my first efficient app, but I want to take it to the next level.

 

I work as a surgeon in a general hospital, and I would like to create a solution that could manage when other surgeons are away, thus freeing up space in operating rooms (one can also imagine extending this to other locations such as consultation offices that would be freed up when someone is away).

 

We satarted out building an Excel spreadsheet that uses one column as dates, and another column for each surgeon in my department. Other columns represent different physical locations (ORs) and are calculated when one surgeon marks "A" for the dates, adding up different freed up slots with : If(Or(And(Weekday(DateColumn;2)=1; Surgeon1Column ="A"));1;0) and so on for other days and other surgeons. A final column adds the freed up slots giving a visual on how many slots are open. When someone decides to fill up the slot, it would be rendered unavailable. Managers could also stop the slots from being filled (as when personnel is on Holidays during the summer for example)

 

I would like to build a Powerapp that could manage this with a friendly user interface, but have been stuck on the best way to set up and manage the database : A Sharepoint list ? A Sharepoint calendar ? Excel ? Directly through Outlook ? 

 

My first idea has been to create a Sharepoint list replicating the Excel spreadsheet (as one can not use formulas in Excel with Powerapps), but I feel this is not the most efficient way to start on this project, and would like to start properly without having to do it all over again if another idea is better. (I would love for example, that people could fill out their absences directly in their calendar and the slots would be freed up int the app)

 

I'm not sure I was perfectly clear in expressing my project, but would anybody have any ideas on how the best (and easiest) way this could be done ? 

 

Many thanks

Categories:
  • poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    @sundry 

     

    There are many approaches you could take here.

     

    Before suggesting anything, some time passed since your original post, did any other ideas pop up on your end in the meantime?

  • sundry Profile Picture
    16 on at

    Hi, yes a lot of time has passed (my post was initially marked as spam so that didn't help, especially being my first...)

     

    I built a working app but I have the feeling my workaround is pretty heavy and bumped into other limitations. 

    I'll post shortly about my new roadblock.

     

    Thanks

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 243 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 190 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard