Answered

Display only for specific users in gallery

(0) Share

Report

Posted on by Becca_Hayes

Hello all,

I am trying to make a power app and currently trying to figure out how to make a gallery only display items to the users that created them AND to users whose email is used in one of the fields on the items. So, for example, the column in question is just called "user email", so if I were to input a new item and put John Doe's email in the 'user email' field, I would want that item to display in the gallery to only me (the one who created it) and to the user whose email is in that field (John Doe).

I originally had it already set up to only display to the user that created the item with this formula in the Items property:

Filter('DataSourceName', Lower('Created By'.Email) = Lower(User().Email))

I found this from another topic question that had been asked in this forum and it has been working so far. Recently, we've had a change of needs in the app and now need it to do as I described above. How could I rewrite the above formula to do this? Or alternatively, can I just add to it to do what I need?

Thank you for any feedback!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

turnerj3 2,039 on at

Like (1)

Report

Try adding Or user email =User().email after the first condition in your filter

Was this reply helpful? Yes No
Becca_Hayes on at

Like (0)

Report

How would I go about writing the full thing out? I tried a few ways and it doesn't seem to be working for me. Sorry, I'm not very knowledgeable yet on how to write out formulas. 😅

Was this reply helpful? Yes No
Verified answer

MaikoNGY 38 on at

Like (1)

Report
Hello,

You can try this :
Filter('DataSourceName', Lower('Created By'.Email) = Lower(User().Email) Or Lower('user email') = Lower(User().Email) )

The 'user email' is the name of the column where you put John Doe's email 🙂

Was this reply helpful? Yes No
Becca_Hayes on at

Like (0)

Report

Thank you, this worked! I was on the right track just had it formatted wrong.

Was this reply helpful? Yes No