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

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Lots of filtering and ...
Power Apps
Answered

Lots of filtering and conditionals

(0) ShareShare
ReportReport
Posted on by jimi_hendrix

Im looking for some help around the following. 

 

I have a gallery and of course a dataset.. 

I have 4 columns in that dataset, example below

 

NameOfficeTeamSkill
John GreenNYA-TeamMaster of the universe
Brian RedNYA-TeamKnight
Steve BlueNYA-TeamKnight
Ava YellowNYA-TeamKnight
Tom SilverALA-TeamKnight
Robert PurpleALB-TeamMaster of the universe
Alex ApricotALB-TeamMaster of the universe
Ed BlueALB-TeamKnight

 

Im looking to get a filtered list that would only show Tom Silver and Ed Blue.. 

 

Tom Silver cause he is the only one on the A-Team that is a Knight residing in AL.. 

and

Ed Blue cause he is the only Knight on the B-Team in AL.. 

 

In short, there needs to be two people on the same team, in the same office, having the same skill for them to NOT show up on the list.. 

 

Any help would be greatly appreciated

Categories:
Building Power Apps
I have the same question (0)
  • ChannelDevMike Profile Picture
    ChannelDevMike 255 on at

    Ah you're right, he didn't mention Dynamics 365. I assumed it. I think he mentioned Sharepoint in one comment so your way is better for him. If he is using Dynamics 365 then I can jump back in. Sorry for the confusion! 

  • WarrenBelz Profile Picture
    WarrenBelz 153,472 Most Valuable Professional on at

    @ChannelDevMike ,

    This is the first time you have mentioned Dynamics365 as your data source - I have been assuming SharePoint, in particular my comments on calculated columns, however I do not use D365 and cannot comment on that aspect. My response to your post was based on accessing the values in the table you posted as Text - what you are asking is complex enough just with that.

  • ChannelDevMike Profile Picture
    ChannelDevMike 255 on at

    I don't know if this is how calculated fields were intended to be used.. but my org uses them like this because it works.

    ChannelDevMike_0-1674224870410.png

    hzy_case is a lookup field. In this case, I only needed one value from it. I can set a value in another entity this way. This column is basically just a reference to Total Task Minutes. (Which seemed to be what he was looking to do)

    So my answer above was to do something similar.  It would be something like hzy_skills.name (I am guessing the column in skills that provides values "Knight" and "Master ..." is the Name column in skills.) and setting his text column that he made for reference to this.

  • jimi_hendrix Profile Picture
    jimi_hendrix on at

    @WarrenBelz , correct.. I am using a Lookup column, not a calculated column.. I have something working.. Im now running some tests to see if its doing what I expect.. Will keep you posted

  • WarrenBelz Profile Picture
    WarrenBelz 153,472 Most Valuable Professional on at

    @ChannelDevMike ,

    I assume you are also @jimi_hendrix ? Please explain wat you mean here - You said Skills was a Lookup column - calculated columns simply will not work here.

  • ChannelDevMike Profile Picture
    ChannelDevMike 255 on at

    For this, I use a calculated field. Setting this text column to Skills.Name when Skills contains data

  • WarrenBelz Profile Picture
    WarrenBelz 153,472 Most Valuable Professional on at

    Hi @jimi_hendrix ,

    This should do the job based on the values you have posted

    Ungroup(
 Filter(
 AddColumns(
 GroupBy(
 Filter(
 AddColumns(
 GroupBy(
 AddColumns(
 SPListName,
 "TeamVal",
 Team.Value,
 "SkillVal",
 Skill.Value
 ),
 "Office",
 "TeamVal",
 "SkillVal",
 "Data"
 ),
 "Members",
 CountRows(Data),
 "Name",
 First(Data).Name
 ),
 Members = 1
 ),
 "Office",
 "SkillVal",
 "Data2"
 ),
 "TeamMembers",
 CountRows(Data2)
 ),
 TeamMembers > 1
 ),
 "Data2"
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • jimi_hendrix Profile Picture
    jimi_hendrix on at

    @WarrenBelz , The team and skill columns are both lookups. One of the thoughts that I was thinking was to create a "text" add on column that can easily be referenced.. but struggling to do that as well. 

  • WarrenBelz Profile Picture
    WarrenBelz 153,472 Most Valuable Professional on at

    Hi @jimi_hendrix ,

    Which column/s are lookup ? They are not good ideas at the best of times (I never use them) unless you need to use the SharePoint bulk edit facility directly.

  • jimi_hendrix Profile Picture
    jimi_hendrix on at

    @WarrenBelz , Thanks for your reply.. Im struggling on performing the above cause I dont know if its possible to group by a sharepoint lookup column.. Ive tried multiple different ways and havent been able to make anything work.. any suggestions.. 

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

News and Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Kalathiya Profile Picture

Kalathiya 400

#2
WarrenBelz Profile Picture

WarrenBelz 348 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 315 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans