Set Variables based on collection that carries a single row

[Nlsh]

I have a collection in my app that takes the row that has the Earliest Date in the "Date Out" Column of a sharepoint list and saves the entire row, the collection looks like how it is below:

Title:          Date In:        Date Out:

1                3/1/22          4/1/22

I just want to be able to set the "Title" and "Date Out" to their own variables, and print them out in a text box by referring to the collection, "EarliestDate" in my situation. To be clear the collection will always have only one item/row of information. I tried using Set(EarlyDate, First(EarliestDate.'Date Out')) and Set(TitleNum, First(EarliestDate.'Title')) but it seems to store these variables as empty records.

[rubin_boer]

hi @Nlsh 

Try the following change:

Set(EarlyDate, First(EarliestDate).'Date Out') and Set(TitleNum, First(EarliestDate).'Title')

Set(EarlyDate,First(EarliestDate).'Date In');
Set(TitleNum,First(EarliestDate).Title);

Hope it Helps,

R

[TheRobRush · Accepted solution]

Try These

Set(EarlyDate, First(EarliestDate).'Date Out')
Set(TitleNum, First(EarliestDate).'Title')

[TheRobRush]

@rubin_boer Sorry haha somehow missed your reply on this

[rubin_boer]

@TheRobRush we have impeccable timing 🙂