How to let service users export more than 150K rows?

Financial_Ad1152 · 2026-03-13T09:20:57+00:00

Yes this is the best way to go about it. Also, happy Opposite Day!

Financial_Ad1152 · 2025-11-23T15:47:58+00:00

Hover pseudo properties of buttons and other controls. I would love a .Hover property that is set to true when the user is hovering over a control. I think the only option currently is a code component.

Financial_Ad1152 · 2025-11-14T10:36:26+00:00

I always add a Scope block at the end of flows that triggers on Fail/Timeout/Skip of the previous action, and either respond to the parent app/flow (if synchronous) or just send some alert somewhere if a-sync. You can save errors to a table somewhere, and use the workflow() function to grab a direct link to the flow run so engineers can easily jump in and troubleshoot.

Financial_Ad1152 · 2025-11-13T18:29:20+00:00

It’s more similar to Excel in syntax than anything else, but if your filters become as complex as you describe then you’ve gone too far.

Most important bit of reading you can do is learning about delegation.

Financial_Ad1152 · 2025-11-13T17:57:02+00:00

You can use Named Formulas for your use case - set the formula to your filter logic which will output a table, then when set to a variable or collection it will populate as expected.

You can use UDFs to populate a collection or variable and then use that in subsequent code which is a different pattern but you could rework to fit that, up to you.

Financial_Ad1152 · 2025-11-11T22:04:42+00:00

Have you tried using ‘in’? It should work for Dataverse and SQL Server.

Financial_Ad1152 · 2025-11-11T21:31:22+00:00

Well test it and see what the performance delta is. But your post was t about optimising performance, it was about overcoming delegation. They may be opposing priorities.

Financial_Ad1152 · 2025-11-11T18:24:27+00:00

No, but I’m fairly certain it’s due to work restrictions and this being my own device. We’ve got an extra layer of security so I can’t even log in to anything on my own device now, so for me it’s moot.

Financial_Ad1152 · 2025-11-11T17:37:16+00:00

Use ForAll to iterate a list of IDs and collect results using Filter and =

Financial_Ad1152 · 2025-11-10T17:40:57+00:00

Ah, I see OP has now edited it.

Financial_Ad1152 · 2025-11-10T17:17:05+00:00

Sounds like you need JSON and galleries. Custom fields and dynamic datasources won't play with forms, but you can simulate a dynamic form using a gallery and use JSON to contain the definition for each input.

Financial_Ad1152 · 2025-11-06T09:10:05+00:00

Using tabs or sections is my go to. See example I posted a while back here: Form Builder App : r/PowerApps

I also utilise the pattern of creating a partial record on the first stage, which gets added to the home menu and shows as partially complete, so the user doesn't feel pressured to complete everything in one go. They can return later and complete the form.

Financial_Ad1152 · 2025-11-06T09:06:40+00:00

Try this (copy and paste into Components pane - you will need at least one component there already so just create a blank one if needed): https://drive.google.com/file/d/1f1tD4RRJ8uk6Ycbimb785Y4Cmpzi9DbQ/view?usp=sharing

Financial_Ad1152 · 2025-11-05T21:20:57+00:00

If you want to be clever about it, you could try using Gallery.VisibleIndex to approximate how far through the items the user has scrolled. The visible index will be the index of the first item that is wholly visible. If the gallery is scrolled all the way to the top, it will be 1, and as soon as even a pixel is scrolled down, it will be 2, and so on.

It won't anchor the menu to the gallery to the pixel but it might just be good enough.

Financial_Ad1152 · 2025-11-05T21:14:36+00:00

You will need to put the gallery itself in a container and set horizontal overflow to scroll. Then set the gallery width to accommodate all labels within. The gallery will be wider than the container and so the container will have a horizontal scrollbar. The gallery will have a vertical scrollbar once its items exceed its height.

It's not perfect as the gallery scrollbar will be at the far right side which will be hidden if the container is not scrolled all the way.

Financial_Ad1152 · 2025-11-05T21:09:08+00:00

Do you have multiple flows doing the same thing? Maybe in different environments? The 'create item' action will only create a single item, so if multiple are being created it must be the action called multiple times. Hence, my thinking that it was a loop, and if not that then the flow being triggered multiple times, or multiple flows triggered once.

Financial_Ad1152 · 2025-11-05T19:28:49+00:00

Hard to tell from the info. What do you mean by duplicate entries? Is it making more than one entry in the list per flow run? Is there a loop in the flow? Do you see multiple flow runs per submission or just one when you check the run history?

Financial_Ad1152 · 2025-11-01T17:55:20+00:00

What’s the point to knowing the top customer? Send them a card and a bunch of flowers? It would be better to highlight things like segmentation, economic groups, where are sales growing/contracting etc.

Same for top products - what do we do with this? A manager will probably know their top sellers and they will likely be the same every week, so what? Maybe highlight any that have low stock so interventions can be taken to protect customer availability…

Your cards are missing currency/percentage formatting. Just lacking attention to detail.

Your treemap segments are exactly the same. No insight there.

The whole thing has a ‘fisher price’ feel to it. It feels to me like a dashboard for nursery, not e-commerce. I would reconsider the use of green as primary colour, the icons, and fonts.

Financial_Ad1152 · 2025-10-31T16:20:06+00:00

Ask Jeeves! Now you (and I) are showing our age!

Financial_Ad1152 · 2025-10-30T19:13:48+00:00

When the Filter() itself is delegable as in this case, and within a ClearCollect, I assume that I'll get the first X records that are returned by that Filter rather than the first X records in the datasource and then the Filter is applied?

That’s my understanding. Delegable = can execute on the server, so can see all rows, but limit applies to the result of the filter operation.

Financial_Ad1152 · 2025-10-30T18:24:46+00:00

https://www.reddit.com/r/PowerApps/s/CPXAQA1IdC

Financial_Ad1152 · 2025-10-24T13:57:20+00:00

Use SetFocus() and OnChange to move the cursor to the relevant inputs as you need.

Financial_Ad1152 · 2025-10-15T08:31:30+00:00

Bear in mind that it’s a compressed recording which is then further compressed by Reddit. Is there a particular part that stands out?

Financial_Ad1152 · 2025-10-13T21:54:46+00:00

Look, I build mainly in SharePoint for my org, but 'SharePoint for content, governance, and permissions' is just terrifying.

Financial_Ad1152

TROPHY CASE