Is it possible to allow a specific user to see all items of a dropdown (example below) but prevent him from selecting specific items (Such Step1, Step2 and Step3)
Any suggestion or help would be appreciated.
In a very simple case, we can hardcode by setting Items property of dropdown to
If(RestrictedUserCondition, ["Step1","Step4"],["Step1", "Step2","Step3", "Step4"])
If the List gets from Sharepoint or Any other data source then
Filter the list when the page Onvisible
ClearCollect( AllStatuses, Choices(SPList.ChoiceColumn) ); If( User().Email in (Concat(SPList.PersonColumn,PersonColumn.Email &",")), RemoveIf( AllStatuses, (Value = "New" || Value = "Completed") //New and Completed will be removed ) )
ClearCollect( AllStatuses, Choices(IssueTracker.Status) ); If( User().Email in (Concat(IssueTracker.'Assigned to','Assigned to'.Email &",")), RemoveIf( AllStatuses, (Value = "New" || Value = "Completed") ) )
Now Collection "AllStatuses" has restricted based on the user list which can be defined in Sharepoint
Set the Items property of dropdown to
Thank you for the answer.
The suggested solution would either remove or list the item in the dropdown depending on the connected user,
Would it be able to list all items whoever was connected and apply the restriction on the selection, for example User1 would see all items but should not be able to select some, is it possible to do this in Power Apps?
Thank you in advance.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.
Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.
The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
We are excited to announce a new way to share your ideas for Power Apps!