Answered

How to restrict Submit form dropdown options depending on the user

(0) Share

Report

Posted on by AndrewSy

I'm building a fairly basic app that will be used internally within Microsoft365. I've generated a form to post new data to an existing Sharepoint that already has data in it created by different users. How do I restrict users so they are only able to see the items that only they themselves have created in the dropdown, instead of a comprehensive list of all items.

I've tried adding Filter(Timesheets,'Created By'.Email = User().Email) to the items field but it keeps disappearing even though I've unlocked the data card. What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Michael E. Gernaey 53,968 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@AndrewSy

Hi, Love that you are using the filter, good work honestly, but you would have to share the whole screen so we can better see what else is on the screen that might be driving that DataCard. Is the DataSource set to TimeSheets?

Can you show it typed on and when does it disappear?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
AndrewSy 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for replying. I've solved the issue of changes reverting, turns out that I didn't unlock the card though I thought I did. I'm trying to concatenate filter with choices but it throws an error. I'm very new to power apps.

Was this reply helpful? Yes No
Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AndrewSy

Can you explain why you are trying to concat that stuff together (and no that would never work). Choices(*) is essentially a loader transcribing the Choice. by making an Array.

Was this reply helpful? Yes No
AndrewSy 31 on at

Like
a
(0)

Report
Copy link

Link copied!

As it stands the choices dropdown lists different projects made by different people on PowerApps within my company, I need to restrict those choices and make it so that every person only sees their own projects in the dropdown

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @AndrewSy

Ok then what you need to do is Filter the actual Choice Column (not use the Choice).

What I mean is. Lets say you have a table and one of the columns is a value FROM this Choice.
And each row is assigned to a user

What you want is to Filter that Table, by whatever column you can filter using that persons info, then use the Choice Column itself to build a Unique (Distinct) list of Choices that has been used by that person AKA Projects.

What you are doing is simply using the Choice as a "thing" to list the total possible project selections, your not actually working on this persons lists of SELECTED choice values (aka projects).

Since its 2am I am going to share this versus typing more. Feel free to response and I will look at it later
Solved: Re: Distinct Choices - Power Platform Community (microsoft.com)

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
AndrewSy 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much! You are a life saver 🙂

Was this reply helpful? Yes No