cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Katrina_Frigeri
Regular Visitor

Can't find the SharePointIntegration control

I originally created my app from the make.powerapps.com 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: https://youtu.be/A-pJB-ufKa8 

 

 

 

2 REPLIES 2
chsanche
Microsoft
Microsoft

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
Drrickryp
Super User II
Super User II

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

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

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