Unanswered

Using Set(varIdea,ThisItem) in a Gallery and applying it on the single select column vs multiple select column.

(0) Share

Report

Posted on by azer091

Hello,

I've been using a patch function where I can Insert and Update existing data. It is made by Reza Dorrani, and I'm trying to apply it on my app but I do have a problem in applying it on a multiple select column Listbox , I already tried to use it on a single select column Listbox I did not encountered a problem.

Gallery 6 > OnSelect > Set(varIdea,ThisItem)

Used it on my Single Select Column and i didn't got an error. Default > varIdea.'Multi Select'.Value

Used it on my multi select column but there's an error. Default > varIdea.'Multi Select'.Value

Any suggestion on how can I remove the error in a multi select column?

Thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @azer091 ,

That is because a Multi-select field is a Table and you cannot display that is a Text field requiring a string. You could put spaces between the fields with

Concat( varIdea.'Multi Select', Value, " " )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
azer091 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thanks for your help, the error has been removed in the code.

Although the error has been removed it seems like the data from my gallery can't be called to my multi select listbox, unlike my single select listbox.

Is there any way that I call my data from gallery to my multi select listbox?

Selecting the data i want to be called.

There's a value in Default, but it is not reflecting to my listbox.. I already tried to put "," as a separator but nothing happens.

Thanks!

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @azer091 ,

Please review this blog of mine which sets out the process.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
azer091 13 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,

I already tried to use it, but it seems not working for me or maybe I'm not doing it right.

Thanks for your help!

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @azer091 ,

What is not working ? Do you get errors or no result ? Also what is your code (in Text please) that you have attempted?

Was this reply helpful? Yes No
azer091 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

I followed the steps based on the blog.

I tried to create new SP called ChoiceStore with 1 column for my multi select table, and copy the code on my App OnStart. But i get an error to my column name.

I'm still a newbie in power apps, and I find it difficult to understand the code and i get the feeling that this seems far to what I wanted to see in my app. Still thanks for your help!

I just want my listbox prepopulate the selected item based on the selecteditem from my gallery (or use it to be my defaultselecteditem to my listbox). Is there any workaround I can use? I can change my listbox in dropdown or combobox if that what is needed.

Thanks Warren, I really appreciate your help!

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@azer091 ,

You are missing the {} brackets from the code in the blog.

Was this reply helpful? Yes No
azer091 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

I'm still getting an error.

Thanks for your help always!

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@azer091 ,

Are all these columns Text columns ? If not please change them to this - my model is based on that assumption. Also please (as I requested previously) post any code also in Text. I have re-tested the code using your structure posted on a Test List and received the expected result.

Was this reply helpful? Yes No