Canvas App - User not able to use Dropdown filters

(0) Share

Report

Posted on by BenBennett321

114

Hi all

I have a canvas app with a sharepoint list data source less than 2000 entries. I have two screens, one screen has a gallery that can be filtered depending what options have been selected on two dropdowns on the screen:

Screen 1 -this one should filter the sharepoint list by the User().Email and then dependent on the dropdowns selected. This works perfectly for me, but does not work at all for another user:

ITEMS property of this gallery:

Filter(
 Sort(
 [@'Fundraising Pipeline'],
 Deadlinem,
 SortOrder.Ascending
 ),'Allocated to' = User().Email &&
 (Dropdown4.SelectedText.Value = "All" || Status = Dropdown4.Selected.Value) &&
 (Dropdown1.SelectedText.Value = "All" || Deadlinem = Dropdown1.Selected.Value) &&
 TextSearchBox1.Text in Title
 
)

However the other screen:

This doesn't filter by User().Email, the User is selected via a dropdown:

Filter(
 Sort(
 [@'Fundraising Pipeline'],
 Deadlinem, SortOrder.Ascending
 ),
 (Dropdown4_1.Selected.Value = "All" || Status = Dropdown4_1.Selected.Value) &&
 (Dropdown1_1.Selected.Value = "All" || Deadlinem = Dropdown1_1.Selected.Value) &&
 ('Allocated to' = If(Dropdown4_2.Selected.Value = "All", 'Allocated to', Dropdown4_2.Selected.Value))
 && TextSearchBox1_3.Text in Title

This works fine for the user - this proves there isn't a permissions issue with the Sharepoint List, so I'm struggling to work out why one works and the other doesn't. This person has about 183 records allocated to them, out of a total of 700 on the sharepoint list. I tested moving his allocation to me and everything worked fine, so it can't be a delegation issue either.

Any ideas why one would work and the other wouldn't?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BenBennett321

User().Email is not always the same case as PersonColumn.Email in SharePoint.
The Filter function is case sensitive.

Try:

With( { fvar_query: Sort( [@'Fundraising Pipeline'], Deadlinem, SortOrder.Ascending ) }, Filter( fvar_query, Lower('Allocated to') = Lower(User().Email) && (Dropdown4.SelectedText.Value = "All" || Status = Dropdown4.Selected.Value) && (Dropdown1.SelectedText.Value = "All" || Deadlinem = Dropdown1.Selected.Value) && TextSearchBox1.Text in Title ) )

Was this reply helpful? Yes No
BenBennett321 114 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much, having written out the problem I thought there must be an issue with the User().Email call, and searched the user using the Office365Users connector and lo and behold this user had capital letters in the email. Didn't know how to rectify this and then your solution appeared, thanks so much I really appreciate it!

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

Like
a
(0)

Report
Copy link

Link copied!

You're welcome!
d(-_-)b

Was this reply helpful? Yes No