Answered

display combo box values from SharePoint site

(0) Share

Report

Posted on by JPCoetzee

I have been struggling with a specific problem for the past few days, I’m sure it is most probably an easy fix but I am unable to figure it out.

I have a cava powerapp using forms where I update information and save it on a sharepoint site. This includes single line input as well as selecting multiple options from a dropdown combo box. This portion is working correctly as all the information is updated accordingly on the sharepoint site.

The second portion of my app is to view the information that is currently saved on the sharepoint site. I have a field where you update the dispatch ID (Datacardvalue2) and it pulls the information from the sharepoint site to the relevant fields through a lookup as per below example.

My problem is when trying to show the information that was selected from the dropdown combo box. Upon my investigations I did pickup that I should use the Concat function, something like this Formula: (Concat(ThisItem.'Site Feature', Value,","), however then I get the below error:

I would greatly appreciate it if you could please assist.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JPCoetzee ,

Concat function returns text, but Items property expects Table. You should put the formula on Text property which expects text.

What do you want to show in Items of combo box? Could you please show more details?

Best regards,

Rimmon

Was this reply helpful? Yes No
JPCoetzee on at

Like (0)

Report
Copy link

Link copied!

From the below picture I just want to show the values from the site features column, that is linked to the Dispatch ID.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @JPCoetzee ,

If you want to show column value in combo box, you should use DefaultSelectedItems property.

If site features column is choice column or lookup column, please try this.

Items of combo box.

Choices([@ListName].'Site Feature')

Allow empty selection.

DefaultSelectedItems of combo box.

LookUp(ListName,'Dispatch ID'=DataCardValue2.Value,'Site Feature')

Best regards,

Rimmon

Was this reply helpful? Yes No
JPCoetzee on at

Like (0)

Report
Copy link

Link copied!

Thanks Rimmon, it works perfectly!

Was this reply helpful? Yes No