Unanswered

Update Person field in Sharepoint list

(0) Share

Report

Posted on by stephenjcarr

138

I'm creating a holiday request tool and I'm trying to create an option for managers to set a delegate approver for requests.

I have 2 Comboboxes that get the person from the "Approver" and "Delegated Approver" columns in the Sharepoint using this:

ComboBox1 Items:
Distinct('Holiday Request Tool'.Approver, Approver.DisplayName)

ComboBox2 Items:
Distinct('Holiday Request Tool'.'Delegated Approver', 'Delegated Approver'.DisplayName)

I would like to add code to a button that will find all entries in the Sharepoint that match the Approver in ComboBox1 and updates the Delegated Approver field to the person in ComboBox2.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

ComboBox1 Items:
Distinct('Holiday Request Tool'.Approver, Approver.DisplayName)

ComboBox2 Items:
Distinct('Holiday Request Tool'.'Delegated Approver', 'Delegated Approver'.DisplayName)

This formula are working?

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @developerAJ Yes these formulas are working. How do i add a button that will find all entries in the Sharepoint that match the Approver in ComboBox1 and update the Delegated Approver SP field to the person selected in ComboBox2?

Thanks

Thanks

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

ComboBox1 Items:
Distinct('Holiday Request Tool', Approver.DisplayName)

ComboBox2 Items:
Distinct(Filter( 'Holiday Request Tool',Approver.DisplayName=ComboBox1.Selected.Value), 'Delegated Approver'.DisplayName)
Please click Accept as solution and Thumbs Up. 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.
You can connect with me on LinkedIn

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like
a
(0)

Report
Copy link

Link copied!

@developerAJ What do I add to the button please?

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like
a
(0)

Report
Copy link

Link copied!

I need a button that will update the Delegated Approvers field in the sharepoint if ComboBox2 is changed to different person

Was this reply helpful? Yes No
developerAJ 4,763 on at

Like
a
(0)

Report
Copy link

Link copied!

if you are using form submitform(formname) will do

Was this reply helpful? Yes No
stephenjcarr 138 on at

Like
a
(0)

Report
Copy link

Link copied!

These comboboxes arent on a form. I'm not looking to update a single Sharepoint entry.

I need code that will find all sharepoint entries where the Person in the Approver column matches the Person in ComboBox1, and update all of these entries "Delegated Approver" column with the Person selected in ComboBox2.

For example. If CombBox1 has "John Smith" selected and ComboBox2 has "Jane Smith" selected, find all entries on the sharepoint where "John Smith" is listed in the Approver column and add "Jane Smith" to the Delegated approvers column for those entries.

Thanks!

Was this reply helpful? Yes No