web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Pulling Sharepoint data
Power Apps
Unanswered

Pulling Sharepoint data

(0) ShareShare
ReportReport
Posted on by 13

Currently do not have owner's access to the sharepoint doc lib for the data only read access.

I can pull data into to a dropbox/combobox using the choices function and can add a datatable(but need to add concat to 1 of the columns to display data) and all work fine.  What I cannot do is only filter certain data in a column so only data in the other column is shown in the dropbox.

 

Doc_TypeCarDoc_Num
Service ManualSmartA1
Users ManualSmartA2
200mph upgradesSmartA3
Service ManualCorvetteA4
Users ManualCorvetteA5
200mph upgradesCorvetteA6
Service ManualViperA7
Users ManualViperA8
200mph upgradesViperA9
Service ManualYugoA10
Users ManualYugoA11
200mph upgradesYugoA12
Service ManualMaseratiA13

 

'Doc_Type' column in the Sharepoint db is a single choice selection (and shows up in power apps as 'Data type:Table' and when you expand it [Record] for each column row) , 'Car' column is a mutli items choice column (and shows in power apps as 'Data type:Table' and when you expand it [Table] for each column) and 'Doc_Num' is text.  This is how the person set it up and this is updated with new additions and updated revisions.

 

I have a dropbox to select the 'Car' and a label to display the 'Doc_Num'.  What I cannot get to work because of the data types is filtering so only the cars that have a 'Service Manual' in 'Doc_Type' column are available in the dropbox and in turn display the 'doc_num' in the label.

I have the same question (0)
  • mdevaney Profile Picture
    29,991 Moderator on at

    @JoeG1 

    You have posted your question about SharePoint inside the Common Data Service forums.  The general forums would be a better place to ask your question (https://powerusers.microsoft.com/t5/Building-Power-Apps/bd-p/PowerAppsForum1).

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard