Link a text label from values of a combobox into SP list

(0) Share

Report

Posted on by Charlie Martharper

943 Season of Giving Solutions 2025

Hi guys!

So what I have is a container with a lot of text labels that will bring information from different rows in a SharePoint list.

That information will get it from filtering between combo boxes, but just one will be the one that brings the information, so making the container visible with all the text labels.

"Codi / Descripció" is the one that will make the container visible and will have to bring the other columns from the row in the SharePoint list. The formula to get the container is:

If(
    CountRows(ComboBox_Codi.SelectedItems) = 0
        || IsBlankOrError(First(ComboBox_Codi.SelectedItems)),
    false,
    true
)

But, what I have to create to make the values from the other columns in the row linked to the combo box Codi?

Like, what formula in the text label, on On select and Visible?

Categories:

Connector development

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Charlie Martharper,

Please try below:

Container On Visible Property:

!IsBlank(ComboBox_Codi.Selected) //Replace - "ComboBox_Codi" with your control name

Regarding Label Text Display:

If your ComboBox data source is the SharePoint list itself, then the selected record already contains all columns, so you can write directly:

Label -Text Property

ComboBox_Codi.Selected.Observacions //Replace with your control name "ComboBox_Codi" and "Observacions" - Replace with exacts column name

However, if the ComboBox is not directly connected to the SharePoint list (for example it uses a collection or a different source), then you must retrieve the row using LookUp, like this:

LookUp( SharePointList, //Replace with "SharePointList" your SharePoint list name Codi = ComboBox_Codi.Selected.Codi, //user your column and control for comparision Observacions //Observacions - replace with your field name that you want show )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Kalathiya!

So the thing is that I had couple of values that were returning so it couldn't handle it by 1 unique container.

I created a gallery that returns those rows in the list that has same value as in the combo boxes, so you can choose from there and there, when you choose one of them in the gallery, it has to bring the values in the label text properties in the right container. In this example you can see when especialitat is selected, it has 2 options. So from the gallery you can pick from there so it shows the row values from the gallery and not from the combo box.

I think that would change a little bit the functionality of your formula. I used it instead the combo box, get the gallery control and it worked.

THanks!!

Was this reply helpful? Yes No