CODEWITHSUNDEEP
filterpowerappspowerapps-canvascollectforall
Christodoulos Tylliros
Christodoulos Tylliros

Reputation: 1

PowerApps(CanvasApp) ForAll with collections

I am trying to filter a table based on the reocrds of a column of another table. For example here the values of the column ID of the RequestIDsTest are the same as some of the values of the RequestLogs table. i want to filter |RequestLogs based on the id of RequestIDsTest and store all the records in the other collection called FilteredRequestLogs.

ClearCollect( RequestIDsTest, ShowColumns( Filter(Requests, UUID = txtTitle_1.Value), ID ) ); Clear(FilteredRequestLogs); ForAll( Sequence(CountRows(RequestIDsTest)), Collect(FilteredRequestLogs, Filter(RequestLogs,RequestID=ThisRecord.ID) ) );

Upvotes: 0

Views: 21

Answers (0)

Related Questions