Filter my Gallery by logged-in user

[Anonymous]

Hi All,

i have built an app that has SharePoint list as Database , i need to show the logged in user their own data.

i have 2500 records in my collection but for some reason the data is showed to some users but not all 

this is my query:

Filter(Collection2,SearchBox_1.Text in Title||SearchBox_1.Text in 'LM Name'|| SearchBox_1.Text in 'Legacy system', 'SU Details_1'.DisplayName in User().FullName)

this is the output for a user that not getting the data back from the list:

i hope i can get any direction on this. 

[StalinPonnusamy]

Hi @Anonymous 

Please try this

With({Items:Filter(Collection2, 'SU Details_1'.Email = User().Email)},
Filter(Items, SearchBox_1.Text in Title || SearchBox_1.Text in 'LM Name' || SearchBox_1.Text in 'Legacy system')
)

Thanks,
Stalin - Learn To Illuminate

[PowerRanger]

@Anonymous 

In general your Filter expression looks good. Could you place a label on the Screen to always show User().FullName

I usually to it like this

Lower('Created By'.Email) = Lower(User().Email)

Try this and let me know if it worked.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

Hi Stalin , 

thanks for your suggestion but the result is the same. 

one more thing to clarify the Colum  'SU Details_1' is person or group :

[StalinPonnusamy]

Hi @Anonymous 

Can you make sure the column/schema name for 'SU Details_1' is correct?. To verify the schema name

• Go to list settings
• Click that column
• On the address bar, it should display &field=schemaname

I assume you are filtering SP Data source and the Person column is single (not Multi-Select).

With(
    {
        Items: Filter(
            [@IssueTracker],
            'Created By'.Email = User().Email
        )
    },
    Filter(
        Items,
        TextSearchBox1.Text in Title || TextSearchBox1.Text in 'Issue description' || TextSearchBox1.Text in Emp_Name
    )
)

make sure you are getting a valid User().Email.

Another option is to use office365user to get a user profile. In this case, we can use

With(
    {MailId: Office365Users.MyProfileV2().mail},
    With(
        {
            Items: Filter(
                [@IssueTracker],
                'Created By'.Email = MailId
            )
        },
        Filter(
            Items,
            TextSearchBox1.Text in Title || TextSearchBox1.Text in 'Issue description' || TextSearchBox1.Text in Emp_Name
        )
    )
)

Above both options, I tested using my data source which is similar to you.

Note: We are using with to avoid delegation

Thanks,
Stalin - Learn To Illuminate

[Anonymous]

Hi ,

the label you suggested worked but that don't solve the issue , what did you try to achieve by doing that ?

[Anonymous]

i am getting a valid User().Email.

the schemaname = &Field=SU_x0020_Details_1

maybe this is the issue ?

[Anonymous]

by the way Stalin ,

i am using this code :

With({Items:Filter(collection2, 'SU_x0020_Details_1'.Email = User().Email)},
Filter(Items, SearchBox_1.Text in Title || SearchBox_1.Text in 'LM Name' || SearchBox_1.Text in 'Legacy system')
)

i am not sure if its the right way to do it but:

if i am changing from collection2 to my "RecertDB" [the SP List DB not the collection] i am getting records but then something indicates to another issue with the Checkbox_Select1_1 [My Checkbox] : 

[PowerRanger]

@Anonymous does the user have read permissions on the list? Is he able to see any data when he goes to the SharePoint list directly?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

@PowerRanger  yes , they have edit permission .