Answered

How to get the selected value in a listbox connected to a sharepoint list

(0) Share

Report

Posted on by ManuArco

Hi all.

I'm bulding a simply app that include a listbox connected to a sharepoint list. The list is running fine and obtaining the values from the sharepoint list.

The problem is that I want to use the selected value when clicking abutton in order to execute a powerautomateflow.

I can not select the value and use it in the run function. I have tried different solution, the last one is to set a variable with the selected value but I can not use it with First, nor other ways, can you help me?

Error: Argument type not valid (record) Expected table instead.

Set(varIdioma; First(listaIdiomas.SelectedText).Value)

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ManuArco

Try this for a listbox:
Set( varIdioma; Concat(listaIdiomas.SelectedItems, Value, ";") )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
ManuArco 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick answer @SpongYe !!

It was the error is that SelectedItems is not recognized
Then I changed it to SelectedText and It has other error (argument Type not valid) refered to the listBox
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManuArco

According to my test, my code should work:

Could you share a screenshot of the controls?
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ManuArco

According to my test, my code should work:

Could you share a screenshot of the controls?
ManuArco 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SpongYe

Here are the screenshots of the control:

The advice is about the sort formule can not run correctly in big values list

Properties:

This is how is sort using the sharepoint list

Thanks!
ManuArco 27 on at

Like
a
(0)

Report
Copy link

Link copied!

I added a new control connected to the same sharepoint list in order to check:
With this control I'm able to check is some item is selected:

But I can not use the selected value:

Concat function has invalid values
Value is not recognized:
Verified answer

ManuArco 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi all.

Finally I identified that the problem comes from the sharepoint list connections, I was getting the key column "Name" which cannot be parsed to string, I solved it by creating a new string column in the list and using it.