cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hughrmarks
Helper IV
Helper IV

Set variable to item selected in List Box

Can understand why this doesn't work.  

 

I have a list box named "Players".   I select one of the players from the list and click button "1", which should set the player's name as Variable1 so I can put it in a specific text box.   The formula I used for button 1 to create the variable was:

OnSelect = set(Variable1, Players.SelectedItems)

 

I didn't get an error message with that formula but when I set my text box to:

Text = Variable1

I get the error message:  The property expects text values, but this rule produces incompatible Table values.

 

I don't get it.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hello,

It's difficult to know why you have this error. And I don't know what to ask in order to help myself understand.
Maybe you Set the same global variable somewhere else as a different type.

Just create a new app and test it, to see how it works. If you understand it, then you may debug your issue.

View solution in original post

14 REPLIES 14
timl
Super User III
Super User III

Hi @hughrmarks

 

Users can select multiple items from a list box. Therefore, Players.SelectedItems returns a table that contains all the selected items from the list box. This explains the error message that you see.

 

If you want to show just the first selected item in your text box, you can use formula that looks like this:

 

First(Variable1).Value

Well the text box error message is gone but now there's an error on the button:

Expected: "Ident"  Found: "Control"

 

 

When you click the error icon, what property does the designer highlight that 'expects an ident, but finds a control'?

The button.

 

It's the one that onSelect attemps to create the variable:

Set(Variable1, Players.SelectedItems)

Yes, but which property of the button? The designer should highlight the formula that contains the error - which property of the button is associated with the formula that causes the error?

"Players" is highlighted when I click the error icon.

Mike8
Solution Sage
Solution Sage

Hello hughrmarks,

You can set the property of the button1 like this:
Button1.OnSelect = set(Variable1, Players.Selected.Value)

Just to see how is works, create a new label next to your listbox and set the property
NewLabel.Text= Players.Selected.Value

The last selection of the ListBox will be displayed as text in the label.

When I do that, I get this error message on the button:

Expected: "Ident"  Found: "Control"

 

And I get this error message on the text box:

Invalid use of "."

 

 

Hello,

It's difficult to know why you have this error. And I don't know what to ask in order to help myself understand.
Maybe you Set the same global variable somewhere else as a different type.

Just create a new app and test it, to see how it works. If you understand it, then you may debug your issue.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (81,241)