ForAll Sequence With and Lookup all at the same time???

[sasrsc1966]

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. 

[RandyHayes · Accepted solution]

@sasrsc1966 

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.

[sasrsc1966]

You make it seem so simple Randy. Nice video by the way on alternating rows.

[RandyHayes]

@sasrsc1966 

Thanks much!