Answered

Retrieving Values from a gallery and adding them to a Form Datacard

(0) Share

Report

Posted on by jselman

I want to take the start date from the first row of a gallery and the end date of the last row of a gallery and combine them into a Form data card. I also want to subtract end date of the last row from the start date of the first row to see how many days total. Please see picture for clarification.

Thank you.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

C-Papa 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!

Should be able to do something like this:

Set the default property of the start date which is derived from the first gallery row to:

First(Gallery1.AllItems).StartDate

you will need to change gallery1 to your gallery name and StartDate to your column \ date picker name. If its a date picker it will need .SelectedDate at the end

And end date to:

Last(Gallery1.AllItems).EndDate

you will need to change gallery1 to your gallery name and StartDate to your column \ date picker name. If its a date picker it will need .SelectedDate at the end

then use DateDiff(EndDate,StartDate) to get the difference in days
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Travel Dates Text property: First(Gallery1.AllItems).StartDate & "-" & Last(Gallery1.AllItems).EndDate
Total Travel Days: DateDiff(Last(Gallery1.AllItems).EndDate, First(Gallery1.AllItems).StartDate, Days)
jselman 38 on at

Like
a
(0)

Report
Copy link

Link copied!

You are a rock star. This worked perfectly. Thank you.