ok, starting from scratch here
Opened SPO list as my data source - the list has 2 columns
I want a radio button which shows options from one list. When selected, it sets a variable to the value in the othe column
My List has columns:
Company and Account Number
I want radio buttons to show list of companys (column 1). When selected, a variable is set to = account number for that company
When I add radio button and point to data source, it just shows values from Column2 (account number)
Solved! Go to Solution.
Hi @fless1,
Please take a try to set the Value field under the Advanced pane for the Radio control to Company Name.
For the account number, you should be able to get it by the following ways:
1.
Radio1.Selected.AccountNumber
2.
Lookup(ListName, Company=Radio.Selected.Value, Account Number)
More information about Radio control and Lookup function, see:
Regards,
Michael
Hi @fless1,
Please take a try to set the Value field under the Advanced pane for the Radio control to Company Name.
For the account number, you should be able to get it by the following ways:
1.
Radio1.Selected.AccountNumber
2.
Lookup(ListName, Company=Radio.Selected.Value, Account Number)
More information about Radio control and Lookup function, see:
Regards,
Michael
Thanks Michael. Didn't help matters that the column name in my sharepoint site is different to the column label
User | Count |
---|---|
132 | |
127 | |
74 | |
72 | |
70 |
User | Count |
---|---|
206 | |
201 | |
64 | |
63 | |
52 |