Sharepoint Filter AND/OR with Powerapps multiple parameters?

(0) Share

Report

Posted on by Oskarkuus

1,097

How to handle Sharepoint Get Items connection with a odata filter that looks like this

screenshot: http://prntscr.com/pzaos5

startswith(Personnummer,'@{triggerBody()['Getitems_FilterQuery']}') and startswith(ReportYear,'@{triggerBody()['Getitems_FilterQuery_1']}') and startswith(RepportMonth,'@{triggerBody()['Getitems_FilterQuery_2']}')

Everything works as long as data are in the powerapp connectors.

But if any of them are empty, everything fails.

Why?

How to fix this, can i put in some error handler or if statement to fix this?

I dont get any errors when one or several of the parameters are empty... i just get nothing filtered, no result atall.

if i change from AND to OR

it does not really work anyway... since it then does not combine the different data to one filter, it just takes one of them and filters.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Brad_Groux 4,556 on at

Like (0)

Report

Re: Sharepoint Filter AND/OR with Powerapps multiple parameters?

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you. The provided screenshot doesn't really give us enough of an idea to troubleshoot or reproduce.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps 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!

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report

Re: Sharepoint Filter AND/OR with Powerapps multiple parameters?

Sure
Here is a screenshot of my whole flow
https://easycaptures.com/fs/uploaded/1423/6025685084.png

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (1)

Report
Re: Sharepoint Filter AND/OR with Powerapps multiple parameters?

Hi @Oskarkuus,

You could try to use three Compose action to store the three parameters get from PowerApps, then use the outputs of composes to involve into the OData query,

startswith(Personnummer,'@{outputs('Compose')}') and startswith(ReportYear,'@{outputs('Compose_2')}') and startswith(RepportMonth,'@{outputs('Compose_3')}')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report
Re: Sharepoint Filter AND/OR with Powerapps multiple parameters?

No sadly it does not help.
here is a link to a screenshot when flow is running.

here is a link to the flow how it looks now

startswith(Personnummer,'@{outputs('Compose')}') and startswith(ReportYear,'@{outputs('Compose_2')}') and startswith(RepportMonth,'@{outputs('Compose_3')}')

so the result is the same. when the parameters from Powerapps i get no result atall... i want the opposit to happen...
if none of my filter parameters contain anything then get everything from the datasrouce (sp list).
this is how the filter works in Powerapps when filtering a gallery... the idea is to have a button to export the result of the gallery, doing this by filtering the sp list the same way.

Was this reply helpful? Yes No