Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Can't find the SharePointIntegration control

I originally created my app from the page, and used SharePoint as a data source, pulling data from 2 different SharePoint Lists into the app. However, I need to filter the data from one list (Gallery) based on the selected data from the other list (Form). I found a tutorial for this but the filter formula references the SharePointIntegration control. In the tutorial, which was made in 2018, his Power Apps editor interface looks signifantly different from mine, and he has the SharePointIntegration control in his Tree view.


Where is this SharePointIntegration control and how do I reference it, or do I need to?


The filter formula referenced in the tutorial is exactly this: 


Filter(Comments, Title="Equipment Request", ItemID=SharePointIntegration.SelectedListItemID)


And I adapted it for my Form and Gallery like this:


Filter('CSA App Comments', 'Assessment ID'='CSAF Requests'.'Assessment ID', 'Assessment ID'=SharePointIntegration.SelectedListItemID)



But it's just not working! Both Assessment ID fields are numeric (from the SharePoint Lists). What am I missing here? Do I need to reference the datacard value instead? How did the developer in the tutorial get it to work without that?


Here's a link to the tutorial I'm referring to: 




Community Support
Community Support

Hi @Katrina_Frigeri 


Currently, the SharePoint integration appears when you customize a SharePoint form using PowerApps: 

Annotation 2020-06-22 182912.jpg

I created an application from scratch selecting SharePoint as data source and the SharePointIntegration doesn't appear in those scenarios.


Best Regards


If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution
Super User
Super User

Hi @Katrina_Frigeri ,There are two ways to build an app based on a SharePoint list. 
The first is the way you have done it by going from make.powerapps. com and selecting SharePoint, locating the list that will be your data source and allowing PowerApps to create the app. 

The second way is via SharePoint and it is done simply to create a PowerApps user interface for entering data into the list.  The SharePointintegration control is created from SharePoint when this option is chosen.  You will not see it when the first method is used and you have become confused by trying to work with something that does not exist in your app.

When using the app created by PowerApps from a SharePoint list as you have done, you will start with have three screens.  A gallery screen showing all the records, a view screen for a single record that contains a view form and an edit screen for a single record that contains an edit form for entering a new record or editing a record selected in the Gallery .  You can then add another list to the app. If you want to filter your data in the gallery by items in the second list, there needs to be a common field in both lists.  One way to do this is by adding a dropdown control to your gallery screen with its items property being your second list and filtering the gallery based on the value selected in the dropdown control.  


Filter(SPlist1,commonfield = Dropdown1.Selected.commonfield)



In this case, the list of contacts is filtered by the dropdown that contains a list of all the state abbreviations. Since a dropdown control contains an entire record, the common field does not have to be the one shown in the window of the control.  For example the filter on the gallery could be 


Filter(SPlist1,stateID = Dropdown1.Selected.ID)


The Value selected to show in the dropdown control could be the text abbreviation, even if the common field is the ID for the state.

filteredgallery.pngAnnotation 2020-06-22 174901.png

Helpful resources

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 (1,772)