PowerApps combobox defaultSelectedItems not showing

[asif082]

Hello Everyone,

I am really stuck in combobox default selected items for two days and hoping if someone can help me with the following problem.

1. I am storing combobox multi selected items in SQL column as a text field using ", " with concat function which is working fine. Now I am using Split function to read those values in default selecteditems which are showing in search field but, they are not selected in combobox.

Below are the screen shot.

Script

I am not really sure what am I doing wrong above but I have tried storing gallery selected items in collection and using that collection in default selected items but, it just doesn't work.

Any solution would be really appreciated.

Thanks,

Asif

[asif082 · Accepted solution]

okay I think I got it, after several different attempts this formula works.

Filter(

'[dbo].[FVIS_Request_Received_Lookup_Ref]',

Lookup_ID = 7,

Lookup_List in Split(galReceived.Selected.Confidential_info_requested,", ")

)

so the only issue is now its giving delegation warning for using "in"

[alrez]

Hi,

Awesome! Thanks for your follow up post on this here. I am glad you were able to figure out what was causing your issue here. I just wanted to follow up with a little bit more information here. Feel free to take a look.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-split

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.