Gallery visible to people from the given column

(0) Share

Report

Posted on by Michael92

Hello everyone,

Could you please help me...

I need people who are in the Responsible column to be able to view, edit and delete only their own items in Galery.

There can be several people in the Responsible column.

Could someone help me with the formula?

Thank you

Kind regards

Michael

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Micheal try this:
Search(DataBase,User().Fullname, "Responsible")
you can Switch Fullname with Email depending on what is used in the responsible Column.
Attention this Formula is not Delegable depending o, your Data source. Depending on your Column Format you could change the formula to something that is delegable.

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Michael92

You can add the formula if the user exists in the Responsible column and make it visible to view, edit or delete the item.

// Onvisible of the item in Gallery User().Email in ThisItem.Responsible

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Michael92 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @SpongYe

Name isn't valid. 'ThisItem' isn't recognized.
Any idea?

Thank you

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Michael92

Visible property is there for entire gallery not for a row in the gallery.

You gonna have to filter your datasource in the Gallery to filter out the rows that are not necessary.

Try this as a datasource:

Filter( [@Test_List], SearchInput1.Text in Title, User().Email in Responsible )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Michael92
Where are you getting data from for your gallery? (SharePoint, Dataverse, SQL Server, somewhere else)
How may rows are likely to exist in the table that the gallery reads from?

Was this reply helpful? Yes No
Michael92 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @SpongYe,

still not working...

Card is named Responsible_DataCard1. Is it correct if I use the name from Card or do I have to use the column name? Anyway it doesn't work with both.

Was this reply helpful? Yes No
Michael92 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @DJ_Jamba,

I use Sharepoint list.
The Responsible column is set as follows:

This is only test list with 2 rows. In production there will be at the begining approximately 1000 rows.

Was this reply helpful? Yes No