Search Question in "joined collection"

(0) Share

Report

Posted on by LRVinNC

2,297

I have "joined" two lists into a single collection with:

ClearCollect(MergedLLs, AddColumns(LessonsLearned,"CE",LookUp(Engagements,Title = PSAId)))

This works great and yields the expected result with the entire Engagements list added under "CE".

But now I need to be able to execute a search that includes columns in both the primary and the joined portions of the collection. No problem including the columns in the primary portion, but when I try to use CE.CustomerName to access a column in the joined portion I get a column does not exist error on "CE.CustomerName".

If(!IsBlank(tiSearchString),Search(MergedLLs,tiSearchString.Text,"Title","Description","BestPractice","CE.CustomerName"))

Is it possible to search on these added columns?

Lori

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RezaDorrani 12,145 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @LRVinNC

No it will not be possible using the Search function

CE is a record type column

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LRVinNC

Will the GroupBy() function pull out the data you want from your collection. I have used this function and the Ungroup() function to reshape data.

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks to you both. @RezaDorrani I was afraid that was the case.

@Drrickryp If I was just taking the data into a gallery, it might, but in this case I need to hit the collection with a big, hairy search so I think I need to have all the columns in the collection.

So, to get around this, I'm having to take each column into the collection individually, but that currently means repeating my lookup for each column. This works and then I am able to use all the columns I need to in the search.

But since I need to do this for all the records in the LL1 collection, I haven't come up with a good way to do the lookup once and use the result for all the columns I need to put through the AddColumns. So I'm concerned with performance once I load all the data in both the LessonsLearned and the Engagements lists.

ClearCollect(LL1,LessonsLearned); ClearCollect(LLs, AddColumns(LL1, "EName",LookUp(Engagements,Title = PSAid ).EngagementName, "CName",LookUp(Engagements,Title = PSAid ).CustomerName, "Region",LookUp(Engagements,Title = PSAid ).EngagementRegion, "Area",LookUp(Engagements,Title = PSAid ).EngagementArea, "Billable",LookUp(Engagements,Title = PSAid ).BillableConsultingFlag, "HIPStatus",LookUp(Engagements,Title = PSAid ).EngagementHIPFlag, "EngagementStatus",LookUp(Engagements,Title = PSAid).EngagementStatus, "ColorStatus",LookUp(Engagements,Title = PSAid ).EngagementColorStatus, "ContractType",LookUp(Engagements,Title = PSAid ).EngagementContractType, "StartDate",LookUp(Engagements,Title = PSAid ).EngagementActualStartDate, "CloseDate",LookUp(Engagements,Title = PSAid ).EngagementActualCloseDate));

Suggestions welcomed on making this more efficient.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LRVinNC I'm going to bump this so the community can provide some assistance.

@Anonymous

Was this reply helpful? Yes No