Answered

Expected Text Value error for List Box

(0) Share

Report

Posted on by pintobean87

I've been trying for hours to resolve this and I give up. I need help! I'll try to put in as much context as possible. I created a List Box in Power Apps for a column called Service in SharePoint List. Service is a choice column that allows multiple selections. When I run the app and point to a row that should have something under Service, no selection is currently made (even though there should be). I changed the formula under "Default" from "1" to

ThisItem.Service.Value

I get the error: Expected Text value. I tried several different solutions and none seem to work. Please, can anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

bgrgic1 124 on at

Like (0)

Report
Copy link

Link copied!

Hi @pintobean87, unfortunately, List Box allows for selecting only one item as the default value (although it has select multiple property). And because of that, you can only set one text value. To achieve what you look for you would be better off using Combobox control.

Was this reply helpful? Yes No
pintobean87 2 on at

Like (0)

Report
Copy link

Link copied!

I tried using a combo box with no success. The column I need doesn't show up in the Primary Text options because it is a multi-choice column. I probably need to do something in SharePoint List, such as, creating a calculated column that will convert the multi-choice column into a single string.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
HI @pintobean87,

Trust me, the ComboBox is the correct direction.

Configure your combobox as below.

1). Set the Items property of ComboBox:

Choices(listName.ChoiceColumn)

2). Set the DefaultSelectedItems proeprty as:

ThisItem.ChoiceColumn

Was this reply helpful? Yes No