Aggregate count easy with dataverse API but hard in Power Apps

(0) Share

Report

Posted on by ingovals

140

Using the API this is as simple as adding this query param

?$apply=groupby((mysol_myfield),aggregate($count as count))

But trying to do some work using the Power Apps power query bar results in multiple calls, fetching the whole table, ordering, sorting etc.

This only returns a max since it is done client side. ( set at 2000 for my app )

Is there a way to either:

Do a Power Query that works the same way, that results in the simple api call.
Just straight up do the API call from Power Apps.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (1)

Report

Hello, @ingovals, you can create a Power Automate Flow and use the HTTP requests. https://learn.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/web

Then you will use the Parse JSON action to get the data and use the Parse JSON output to load the data into your Dataverse table.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

ingovals 140 on at

Like (0)

Report
@AhmedSalih

How do I return the data from the Flow to the Power App. If I create a PowerApps initiated flow and do a respond the output type is limited to some simple scalar types that does not include an array/collection type.

Text
Yes/No
File
Email
Number
Date
I can get the data without the HTTP Request by just using the Dataverse connector in the flow (which does a HTTPS behind the scenes).

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@ingovals,

You cannot directly pass JSON object to Power App from Power Automate, but you can pass the JSON object to power app as a string by using a Join action in Power automate. Then in PowerApps use the ParseJSON function in Power Apps (experimental).

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

ingovals 140 on at

Like (0)

Report

I just did a HTTP Response instead of a power apps respond and could return a typed answer.

Was this reply helpful? Yes No
Splash58 32 on at

Like (0)

Report

Hey,

you can also create a custom connector as an alternative.
You can define as many actions as you like and you get the data back just like with any other connector.

Was this reply helpful? Yes No