If you are an owner on the list, you are able to see gallery items

(0) Share

Report

Posted on by KarCz

Dear PowerApp Experts,

I would like to ask you about one thing. I have a configuration list to my 'Suggestion Box app'.

Columns, which are important:

Mailbox (Single Line of Text)

Owners (People picker)

Allow public browsing (Yes/No)

What I want to achieve?

Basically, if you're an owner of Mailbox, you should be able to see all suggestions in the app (from your Mailbox only) even if Allow public browsing is "No". I implemented a variable named varIsProjectManager , which is checking, if you're an Owner and I don't know how to write a function SortByColumns to show Owner of the Mailbox all suggestions within Parameter "Mailbox" and it shouldn't be visible for another users.

Basically, I'm an owner of Mailbox Technical (picture below) and Allow public browsing is ticked as 'no' and I'm not able to see anything:

Items in my gallery looks like below:

SortByColumns(
Filter([@'User Suggestions'],
(IsBlank(MailboxParam) || Mailbox = MailboxParam.Text) &&
MailboxChoice1.Selected.'Allow public browsing',
TextSearchBox1.Text in Title || TextSearchBox1.Text in Entry),
"Created",
If(SortDescending1, Descending, Ascending))

Now it's working for everyone - if Allow public browsing is No, my gallery is empty.

@RandyHayes please help

Thank you very much in advance,

Karol

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@KarCz

This is because you are comparing a control value only in your filter criteria. You are not comparing that to any record value!

This part of your formula has not context - MailboxChoice1.Selected.'Allow public browsing'

What is this for and what is the purpose and what is compared?

Was this reply helpful? Yes No
KarCz 85 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes that's true. Anyway I'm filtering a list with suggestions - Filter([@'User Suggestions'] (1)
and the value is in configuration list, which is named "suggestion Mailboxes" (2). So basically I want to give in SortByColumns function one value from another list (while i'm filtering "User Suggestions" (1) list). That's why I used MailboxChoice1 from another screen, because Default value of that field is "MailboxParam", which is a parameter of Mailbox column from list "suggestion Mailboxes" (2)

Was this reply helpful? Yes No
Verified answer

KarCz 85 on at

Like
a
(0)

Report
Copy link

Link copied!
Okay I did it. Thanks for suggestion @RandyHayes !

SortByColumns( Filter([@'User Suggestions'], (IsBlank(MailboxParam) || Mailbox = MailboxParam.Text) && LookUp('suggestion Mailboxes', Mailbox = Param("Mailbox")).'Allow public browsing' = true || If(LookUp('suggestion Mailboxes', Mailbox = Param("Mailbox")).Owners.Email = User().Email, Mailbox = MailboxParam.Text), TextSearchBox1.Text in Title || TextSearchBox1.Text in Entry), "Created", If(SortDescending1, Descending, Ascending))

Was this reply helpful? Yes No