Unanswered

Translate canvas app filter criteria to Flow

(0) Share

Report

Posted on by ChrisChong

Good day all,

Is there a way to translate a canvas app filter into a Flow?

This code worx fine against a dataverse table. But it returns a max of 2000 records because of the use of collections, I'm told.

But I am at a loss as to how to construct the Flows filter to return more than 2000 records.

Can someone offer some help please?

Chris

Set(
 varForJson,
 ClearCollect(
 colForJSON,
 Search(
 Filter(
 [@'Schools Data'],
 And(
 !IsBlank(EMAIL),
 Or(
 IsBlank(TabListProvinces.Selected.Value),
 PROV = TabListProvinces.Selected.Value
 ),
 Or(
 IsBlank(DropdownSpec.Selected.Value),
 SPEC = DropdownSpec.Selected.Value
 )
 )
 ),
 SearchBox.Value,
 "cra31_title",
 "cra31_lastname",
 "cra31_city"
 )
 )
);

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @ChrisChong

Yes, for the collection (in this manner) the max it will do is 2000 or 500 if you haven't updated the settings of your app to 2000.

Can I ask why you are creating a collection? What Control are you setting the Items property from this collection? can you "not" use one, so that your Query(need to verify as I didnt look closely) is delegatable.

And yes you could translate that to an ODATA query in Flow, but that doesn't help you because if you plan to hand the data back to a Canvas App or Model, you will still run into issues because it still wont return back more than X number, but it supports (pagination) up to the max delegatable amount.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
ChrisChong on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for your reply. Your questions:
I created a collection to make the results of the Filter operation JSON. (Could not find another way). The JSON is then fed to Power Automate to make a CSV--the object of the exercise.
This the reason why I am hoping to translate whatever the canvas criteria to ODATA for the Flow to produce more than 2000 records in the CSV.
I am not looking to use the resultant data back in the canvas. I simply Launch the CSV it opens in Excel whai what the user wants.
There is the rest of the canvas code if it helps:
ForAll(colForJSON, Collect( colDataExported, { aTitle: ThisRecord.TITLE, bLastname: ThisRecord.LASTNAME, cFirstname: ThisRecord.FIRSTNAME, dJobTitle: ThisRecord.JOBTITLE, eEmail: ThisRecord.EMAIL, fCity: ThisRecord.CITY, gSpecification: ThisRecord.SPEC })); 'Export2CSV-2023103'.Run(JSON(colDataExported,JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes ))
Thank you for considering. I have exhaused myself on this for weeks.
Chris

Was this reply helpful? Yes No