Set Global Variable to Specific Record

[Sacred_Totems]

App OnStart must be set to to make a variable out of a record from Sharepoint.

If the Variable is called HouseChoice, and you wanted the record with "Choose A House" in the Title column, what should Set() be like?

[v-siky-msft · Accepted solution]

Hi @Sacred_Totems ,

Filter returns a table, LookUp returns a record.

Please try this:

Set(HouseChoice,LookUp('SP list',Title="Choose A House"))

Sik

[eka24]

Try:
Set(HouseChoice,LookUp('House list',Title="Choose"))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Vincent_I]

If I wanted to choose the current record, what would Set() look like?