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

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Unanswered

Find Non Allowable Calls within Open for Calls block

(1) ShareShare
ReportReport
Posted on by 19

I need to create a power apps screen that shows me all the calls in a gallery based on this condition - for example I am looking at a user's outlook calendar. He usually blocks few hours every day in his calendar as open for calls (marked as green) and within this time block user can have these allowable calls titled as 'Client Call' and 'Sales Call' (marked as blue)

but incase any other call that happens other than these allowable calls, between open for calls block then get me those calls/events data (here in this example it should return me 'Other Call' marked as orange). how do I create a collection in my app which stores all overlapping calls basically, only those non open for calls that overlap with the open for calls blocks. 

Somehow I'm able to create a collection that returns me all open for calls blocks and all other calls happening in a day but not able to get only those call/calls that are not allowed within open for calls blocks (Example call shown in orange color in the below ss)

 

I have the same question (0)
  • Suggested answer
    RogierE Profile Picture
    874 Moderator on at
    Find Non Allowable Calls within Open for Calls block
    In your collection, do you have the start and end times of those calls and open for calls blocks? If so, to find out if they overlap, you can check ExecutedCall.End> OpenForCalls.Start && ExecutedCall.Start <OpenForCalls.End. Of course you need to define not allowed calls by title, or if you would not be able to define them, define the array of allowed calls and see if a call is not in that array 
     
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Tom Macfarlan – Community Spotlight

We are honored to recognize Tom Macfarlan as our Community Spotlight for October…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 829 Most Valuable Professional

#2
developerAJ Profile Picture

developerAJ 489

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 395 Super User 2025 Season 2

Last 30 days Overall leaderboard