Unanswered

switch single people picker to multiple people selection

(0) Share

Report

Posted on by tracycccc

Hi all,

I use Sharepoint List as my data source of power apps, and one of the columns is Notificiation_Email. Everything worked fine when this column was single selection, but when I switched the Settings to allow multiple selections, a lot of errors appeared.

For the Combox_user items:

Distinct(
 'ITGC Setting',
 'Notification Email'.Email = User().Email
 )

For the gallery Items:

SortByColumns(
Filter('Setting', 
 (IsBlank(ComboBox_user.Selected.Value)||'Notification Email'.Email = ComboBox_user.Selected.Value)
),
"ID",SortOrder.Descending)

For the Notification_Email text in gallery:

ThisItem.'Notification Email'.DisplayName

I guess the problem is that the record turns into the table, but I dont know how to solve them. Can anyone help me? Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
Hi @tracycccc ,

This should work, but note that it is not Delegable

SortByColumns( Filter( 'Setting', ( IsBlank(ComboBox_user.Selected.Value)|| 'Notification Email'.Email in ComboBox_user.SelectedItems.Value ) ), "ID", SortOrder.Descending )

If you require it to have some degree of Delegation, try this

Ungroup( ForAll( ComboBox_user.SelectedItems As _Data, Sort( Filter( 'Setting', 'Notification Email'.Email = _Data.Value ), ID, SortOrder.Descending ) ), "Value" )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
tracycccc 42 on at

Like (0)

Report
Hi @WarrenBelz ,
'Notification Email'.Email in ComboBox_user.SelectedItems.Value
.Email reports error: The parameter type is invalid and the table value cannot be used in this context.

Was this reply helpful? Yes No
WarrenBelz 153,040 Most Valuable Professional on at

Like (0)

Report
@tracycccc ,

OK - there is something wrong here I did not spot before - You can try .Email instead of .Value but the Combo Box Items of

Distinct( 'ITGC Setting', 'Notification Email'.Email = User().Email )

does not seem to be valid code to produce anything. What can you see in your choices ?

Was this reply helpful? Yes No
tracycccc 42 on at

Like (0)

Report
I am sorry I intercepted the wrong code,the right one should be this:
Distinct( Filter( 'ITGC Setting', 'Notification Email'.Email = User().Email ), 'Notification Email'.Email )
The "=" in the Combo Box items reports that The contents of the comparison are incompatible. Cannot compare table, text. This used to work when it was a single people selection, but an error was reported after switching to multiple selections😥

Was this reply helpful? Yes No