Answered

Mulitple choice

(0) Share

Report

Posted on by batmanMon

202

I added a new column to the SharePoint list. I added a new field to the PowerApp, and removed the first one. It is a multiple choice field, as I replaced the one, which wasn't multi choice. In the formula I replaced Choice(ListOnSharePoint.'Column1') with Choice(ListOnSharePoint.'Column2'), but I have an error on the Edit Screen. It doesn't give me any errors on Detail Screen. Im not quite sure why?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@batmanMon

You should post a screenshot of the error message so the forum can see it.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report
Copy link

Link copied!

Somehow the error disappeared. I have Another issue. In the Gallery when I replaced the 1st column with the second one Column2 it errored out and all data disappeared.

Formula before: ThisItem.'Column1'.Value
After: ThisItem.'Column2'.Value
Error message: This formula uses scope, which is not presently supported for evaluation.
Does it mean that multiple choice field doesn't like ".Value". This is the only option I get.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@batmanMon

What type of control are you putting that code in? If its a label try using the CONCAT function.

Concat(ThisItem.'Column2',Value&" ")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report
Copy link

Link copied!

@mdevaney Thanks for your reply. This formula fixed the issue Concat(ThisItem.'Column2'.Value, Concatenate(PlainText(Value),", "))

Does anybody know how could I replace this formula from the Gallery: 'Column1'.Value in AreaComboBox.SelectedItems.Value so it represents Column2? It is a part of the long formula, which includes the values from another fields?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@batmanMon

Suggest you post the 2nd question as a separate and new post to give higher visibility.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @batmanMon ，

Do you want to know how to modify ComboBox.SelectedItems.Value?

Could you tell me

1)what does the combo box use for? do you use it to choose value of column2?

2)the formula of this combo box's Items?

3)where do you want to use ComboBox.SelectedItems.Value? If you could show me more details about this long formula, it will be better.

I assume that the combo box's Items is

Choices(ListOnSharePoint.'Column2')

If you want to use ComboBox.SelectedItems.Value as a text, try this formula:

Concat(ComboBox.SelectedItems,Value&",")

If you want to use ComboBox.SelectedItems.Value as a table, try this formula:

ComboBox.SelectedItems.Value

Best regards,

Was this reply helpful? Yes No