We need to build a report inside our Power Apps which show the following info:-
1) We have a SharePoint list named "Contracts", and we want to show the number of Contracts created from specific date to a specific date.
2) Each contract item inside the "Contracts" list has a status; "In Progress" , "Done", "Approved" & "Rejected". And we want to show the number of items at each stage from specific date to a specific date.
Now i know that i can build a collection inside my Power Apps , such as :-
Filter(Contracts, Created > varfrom && Created < varto);
but this collection can only hold max of 2,000 items..
So instead I am planning to do the following:-
1) Create a Power Automate flow which accept 2 DateTime parameters ( From & To) and which get called from Power Apps, then it get the related items using the built-in "Get Items" action which can get up to 100,000 items since we have premium license... and do the calculations and send them back to power apps..
So is my approach of using Power Apps with Power Automate the way to go?
Thanks