Linking choice/dropdown boxes in Power Apps/Sharepoint

(0) Share

Report

Posted on by bp9

This should be relatively easy I would think but I can't seem to find an answer anywhere that works.

I am building an onboarding approval app and this is the flow and what I'm looking to achieve.

1. Manager fills out a form requesting a user to be setup in our system. The form get's emailed to HR via deep link.

2. HR opens the link which brings them back to the form in edit mode so they can make any necessary changes.

3. The form has a drop down for HR to approve or reject the form. If approved, there is another deep link that goes to IT which again goes back to the form. (These are separate forms on separate screens. There are 3, one for the manager to fill out, one for HR and one for IT)

4. There is a sharepoint list column for "HR Approval Status" and "IT Approval Status"

What I am looking for is when the HR Approval Status choice/dropdown is set to "Approved" and the HR form is submitted, I would like the IT Approval Status to be set to "Pending". Looking for a way to either link the datacardvalue's or to use a calculated value in sharepoint.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @bp9 ,

One way is at the Form OnSuccess

If( Self.LastSubmit.'HR Approval Status' = "Approved", Patch( SPListName, { ID: Self.LastSubmit.ID, 'IT Approval Status': "Pending" } ) )

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

Was this reply helpful? Yes No
bp9 8 on at

Like (0)

Report

Tried that but no luck. I've tried the Patch option previously but cannot get it working with my form for some reason and I can't figure out why.

Was this reply helpful? Yes No
bp9 8 on at

Like (0)

Report

I fixed the error on the second part of the screenshot above. It's the = error that I keep getting that I can't figure out.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@bp9 ,

I am suspecting you have a Choice column there

If( Self.LastSubmit.'HR Approval Status'.Value = "Approved", Patch( SPListName, { ID: Self.LastSubmit.ID, 'IT Approval Status': {Value: "Pending"} } ) )

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

Was this reply helpful? Yes No
bp9 8 on at

Like (0)

Report

I was able to figure out what I was doing wrong. The drop downs I was using were inside the form. Once I removed the dropdowns from the form and created them in the app, patching worked.

thanks for your assistance.

Was this reply helpful? Yes No