web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps ForAll and Collections...

Power Apps

Answered

ForAll and Collections from Galleries

(0) Share

Report

Report

Posted on by dkayt

517

Hi All,

the context:

Gallery2 (G2 - with text inputs) includes Gallery3 (G3 - with text inputs).

I want to collect both galleries in one collection.

Something like that:

The issue :

I can collect with the first ForAll() - colTicket but the second ForAll() - colSubTicket is empty.

Does anyone know how I can improve my code?

Thanks, dKayt

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

Where are you calling this code? Do you see any error messages?

Was this reply helpful? Yes No
dkayt 517 on at

Like (0)

Report
Copy link

Link copied!

Hey,

this code will be triggered from a button out of the gallery and I receive no error message.

Was this reply helpful? Yes No
Verified answer

dkayt 517 on at

Like (1)

Report
Copy link

Link copied!
I do resolve it like this :

CREATE MAIN TICKET
-----------------------------

ClearCollect( colTicket, { ID: If( IsBlank(Last(Sort(colTicketData, ID,SortOrder.Ascending)).ID), 100, Last(Sort(colTicketData, ID, SortOrder.Ascending)).ID + 100 ), SubID: 0, Unit: inp_Unit_2.Text, TicketNumber: TicketNumber_2.Text } ); Collect(colTicketData, Sort(colTicket, ID, SortOrder.Ascending))

SUB TICKET
----------------

ClearCollect( colTicket, { ID: ThisItem.ID, SubID: If( Last(Sort(colTicketData, ID, SortOrder.Ascending)).SubID = 0, ThisItem.ID + 1, Last(Sort(colTicketData, ID, SortOrder.Ascending)).SubID + 1 ), Unit: inp_Unit_2.Text, TicketNumber: TicketNumber_2.Text } ); Collect(colTicketData, Sort(colTicket, ID, SortOrder.Ascending))

SAVE
-------

If( IsError( ForAll( Gallery2_1.AllItems As G2, Patch( TicketList, Defaults(TicketList), { Unit: G2.inp_Unit_2.Text, TicketNumber: G2.TicketNumber_2.Text } ) ) ), NotificationType.Error, NotificationType.Success ); Clear(colTicketData);

Was this reply helpful? Yes No

Join the conversation