Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Filter Canvas App Gallery based on Case Creator

(0) ShareShare
ReportReport
Posted on by 10

Hello,

 

This seems like it should be a no brainer, but I'm new to Canvas App development and can't find the answer online.

 

We have a 6 person dev team who work cases in D365 Customer Service and I am creating a canvas app for our end users (60+ people) to submit cases to that dev team. I know how to show a list of cases assigned to my devs (who are licensed as D365 admins), but I can't figure out how to just show cases that were created by my end users

 

I have my app's onStart property setting a variable as the current user 

Set(varUserEmail, User().Email)

 

and my main screen's gallery I have filtered as this but nothing shows up in the gallery

 

Filter (Cases, Contact.Email=varUserEmail)

 

I've also tried this but get the same result with no cases listing in the gallery:

 

App onStart

Set(varUser, User().FullName)

 

Gallery filter

Filter (Cases, 'Created By'.'Full Name' = varUser)

 

Any help would be greatly appreciated and if there's more info I can provide, please ask. TIA

Categories:
  • Verified answer
    wcerct Profile Picture
    wcerct 10 on at
    Re: Filter Canvas App Gallery based on Case Creator

    Interestingly, I retyped my last gallery filter to the below and now it works.

    Filter(Cases,'Created By'.'Full Name'=varUser)

     

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics