Unanswered

Set Variables based on collection that carries a single row

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @Anonymous

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

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (2)

Report
Try These

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

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report

@rubin_boer Sorry haha somehow missed your reply on this

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

@TheRobRush we have impeccable timing 🙂

Was this reply helpful? Yes No