Answered

Gallery control where conditions are based on card items

(0) Share

Report

Posted on by Orvyn

Good day,

Please find the below example of a gallery with 2 card items.
Is it possible to create a control where in the case of the matching Code-Items in the gallery to look at the date and depending on the date to hide the edit button for example, the oldest date range?

The source of the gallery is a collection. So, in the case this is possible, do you point to the data source to do the check or the gallery?

Kind Regards

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RodCha 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Let me know if this works for you
Orvyn 78 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RodCha for the feedback.

My request might have been misleading, so let me try again.
1. So, the first check is to see if in the gallery contains cards containing the same item code.
2. If yes, to look at both starting dates and to decide which is the oldest, and in the card with the oldest start date to hide the edit button.

Hope the above is a better explanation?
Kind regards
RodCha 216 on at

Like
a
(0)

Report
Copy link

Link copied!

This is just a test that I'm trying, do you think this can work with your goal? But the edit button will be working based only with the reference of the start_date.
Orvyn 78 on at

Like
a
(0)

Report
Copy link

Link copied!

@RodCha , yes it looks in line with my goal, however, a minor would be just to make the latest date range the editable one thus hiding the edit button where the oldest date is for the matching item. Many thanks for your help thus far.
Verified answer

RodCha 216 on at

Like
a
(1)

Report
Copy link

Link copied!
First add the 'flexible height gallery' then insert the 'vertical gallery'.

Here are the formulas if you want to just copy/paste:

ClearCollect(test_data, {code: "001", start: Date(2014,09,03), end: Date(2024,01,31)}, {code: "001", start: Date(2024,02,01), end: Date(2050,09,11)}, {code: "002", start: Date(2024,02,01), end: Date(2050,09,11)}, {code: "002", start: Date(2024,02,01), end: Date(2050,09,11)}, {code: "004", start: Date(2024,02,01), end: Date(2050,09,11)} )

Filter(GroupBy(test_data, "code", "data"), CountRows(data) >= 1)

With({table: SortByColumns(Filter(test_data, code = ThisItem.code), "start", SortOrder.Descending)}, ForAll(Sequence(CountRows( table )), Patch(Last(FirstN( table, Value)), {RowNumber: Value}) ))

Self.TemplateHeight * CountRows(Self.AllItems)

ThisItem.RowNumber = 1