cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Otto_Luvpuppy
Frequent Visitor

Power Automate Get Items using a SharePoint View

I have an issue with the Get Items function and the OData filtering in that it won't work with SharePoint List Calculated Columns.
To get around this I thought I could pre-filter the source List using a View and just use that for the Get Items...that way I don't need OData Filtering at all. No luck though....I see that you can use a View to restrict columns but not use it to filter.
Any reason why this is. Is it something that is in the pipeline or is it impossible. Seems like a really neat way to deliver a pre-filtered source t Power Apps...but I guess there's a lot more to it.

 

Any ideas?

 

Thanks

 

Paul

1 ACCEPTED SOLUTION

Accepted Solutions
PrasadAthalye
Super User
Super User

It is by design. View is just to select columns. You will have to use Odata filter to filter columns. That is the only way.

 

In order to filter on calculated columns, Use Get Items query without filter. Then use filter array to filter the data.

 

PrasadAthalye_0-1631657784143.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

2 REPLIES 2
PrasadAthalye
Super User
Super User

It is by design. View is just to select columns. You will have to use Odata filter to filter columns. That is the only way.

 

In order to filter on calculated columns, Use Get Items query without filter. Then use filter array to filter the data.

 

PrasadAthalye_0-1631657784143.png

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

View solution in original post

Thanks for the prompt solution to this....shame we can't use Views as it would simplify matters. As for using the Filter Array...that's exactly what I did but I didn't know if it was the most efficient method. Seems like it is.

Thanks again.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,351)