cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Radoslavov
Continued Contributor
Continued Contributor

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
Continued Contributor
Continued Contributor

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
Skilled Sharer
Skilled Sharer

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

Radoslavov
Continued Contributor
Continued Contributor

@Silvester not working, has an error message 

Radoslavov_0-1651146201321.png

the function Choices has some invalid arguments .

Silvester
Skilled Sharer
Skilled Sharer

alright. What is the name of your Sp List?

 

Radoslavov
Continued Contributor
Continued Contributor

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
Skilled Sharer
Skilled Sharer

Awesome!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,202)