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)
Go to Solution.
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:
Lookup(ListName, Company=Radio.Selected.Value, Account Number)
More information about Radio control and Lookup function, see:
Radio control in PowerApps
Lookup function in PowerApps
View solution in original post
Thanks Michael. Didn't help matters that the column name in my sharepoint site is different to the column label
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.