Unanswered

Lookup in ForAll referring to first record in collection only

(0) Share

Report

Posted on by cfidler72

I'm building an app using Dataverse as the source of information. I have created a collection that captures records that has missing data and is working fine:

ClearCollect(colMissingSurveyData,AddColumns(Filter(Surveys_1,IsBlank('Client Name'.Name)),"SurveyID",ThisRecord.'Survey Name'));

Produces below collection:

I then want to use the cr500_clientcode field to create a new collection of data, which includes the Client Name. I am trying to ascertain this using LookUp:

ClearCollect(colTemp, ForAll(colMissingSurveyData, {ID: SurveyID, ClientID: cr500_clientcode, Client: LookUp(Clients,'Client Code' = cr500_clientcode, Name)}))

The collection is created but it is only including the Client based upon the client code of the first record:

I have seen other posts talking about using As and ThisRecord in my formula, and have tried these but with no luck.

I'm sure the answer is simple, but can anyone help me with what I'm missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @cfidler72 ,

Try this (I am assuming the field name is correct here)

ClearCollect( colTemp, Ungroup( colMissingSurveyData, "ClientName" ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
cfidler72 17 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz , unfortunately it return a collection with no records in it

Was this reply helpful? Yes No
WarrenBelz 153,789 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@cfidler72 ,

Not sure why - it works perfectly on any collection and spits the record with the table field (I assume ClientName is a Table field) into individual added fields and record. Maybe it is the Dataverse -generated structure as I have only tested it on SharePoint. Sorry, I have not further suggestions.

Was this reply helpful? Yes No