Retrieve Value from first record of table

[KUNGFUPANDA559]

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)) 

[Pstork1]

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)

[Luke_Timmins · Accepted solution]

I think you are looking for something like this

Set(VarNameHere, First(DataSourceNameHere).ColumnNameHere)

If you want the complete row just remove the .ColumnNameHere snippet. Obviously replace values with a variable name, datasource name and column name.

Initiate from an OnSelect action or OnVisible page action.

Thanks
Luke

[KUNGFUPANDA559]

This was exactliy what I was looking for @Luke_Timmins