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.

1 Answer 1

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)
4
  • 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 Commented Feb 6, 2019 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
    Commented Feb 6, 2019 at 1:11
  • Delegable, not deletable. Sorry.
    – Mike2500
    Commented Feb 6, 2019 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. Commented Feb 6, 2019 at 15:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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