Answered

Updating all records where people field doesn't match

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I have a gallery (GalleryHome) which is filtered to display records from the data source (Records) and created by the logged in user.

All the records have a Supervisor column which is a multi-select people column.

I am assuming that the Supervisor field of the last record in this gallery is the most up-to-date one and want to update all other records where there isn't a match at the click of a button.

So even if the last supervisor field is 'Person A', 'Person B' and there is another record which is 'Person B', 'Person A', that second record should still be identified as not a match and be updated.

I guess I can use a ForAll and UpdateIf for the update, but the problem is comparing the columns when they are considered tables. I've tried creating both a variable and a collection using Last(GalleryHome.AllItems.AcademicSupervisor) but the problem remains of creating a condition where they can be compared or records filtered.

Any ideas please?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try this Filter() to get at the records with a particular user name in them:

Filter(GalleryHome.AllItems, Label1.Text in // This label contains your name search string AcademicSupervisor.DisplayName // AcademicSupervisor is a people type column )
You can substitute User().FullName for Label1.Text to query for the currently logged in user, or even hard code a search string such as "Richard"

Is that what you are after?

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Oh, and for a Person column with multiple choices enabled, use this:

Filter(GalleryHome.AllItems, Label1.Text in // This label contains your name search string Concat(AcademicSupervisor.DisplayName, DisplayName) // AcademicSupervisor is a multi-people type column )

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks @BCLS776 . I knew about the concat for multi-select people fields but had a complete brain block yesterday!
This is the formula I used and it has worked:
Set(varLast, Last(GalleryHome.AllItems.AcademicSupervisor)); ClearCollect(colToUpdate, Filter(GalleryHome.AllItems, Not(Concat(varLast.AcademicSupervisor, Claims, "; ") = Concat(AcademicSupervisor, Claims, "; ")))); ForAll(RenameColumns(colToUpdate, "ID", "NewID"), UpdateIf(Records, ID = NewID, Last(GalleryHome.AllItems.AcademicSupervisor)))

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Wonderful! If your problem is solved, could you "accept a solution" so that others can benefit? It helps make the topic more searchable.

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ，

Glad that you have solved your issue. I will mark you reply as a solution so that other community members who stuck with the same question can directly see your answer.

Best regards,

Allen

Was this reply helpful? Yes No