cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vangala
Frequent Visitor

Issues with Powerapps

Question : 1

I'm trying to retrive the Sharepoint Groups in Powerapps using Office 365 Groups Connector, But i'm unable to view the list of groups in My powerapp.

Below is the code i'm trying using Dropdown in items.

Office365Groups.ListOwnedGroups().value 

Can anyone please suggest how do we display the Sharepoint Groups in powerapps?

Question : 2 

Can we make the Combobox showing the Empty values as default , but when we search with text in the combobox it should dsiplay the values based on Text entered. How is this possible in Powerapps ?

 

Question : 3

How do we  launch the Sharepoint site load in the Same Tab/ Same Windiow when clicking on some button.

I'm trying with launch function like Launch("URL"). But i wanted to be load in the same tab.

How is this possible ?

 

It would be great, if anyone could suggest the best ways to achieve the above requirements.

Thanks.

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Vangala 

Based on what you told me via message, in a very 'hardcoded' way for simplicity sake:

 

1. In your dropdown source, add a restrictionColumn where you indicate Y or N

2. In the OnLoad of the app, Set a variable (RestrictedUser) to True if the user is not to have access to the whole set (based on Office365Group membership)

3. In the Items property of that dropdown, use a Conditional Filter formula, such as If(RestrictedUser,Filter('mysource',restrictrionColumn="Y"),'mysource')

View solution in original post

25 REPLIES 25

As per your Question 1, don't put the ".value" at the end.

 

When I test this on my side, that's what makes the difference between a combo box that contains list of items or is empty.

Hi PowerDiver, 

 

Thanks for your Reply.

I tried with removing the ".value" at the end, i don't see the list of group names in the dropdown.

I'm getting this value in dropdown : https://graph.microsoft..com/v1.0/$metadata#groups

 

Could you please suggest what i might be missing here ?

 

Thanks.

Sorry, in fact, the '.value' is fine... it's the value property you have to set to the description field (for example)

 

 

2019-04-15_09-29-06.jpg

 

As for your question number 2, that is pretty much native to a Combo Box, just make sure you define the fields you want to search on in the SearchFields property.

 

2019-04-15_09-36-22.jpg

Hi,

 

For Question 1 :

I tried with dropdown items value to  Office365Groups.ListOwnedGroups().value and setted the value to "Description"  in the right pane.

 

It is not displaying any values in the dropdown, it is showing empty.

 

 

Hello Vangala,

 

I would say, add a button in your app to test out the results you get for the list of groups and put this script at the OnSelect Event:

 

Collect(
listGroup,
Office365Groups.ListOwnedGroups()
);
Collect(
listGroupValue,
Office365Groups.ListOwnedGroups().value
)

 

Then go browse the Collections (in the File menu) and see if you actually have values defined.

 

Hi Powerdriver,

 

Fort Question 2:

It's not about searching the fields, i want to display empty combobox as default as shown below in powerapps. 

But when we enter some text in combobox, it should displaythe values based on text entered.

 

Please see the attached screenshot.

 

Thanks.

 

 

So if I understand correctly, what you want is the list to be empty when there's no text in the search box ?

Contrary to what we get by default (as shown below), right?

2019-04-15_09-49-33.jpg2019-04-15_09-49-46.jpg

yes that's right!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,623)