Answered

Multiselect searchable lookup field

(0) Share

Report

Posted on by julijazas

820

I have a sharepoint list and a multiple choices lookup field that grabs data from other list. What i am missing is i need to create it as a searchable multiselect lookup field(same as person field). I am thinking powerapps should help me in this case.

Can you help me to achieve this scenario?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jja ,

Do you want to configure the Multiple choices LookUp field as a Searchable field as that in Person field in your Edit form?

Based on the needs that you mentioned, I think the ComboBox control could achieve your needs. Actually, when you generated an app based on your SP List which including a LookUp type column, the LookUp type column would be decorated as a ComboBox automaticlaly as below:

If you have enabled "Allow Searching" option for the ComboBox, you could type search text within the ComboBox to find the specific option.

If the "LookUp field" that you mentioned is a normal Text field, you want to configure it as a Searchable Multiple Selections field as Person field, you could consider add a ComboBox control within the corresponding data card to list available options, then set the IsSearchable property of ComboBox to following:

true

then you could type search key within the ComboBox to find the specific option.

Best regards,

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft
Yes it does the job! and this is only by converting SPO list into powerapps form. Thanks a lot!
Now to be more fancy is it posible in that combobox to get values from powerbi dataset certain table and certain field field. In this case i need to pull my customers list

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jja ,

Do you want to fill the ComboBox with values from your Power BI dataset?

If you want to populate the ComboBox with values from your Power BI dataset, I afraid that there is no way to achieve your needs in PowerApps.

Accessing Power BI dataset from an canvas app directly is not supported in PowerApps currently. If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

As an alternative solution, you could consider add the corresponding data source the Power BI dataset related to into your app, then you could use the data source to populate the ComboBox.

Best regards,

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft

Could you describe more detaly how i could achieve your proposed alternative sollution?
As an alternative solution, you could consider add the corresponding data source the Power BI dataset related to into your app, then you could use the data source to populate the ComboBox.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jja ,

For example, if the Dataset in your Power BI report is a Excel table hosted in OneDrive folder. If you want to populate the ComboBox with values from your BI Dataset, actually, you could add the Excel table data source (hosted in your OneDrive) into your app, then you could populate the ComboBox with the values from the Excel table data.

The Dataset in Power BI report is similar to the data source within PowerApps app.

Best regards,

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft

Thanks for tips. That means that currently i can not get data in powerapps directly from powerbi dataset. I need to grab it from some middleware datasource like you said excel for example. OK i will try to figure it out. Unfortunately my dataset in powerbi is populated from SQL on premise using data gateway. Unfortunately if i want to use SQL connector it is premium so all my users would need a P1.
I thought powerbi dataset might work as data is already in cloud. I will submit an idea

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jja ,

Yeah, you are right. The SQL Server is a premium connector in PowerApps currently. If you or your end users want to use SQL Server connector in PowerApps, you must own PowerApps Plan 1 license at least.

Currently, the Power BI connector is not acted as a Table data source in PowerApps, and there is no way or function supported to retrieve the dataset data in a Power BI report from an app.

As an alternative solution, you could consider use SP List (which is not subject to PowerApps Plan 1 license) as dataset in your Power BI report. Then you could also add the SP List as data source into your PowerApps app.

Best regards,

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft
I followed your advice and created a SPO list and make it as lookup field
When i convert it to powerapps form i can search in this field and make multiple selections but i have an issue.
The data in this list looks like this UAB "Description1 Description2" so what users would do they would search only by typing Description1 or Description2 or even they would type it using lowercase. Is it posible to adjust this search scenario in powerapps so i can type as user types and this finds info. No i have to type identicaly as it is written incuding UAB "Description1 and then it find me this info

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

I think i made it:
on the Items section i added Search function
Search(Choices([@Objektai].Uzsakovas),DataCardValue8.SearchText,"Value")

Was this reply helpful? Yes No