Having trouble declaring variable from first row in datasource.
Ideally, using something like the following should return the desired_value from the datasource.
error suggests invalid arguments.
datasource: SQL
datatype: varchar(15)
set(firstValue,text(datasource.desired_value))
Solved! Go to Solution.
There is an actual function available in PowerApps that will return the first record in a data source. You'll preferably want to filter the data source to a subset of records that you know will contain the first record.
First(datasource)
User | Count |
---|---|
198 | |
122 | |
85 | |
50 | |
42 |
User | Count |
---|---|
284 | |
159 | |
134 | |
73 | |
72 |