Unanswered

Updating collection column if collection contains record with similiar column 2

(0) Share

Report

Posted on by InfLabAutomate

Hello,
I can't google it properly and I've run out of ideas.

I have a table Categories with column Name and TreePath. TreePath is created with ':' and parent record Names.
For example:

Name	TreePath
Category1	Category1
Category2	Category1:Category2
Category3	Category1:Category3
Category4	Category1:Category3:Category4

I want to update collection's column HasChildren - so I need to check if collection has any record with TreePath like Name, but not equal (well, I might be wrong).

I tried to use:

UpdateIf( Categories,
CountRows(Filter(Categories, Find(Name,TreePath))) > 1,
{ HasChildren: true} )

But it takes Name and TreePath from the same record.
Do you have any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Is this something you are looking for?

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
@InfLabAutomate ,

If it is collection, we don't worry about the delegation warning. Can you try:

UpdateIf( Categories, !IsBlank( LookUp(Categories,Name in TreePath && !(Name=TreePath) && !(Right(TreePath,Len(Name))=Name) ), {HasChildren:true} )

I put three conditions:

1. Name to be in TreePath

2. Name not equal with TreePath

3. Last TreePath not to be Name.

Was this reply helpful? Yes No
InfLabAutomate 4 on at

Like (0)

Report
Copy link

Link copied!

Almost, Category2.HasChildren would be false - there's one TreePath with its Name and it's itself.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
Ok let's change it a little bit:

UpdateIf( Categories, !IsBlank( LookUp(Categories,Name in TreePath && !(Name=TreePath) && !(Last(Split(TreePath,":")).Result=Name) ), {HasChildren:true} )

Try this please !

Was this reply helpful? Yes No
InfLabAutomate 4 on at

Like (0)

Report
Copy link

Link copied!

It looked good, but unfortunately it makes all of them false.

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
UpdateIf( Categories, !IsEmpty( LookUp(Categories,Name in TreePath && !(Name=TreePath) && !(Last(Split(TreePath,":")).Result=Name) ), {HasChildren:true} )

Was this reply helpful? Yes No