cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Radoslavov
Skilled Sharer
Skilled Sharer

Get SharePoint choice value

Hi all, I'm struggling with some formula in Power Apps and I was hoping you can give me help with it. 

I have a script that load a list of records you've created in SPO.

The edit page gives you the options to change some attributes.

What I'm trying is for the dropdown options in PA by default to show you the option that is set in SPO list.

I'm already using distinct function (Distinct('Team requests', TeamType)) to show only the unique Team types, but i want the user to see as default option the one in SPO and only if he needs to change it here

Radoslavov_0-1651137827740.png Radoslavov_1-1651137993892.png

Radoslavov_2-1651138026828.png

Any suggestion how should i further the distinct function. I'm guessing it will be something like Distinct(Filter.

 

Thank you for the help in advance.

 

Regards,

Kiril

1 ACCEPTED SOLUTION

Accepted Solutions
Radoslavov
Skilled Sharer
Skilled Sharer

I fixed it actually by collecting the team details into a global variable upon item select. and then adding for DefaultSelectedItems the following { Value :  VarRecord.TeaType}.

View solution in original post

5 REPLIES 5
Silvester
Super User
Super User

Set the item function to 

Choices([@Team requests].TeamType)


Give a thumbs up if you find it interesting and accepts as a solution if it works for you

Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the thread and so other members of the community can find it easily.
Radoslavov
Skilled Sharer
Skilled Sharer

@Silvester not working, has an error message 

Radoslavov_0-1651146201321.png

the function Choices has some invalid arguments .

Silvester
Super User
Super User

alright. What is the name of your Sp List?

 

Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the thread and so other members of the community can find it easily.
Radoslavov
Skilled Sharer
Skilled Sharer

I fixed it actually by collecting the team details into a global variable upon item select. and then adding for DefaultSelectedItems the following { Value :  VarRecord.TeaType}.

Silvester
Super User
Super User

Awesome!

Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the thread and so other members of the community can find it easily.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,062)