0

Arguably this is a PowerApps question as well, but I thought my SharePoint folks might have encountered this one.

I am showing a SharePoint list in a PowerApp, let's call it 'Upcoming Events' and Power Apps brings in the data, but it looks like it pulls all items.

Is there a way to pull a particular view with the correct REST url?

I am using SharePoint Online and Power Apps to create a simple interface for my users.

0

It may be possible to use the custom connector to connect to the SharePoint REST API, though that's certainly not a trivial process, nor is this specific scenario documented that I'm aware of. Another possibility to use create a custom azure function that returns the data you need, and call that from Power Apps. The easier way is to use the filter function within PowerApps to get the data you need, no coding required. While creating the logic for the filter, you'd need to replicate the logic of the view, but that would most likely take less time than the other options, and would look something like this:

Gallery1.Items = Sort(Filter('data source name',field1 = "some value"),Modified,Descending)
  • I know about Filter and SortByColumn however those operate on the data after you retrieve the first N rows from SharePoint. I want to get a pre-filter pre-sorted view from SharePoint. I use custom connectors for other things but that seems like overkill for this – Glenn Ferrie Feb 6 at 0:39
  • Filter is deletable from SharePoint, depending on the operators used. So it should return the first n records that meet the condition. – Mike2500 Feb 6 at 1:11
  • Delegable, not deletable. Sorry. – Mike2500 Feb 6 at 1:31
  • I'll inspect. but my goal is not to re-implement my view(s) logic in PowerApps. Proxy through an ASP.NET Web API / Custom Connector will to be the band-aid solution for now. I'm pretty sure there is a "Custom SharePoint API request" action somewhere. – Glenn Ferrie Feb 6 at 15:12

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.