I have a gallery that works fine like this.
I add the ForAll and Sequence to add a RowNo so I can do alternating colors in my gallery.
With(
{
records: Filter(
'Ticket Request',
TicketStatusId = DrpStatus.Selected.ID
)
},
ForAll(
Sequence(CountRows(records)),
Patch(
Last(
FirstN(
records,
Value
)
),
{RowNo: Value}
)
)
)
so far so good...
But now I want to add another variable to the "records"....
That variable can be added as a label to the gallery normally with LookUp(Events,ID=ThisItem.EventId,EventDateandTime)
But I want to add it to my "records" instead in the items property...
I added the 2 lines that I think would make this work...but it was a guess...because in my prior examples I wasn't doing a sequence statement too.
and here's the text version of that...
With(
{
records: Filter(
'Ticket Request',
TicketStatusId = DrpStatus.Selected.ID
),
_eDate: LookUp(Events,ID=records.EventId).'Event Date and Time'
},
ForAll(
Sequence(CountRows(records)),
Patch(
Last(
FirstN(
records,
Value
)
),
{
RowNo: Value,
EventDate: _eDate
}
)
)
)
It's my day for learning today obviously and the wrench has been thrown because I want to do the sequence thing too.
Solved! Go to Solution.
Please consider changing your Formula to the following:
With(
{
records:
AddColumns(
Filter(
'Ticket Request',
TicketStatusId = DrpStatus.Selected.ID
) As _item,
"_eDate", LookUp(Events, ID=_item.EventId).'Event Date and Time'
)
},
ForAll(
Sequence(CountRows(records)),
Patch(
Last(
FirstN(
records,
Value
)
),
{
RowNo: Value,
}
)
)
)
I hope this is helpful for you.
Please consider changing your Formula to the following:
With(
{
records:
AddColumns(
Filter(
'Ticket Request',
TicketStatusId = DrpStatus.Selected.ID
) As _item,
"_eDate", LookUp(Events, ID=_item.EventId).'Event Date and Time'
)
},
ForAll(
Sequence(CountRows(records)),
Patch(
Last(
FirstN(
records,
Value
)
),
{
RowNo: Value,
}
)
)
)
I hope this is helpful for you.
You make it seem so simple Randy. Nice video by the way on alternating rows.
Thanks much!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
71 | |
50 | |
41 | |
30 |
User | Count |
---|---|
254 | |
113 | |
95 | |
91 | |
76 |