Filter Dropdown based on User (Variable)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

How can I get my drop down to show certain items based on a collection or (preferably) a Choices Column from a Sharepoint list based on the variable "is user___" without this awful duplication. Because in my scenario multiple people will be in multiple groups.

Thanks!

Here's code to copy paste for my collection (column name i would rather use is called Status):
Clear(StatusDropDown);

If(isuserinSPGroupN11B4, Collect(StatusDropDown," Signature Pending"," Returned to Submitter", "Cancelled" ));
If(isuserinSPGroupN13A, Collect(StatusDropDown, "Manager Approved","Cancelled"));
If(isuserinSPGroupCommanderAccess, Collect(StatusDropDown, "Signature Pending"," Returned to Submitter", "Cancelled" ," Manager Approved",));

tagging @RandyHayes just because 🙂

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Skip all the collections!!

Change your Items formula to the following:

Filter( Table({Value: "Signature Pending", en: isuserinSPGroupN11B4 || isuserinSPGroupCommanderAccess}, {Value: "Returned to Submitter", en: isuserinSPGroupN11B4 || isuserinSPGroupCommanderAccess}, {Value: "Cancelled", en: isuserinSPGroupN11B4 || isuserinSPGroupCommanderAccess || isuserinSPGroupN13A}, {Value: "Manager Approved", en: isuserinSPGroupN13A || isuserinSPGroupCommanderAccess} ), en )

This will give you what you want without all the hassle of collections, and behavioral action formulas.

I hope this is helpful for you. (just because 🤣)