Deletes all values in People Column- Sharepoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,
I cannot seem to figure out why this code deletes all the values in Parent Column . I need to just delete the dropdown selected by the user and retain its old values.

ClearCollect(
colAllPersons,
ForAll(
Gallery1.Selected.Parents,
{Parents: Dropdown6.SelectedText.Value}
));

Remove(
colAllPersons,
Filter(
colAllPersons,
Parents = Dropdown6.SelectedText.Value));

Patch(
TestAccessList,
LookUp(
TestAccessList,
'Test Project1'="Dev1"
),
{
Parents: ForAll(
colAllPersons,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: Dropdown6.SelectedText.Value,
Department: "",
DisplayName: "",
Email: Dropdown6.SelectedText.Value,
JobTitle: "",
Picture: ""
}
)
}
)
Here's the sharepoint im trying to update:
TestAccess

Categories:

Building Power Apps

All responses (1)

Answers (0)

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

The only relevant code is this

Remove( colAllPersons, Filter( colAllPersons, Parents = Dropdown6.SelectedText.Value ) );

which will remove all records from colAllPersons where the Parent column is equal to the value selected in Dropdown6 - is this not what you want to do ?

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.

MVP (Business Applications) Visit my blog Practical Power Apps