Answered

Cant select records in ListBox

(0) Share

Report

Posted on by SimpleUser

Hi,

i have a SharePoint list where there is a lookup column to a document library. Users can select multiple items for each item.

I'm trying to make an app that acts as the interface for the list and for reviewing records the editform shows a listbox with the selected items in that column. I have that all working, however the listbox doesn't let me select items, just displays them.

I've tried getting the list of items in the record with 'ThisItem.'Supporting'.Value' and creating a collection with Distinct(colAttachments,Value). Both successfully list the items in the record, however selection of them just doesn't work, it's like the display mode is disabled (it isn't!).

My intention is that when an item in the list is clicked, it takes the user to the document in the library. I've done this with other apps and an attachments column, but is this because the column is a lookup to the library?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SimpleUser ,

ListBox doesn't allow multiple selections, but only for displaying items. Please use a Combo box instead.

List Box control in Power Apps - Power Apps | Microsoft Learn

Selected – The data record that represents the selected item.

Note

You can only have one default selected item. If you need multiple selected items please use the Combo Box control.

Best regards,
SimpleUser 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I still have the same issue, combobox is listing the items but none are selectable. I only want to be able to click a single item to act as a hyperlink to the document itself.
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SimpleUser ,

I think I understand the requirement now. You want the LookUp column in the App acts exactly the same as it is in SharePoint list, that means items in the LookUp column would be like hyperlinks and users are able to open a new tab to view the source value when they tap or click on an item. Am I right?

If so, please use an HTML Text box with its HTML text set to:

Concat(AddColumns(ThisItem.Supporting,"link",Concatenate("<a href=https://xxx.SharePoint.com/sites/SiteName/LibraryName/Forms/DispForm.aspx? ID=",ThisRecord.Id,">",ThisRecord.Value,"</a>")), link ,"; ")

you can copy the contents within the red rectangle area after clicking a LookUp item from the list and the specific item is open on another tab.

Best regards,
Verified answer

SimpleUser 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for your help, i'd forgotten i had a variable setting the form mode to view which is why i couldn't select anything! I've got it all working now but thank you for your help.

I've created a collection that looks up the document path from the Id of the selected item and then used this in the Launch function.