How to filter items in Gallery from sharepoint list which the user submiitted( in order to filter other user's item)?

[Jackywei_BDF]

Dear all:

I building a APP and want to filter items in Gallery from sharepoint list which the user submiitted( in order to filter other user's item).

i use set(varuser, User()) in app and want to filter only items which one user submit from sharepoint list.

How to do for that?

Thanks for your support:)

[eka24]

If you want the user only to view his or her records use:

Filter(Datasource, UserColumn = varuser.FullName)

or

Filter(Datasource, UserColumn = varuser.Email) depending on what is saved in the column in your datasource.

However, if you rather want to filter different users then:

1. Insert a Dropdown with items property as: Datasource

2. Then filter the Gallery as: Filter(Datasource, UserColumn = DropdownName.UserColumn)

In all the above, am assuming you have a column in your datasource where you have saved the user names or email addresses

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[JeffC1]

Based on your strategy, I recommend that you incorporate a controlled means of identifying your app users that is more robust than User().  This is especially true if you ever migrate your app tables into a different platform (e.g. SQL, Dataverse. etc).  Sure SharePoint conveniently writes this metadata that is available to PowerApps, but other backends may not.  If you have O365Users, on AppStart:

Set(
varUser,
Office365Users.MyProfileV2()
)

Now you have all of the user's info you will ever need.  Add a field to your SharePoint list (Owner) to write varUser.id when they create a record.  Then you can filter the creation of the collection on that table to ClearCollect(colSharePointListName, Filter(SharePointList, Owner = varuser.id)).

Want to be more normalized in your data strategy?  Create an AppUser table to write a record for all of your app users and then utilize the PK of that table for the Owner field.

[Jackywei_BDF]

Hi  eka24:

I  use default column in sharepoint list, but i can only find user and group type as 'author'.

Would you please tell me how to get which UserColumn as varuser.Email or varuser.FullName in sharepoint list?

I mean the sharepoint list don't have author email or author fullname by default setting.

Do you understand my question? Please help me out.

Thank you very much.

[Jackywei_BDF]

Hi JeffC1：

I am a newer for Power apps, for Add a field to your SharePoint list (Owner) to write varUser.id when they create a record. Would you please show me how to do to write varUser.id in sharepoint list?

Thanks a lot:)

[eka24]

I would suggest you add a column and save the users email after which you may use the formula.

You can also make use of the created by column by showing that column in sharepoint.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Jackywei_BDF]

Dear eka24:

Thanks for your patient:)

I am starter of Power apps. Would you please tell me how to use Formula to write user's email into column.

I don't know how to write Formula.

Thank you very much:)

[v-qiaqi-msft · Accepted solution]

Hi @Jackywei_BDF,

I have seen a duplicated thread here that has been marked as resolved, I will mark here to close this case.

Thanks for your cooperation.