SharePoint Get items Filter Quero

[GenuineMapping]

Hello,

I am new to FLow and PowerApps and am making an app combining the two.  I've been hung up for days trying to filter records based on a date range that is handed to the flow from the app.  

I have also tried to do this with a pair of conditions within an "Apply to Each", and I've had difficulty that way as well.  I think just gettting this syntax right is my best chance.

Any thoughts?

Thanks in advance,

GMD

[Pieter_Veenstra]

I would first try to identify the values of each part of your expression by using variables. simply initialize variables for each part of your filter.  So for example the travel date. Set a varibale to the travel date so that you can see what you get in your flow. The smae for the Condition value. 

[v-xida-msft · Accepted solution]

Hi @GenuineMapping,

Could you please share a screenshot of your flow's configuration?

Could you please share a bit more about your SharePoint list?

Could you please show a bit more about the TravelDate column? is it a Date type column in your SharePoint list?

Further, do you want to filter records based on date range from PowerApps app using Data Query within Filter Query field of "get items" action?

I have created a SharePoint list on my side and the data structure of it as below:

Note: The TravelDate column is a Date type column in my SharePoint list.

If you want to filter records based on date range from PowerApps app using Data Query within Filter Query field of a "Get items" action, please take a try with the following workaround:

• Add a PowerApps button trigger.
• Add a "Compose" action, Inputs set to Ask in PowerApps dynamic content. This action is used to get the start date of the date range from PowerApps app.
• Add a "Compse 2" action, Inputs set to Ask in PowerApps dynamic content. This action is used to get the end date of the date range from PowerApps app.
• Add a "Get items" action, specify Site Address and List Name. Within Filter Query field of "Get items" action, type the following formula:

TravelDate ge 'formatDateTime(...)​' and TravelDate le 'formatDateTime(...)​'

The first formatDateTime(...) expression read as below:

formatDateTime(outputs('Compose'),'yyyy-MM-dd')

 The second formatDateTime(...) expression read as below:

formatDateTime(outputs('Compose_2'),'yyyy-MM-dd')

Note: The formatDateTime(...) expression is wrapped with single quotes within above formula.

Image reference:

The flow works successfully as below:

The PowerApps app created on my side as below:

Best regards,

Kris

[Anonymous]

Gracias por su aporte,  y tengo una consulta, como adjunto el resultado de la consulta en powerapps a una control galería para mostrarlo.