How to hide approver name same as requester's name?

(0) Share

Report

Posted on by usaman45

314

Hi,

I have two Sharepoint lists. One is to store the request record and another one is to store the approvers list.

The main list's approver name column is link to the approvers list.

But, there is an issue when user also as approver. How can I hide in the selection for approver? It should not allow she/he to select herself or himself for approver from the selections.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

EricBLott 248 on at

Like
a
(0)

Report
Copy link

Link copied!
Are you doing this in Power Apps, or are you asking whether this can be done in SharePoint itself?
If in Power Apps, in the DropDown Item property, you can use something like this (assuming you're using email as the identifier):
Filter(YourSharePointList,Not(yourApproverColumn = User().Email))

Was this reply helpful? Yes No
usaman45 314 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks. but not working. It did not display anything for selection.
The Item formula I had in my COMBO BOX show below:
Choices([@'Special Request'].Approver)

Was this reply helpful? Yes No
Verified answer

EricBLott 248 on at

Like
a
(0)

Report
Copy link

Link copied!
Try this
Filter(Choices([@'Special Request'].Approver),Value <> User().Email)
Again, assuming you're using email. If not, we'll need a way to associate the choices with the current user.
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No