List rows not finding all records

(0) Share

Report

Posted on by iwonder

1,146

Thank you for taking the time to read my question.

I'm calling my flow from PowerApps. I'm sending a start date, end date and an asset type (monitor, keyboard... etc).

When I use the Filter() function in PowerApps I get back 646 records, but when I use the same criteria in the List Rows step, and I do a QDATA filter I only get back 168 records.

I must be doing something wrong with my QDATA filter in List Rows but am not able to figure out what.

Here is my PowerApps Filter(): CountRows(Filter(Assets,WarrantyExpireDate >= dpWarrantyStart.SelectedDate,WarrantyExpireDate <= dpWarrantyEnd.SelectedDate,AssetType = ddAssetType.Selected.TypeName))

My List Rows QDATA Filter: cra98_warrantyexpiredate ge '@{body('Parse_JSON')?['WarStDt']}' and cra98_warrantyexpiredate le '@{body('Parse_JSON')?['WarEndDt']}' and cra98_assettype eq '@{body('Parse_JSON')?['AssetTyp']}'

any help would be great,

Thanks

Categories:

General topics

All responses (4)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@iwonder So where is operator in your filter()?

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hardesh15

@my apologies, I’m not sure what you mean by operator.

thanks
Hardesh15 7,087 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@iwonder Logical operator like AND OR in your filter().

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in
iwonder 1,146 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for that and sorry for my slow reply.

In PowerApps if the user said they did not want to send dates and AssetType, I put in a date of 1990-01-01 as the start date and Today() as the end date. That did not work, so in the end I put in logic in my app that if the user does not want to send a date I put in the word "null" then I put in a conditional step in my flow and duplicated all the steps for the True and False sides. Now it works.
The True side = if the start date = "null" then only do an ODATA filter on AssetType. The False side does an ODATA filter on AssetType and StartDate and EndDate.

Thanks