I seem to be having issues storing record value to variable.
datasource.desired_field=123456789012345
varFinalValue should equal "123456789012345" not a table.
Thoughts?
set(varFinalValue,Value(datasource.desired_field))
datasource: SQL
datatype: varchar(15)
Solved! Go to Solution.
set(varFinalValue,Value(datasource.desired_field))
will return a table because your are getting all records for data source with column desired_field
you can either get first value from collection
set(varFinalValue,Value(First(datasource).desired_field))
or lookup data based on condition
set(varFinalValue,Value(Lookup(datasource,condition).desired_field))
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
set(varFinalValue,Value(datasource.desired_field))
will return a table because your are getting all records for data source with column desired_field
you can either get first value from collection
set(varFinalValue,Value(First(datasource).desired_field))
or lookup data based on condition
set(varFinalValue,Value(Lookup(datasource,condition).desired_field))
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
184 | |
95 | |
62 | |
59 | |
58 |
User | Count |
---|---|
246 | |
164 | |
93 | |
76 | |
70 |