Filter Dropdown based on User (Variable)

[Highwaywoman]

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 🙂

[RandyHayes · Accepted solution]

@Highwaywoman 

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 🤣)