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!
