Unanswered

Remove Current user form a multi-selection person/group field

(0) Share

Report

Posted on by Power_nub-it

Dear Community,

i want to remove the current User from a multi-selection person/group field (Confirmation_is_requested_from) in Sharepoint and Patch the User to a other field (Confirmation_exists_from) and after that, i want alle the Person who didn't confirmed to be write in the field (Confirmation_pending_from) and i dont know how to do that.

The Szeanrio:
After a file is uploaded to a sharepoint library, the manager can enter people (multi-select) who need to read that file (PDFs only). For this purpose there is an app that shows the user all the files assigned for him. He can read the files in a pdw viewer (works perfectly). The user can then select the files (checkbox) and confirm. Now I want the person to be deleted from the sharepoint list and added to the other field (as wrote above).

Previously, I saved the sharepint list as a collection.

When the app starts:

Set(pdfViewerVisible; false);;
ClearCollect(All_Documents; Dokumente_Arbeitssicherheit);;

OnCheck:
Collect(ReadedFiles; ThisItem)

OnUnCheck:
Remove(ReadedFiles; ThisItem)

Sharepoint libCollections

Checkbox and confirm button

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Power_nub-it

To remove a person (the current person) you can use the following:

With({_record: LookUp(yourDataSource, ID=theRecordIDYouWant), _userEmail: User().Email}, UpdateIf(yourDataSource, ID=theRecordIDYouWant, {Confirmation_is_requested_from: ForAll(Filter(_record.Confirmation_is_requested_from, !(Email = _userEmail)), ThisItem ) } ) )

Now...I'm a little confused on your scenario. You mention removing the person from Confirmation_is_requested_from and putting them to Confirmation_exists_from and then all the other people in that column into Confirmation_pending_from.

My confusion is...it sounds like your end result is the Confirmation_is_requested_from column will be empty, so why would you want to remove a person if the end result is that the column is empty...or have I misunderstood?

I hope this is helpful for you.

Was this reply helpful? Yes No
Power_nub-it 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes

Oh, your right sry. But first of all, thx for your reply.

And what i wanted to do this:

All employees are entered in Confirmation_is_requested_from.

When someone has read and confirmed it, the employee is entered in Confirmation_exists_from
All the rest are transferred to Confirmation_pending_from. -> look at Dok 2.pdf

So how can I loop this for all selected documents/items in ReadedFiles?

Was this reply helpful? Yes No
gmbeee 87 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

I’m trying to use this concept to remove the current user from a multi person field. However I’m getting an error:

Invalid Argument. Expecting a table value, but of a different Schema.

I can’t figure it out. Thanks.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@gmbeee

What is the formula you are trying at this point and where do you have the formula?

Was this reply helpful? Yes No