LookUp different collections and update column info

(0) Share

Report

Posted on by Jmnavi

Hello All,

Here is the thing.

I collected one list of documents (teste1) and added one column named issued with initial data "No".

Also collected one filtered document library (teste2) where I have the status of the document. If they already are on revision 0, it means it was issued. Note that on this library there are just the documents issued and not the entire list of documents.

So far, so good...

My idea is to check which documents have been issued on teste2 and update the columnn Issued with the data "Yes" on teste2.

The way I'm trying to compare is by the document code. If they match; it means that the document has been issued and the column should be updated. The point here is that on Library, the document code is a lookup of the document list and I thint that maybe this is the reason why I'm not suceeding in doing so through the formula below:

ClearCollect(teste1;AddColumns('B - Lista de Documentos de Saída';"Issued";"No"));;
ClearCollect(teste2;Filter('B1 - Documentação de Saída';REVISION="0"));;
UpdateIf(teste1;ForAll(teste2;LookUp(teste2;teste2[@LD].Value=teste1[@Title];true));{Issued:"Yes"})

Prints of the collections:

Would you guys know someway to solve it?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jmnavi ,

Is the following your requirement?
Change the Issued column of the records in teste1 that meet the following criteria to "Yes":
1)"revision=0" in 'B1 - Documentação de Saída';
2)Find records meet "Title.Value=LD.Value" in Table 2 according the record that meets the previous criteria.

The question is what are the data types stored in your LD column and Title column. From your screenshot, they are not the same type, if "Registro" means "Record".

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Jmnavi 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @v-mengmli-msft

Thanks for your reply.
Title data comes from a sharepoint list. It is a list of documents that I use on different sharepoint libraries through lookup.
LD data is the lookup of this list of documents. That's why it returns as register on the collection.

Was this reply helpful? Yes No
Verified answer

Jmnavi 51 on at

Like
a
(0)

Report
Copy link

Link copied!

Found the sollution on this topic:
Solved: Re: comparing two collections and update - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No