Answered

Can this be combined into one statement...

(0) Share

Report

Posted on by sasrsc1966

219

it works but I'm wondering if it can be combined into one statement...
In this case 'Seat Capacity' already exists in Events
But I need to calculated the available seats AFTER adding the ApprovedCount.
````

Set(
EventListingWithCounts,
ForAll(
Events As _e,
Patch(
_e,
With(
{
_rec: LookUp(
TicketRequestCounts,
EventId = _e.ID
)
},
{
ApprovedCount: _rec.CountApproved,
PendingCount: _rec.CountPending,
WaitlistCount: _rec.CountWaitlisted
}
)
)
)
);
ClearCollect(xxxx,AddColumns(EventListingWithCounts,"AvailableCount",'Seat Capacity'-ApprovedCount))

````
Do you really think that combining it into one statement is more beneficial overall?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sasrsc1966 ,

Not quite one statement - see the below, but I do not know where you are getting 'Seat Capacity' from.

Clear(xxxx); ForAll( Events As _e, With( { _rec: LookUp( TicketRequestCounts, EventId = _e.ID ) }, Collect( xxxx, { ApprovedCount: _rec.CountApproved, PendingCount: _rec.CountPending, WaitlistCount: _rec.CountWaitlisted AvailableCount:'Seat Capacity' - _rec.CountApproved } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
sasrsc1966 219 on at

Like
a
(0)

Report
Copy link

Link copied!

Seat Capacity comes from the existing Events table (which is the master table).
The grouped by items are providing totals for various things from the TicketRequestsCount table.
I'm joining them with this for all patch stmt.
In your example will it read the value of the 'Seat Capacity' from the Events table? Hmmm?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sasrsc1966 ,

That is why I asked - you had not referred to this item in relation to the With() statement I cannot see your model or data, but try this

Clear(xxxx); ForAll( Events As _e, With( { _rec: LookUp( TicketRequestCounts, EventId = _e.ID ) }, Collect( xxxx, { ApprovedCount: _rec.CountApproved, PendingCount: _rec.CountPending, WaitlistCount: _rec.CountWaitlisted AvailableCount:_e.'Seat Capacity' - _rec.CountApproved } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No