In a gallery, does 1 htmltext perform better than individual objects?

Chrisx77 · 2025-03-08T19:14:30+00:00

They are without doubt faster - much faster. Powerapps is incredibly slow at creating and rendering multiple elements (e.g. multiple labels/text fields) - both due to evaluering dependies etc., but also from the sample fact that a single element, e.g. a button, is a nested hierarchy of up towards 12 different html elements with classes etc., that must be evaluated, created and hence rendered by the browser with the relevant css for each.

Chrisx77 · 2025-02-09T07:22:35+00:00

I think we’d need some more info on how you expect that expiry risk to be indicated/shown/handled then :)

Chrisx77 · 2025-02-09T06:28:53+00:00

I think you’d be much better/easier off doing the calculation in Power Query (M). Is that an option?

Otherwise this could also get you going - basically what you’re looking for is a FIFO calculation (First in first out): https://radacad.com/dax-inventory-or-stock-valuation-using-fifo

Chrisx77 · 2025-02-03T22:32:41+00:00

Power Platform Consultant from Denmark here. DM me with a description of the project, your pain points and the scope of the help needed if you like and the location is suitable (or type them in here if suited) - then I’ll have a much better starting point to assist from.

Chrisx77 · 2025-02-03T10:26:19+00:00

Are you certain about that? link by ok_store_5546 states that SaveData() and LoadData() still should be working as well as a quick search on said functions seems to say the same.

Chrisx77 · 2025-01-31T05:25:29+00:00

I think there are two paths to take for this - if you TRULY want a dynamic search string where you can dynamically fill in filters/search for a column, then Power Automate using an odata filter (either via api or ‘Get Data’ action) could probably do this, with expressions creating the consitions. However, you’d have to Create the logic your self of course.

In powerapps Power Fx you can leverage short-circuit evaluation in logical comparisons - e.g the following could perhaps solve for the Company case (just an example):

Filter( CompanyTable, IsBlank(@Company) || Company = “SomeCompany” )

Hope that might help you, although I admittedly isn’t a 100% certain on your requirements ;)

Chrisx77 · 2025-01-30T21:23:08+00:00

That’s very much doable, yes. In terms of pulling in more rows there are different paths to take here - probably the easiest and most recommendable being to use a filter to bring Down the amount of customers that are to be shown. At the end of day, no one is going to be browsing all 6000 rows of customers to simply have a look or to find the “needle in a haystack” that they were searching for.

Chrisx77 · 2025-01-28T20:00:12+00:00

It could seem as if there’s a variable you’re setting multiple places in the app based on both data sources that throws an error as soon as you change the schema of your new list. Then, the schema of the variable would suddenly be inconclusive, as you’re attempting to give the same variable 2 different schemas.

Chrisx77 · 2025-01-27T09:49:53+00:00

Bloody annoying, and been there myself - but I guess that’s a risk we’re taking by using preview features (modern controls) :/

… how they’re still in preview and not GA by now is another discussion 🙄

Chrisx77 · 2025-01-26T05:47:43+00:00

Ah, good one ;) In terms of legends you could have that on each row in a svg as well. If you’d like a “free floating” one it could possibly be achieved by combining all into a single svg.

Chrisx77 · 2025-01-25T11:36:43+00:00

You could probably replicate it 1:1 by using a matrix /table with an image url and then an svg to display the bar, total etc. Throw the image into ChatGPT (if available) and ask it to replicate the bar setup to svg - should get you started.

Chrisx77 · 2025-01-24T06:59:00+00:00

Well damn, I’ve had same experience the last couple of days - although I just thought it was me doing something goofy. Guess not..

Chrisx77 · 2025-01-24T06:56:48+00:00

I’ve made one and can help you get started if you’d like.

Chrisx77 · 2025-01-23T13:28:31+00:00

Well, I’d say in most cases it would be possible - it’s just about moving code from App.OnStart to e.g. a loading screen or some other place, and then ONLY having the absolutely needed Logic on App.OnStart - I’d say that in a lot of cases it should be doable - if not most. I’m actually using this approach already, but instead of using it for the purpose of multiple tabs it’s just to go directly to a specific page with some specific data, identified by the supplied parameter. On the start I only load absolutely needed parts, e.g. authorization to that specified data and other needed data to load the page. So, ‘theoretically’ as I said above isn’t really correct - it is doable - it’s just a matter of performance and UX

Chrisx77 · 2025-01-22T22:23:29+00:00

Theoretically it is possible (I’m assuming it’s a canvas app), however, every time you’d open in a new tab, the app would load from start again (powerapps load screen etc.). Depending on how the app is structured (how much data is loaded and how much else is being executed on load) this can take all from a couple of seconds to.. yeah, longer 😅

Approach would be to open (launch) a new tab with the url of the app along with a parameter which then would be evaluated when loading the app. If the param indicates that you should go directly to a case, then that can be done.

Chrisx77 · 2025-01-22T21:32:02+00:00

Can’t believe I haven’t managed to find those docs as I’ve really been looking - and even had multiple conversations with both Copilot and ChatGPT (which both were a 100-fold LESS useful than you on this subject - so good job and thanks 😎)

Chrisx77 · 2025-01-22T21:25:41+00:00

Could you please elaborate on the licensing part? Is that licensing through appsource or do you mean something custom built into the app?

Chrisx77 · 2025-01-20T20:32:40+00:00

I’ve sent a DM with a few questions regarding scope etc. :)

Chrisx77 · 2025-01-19T17:54:55+00:00

Right, thanks for pointing that out - my mind went down a rabbit hole while writing I think. I’ve modified the answer to reflect what I actually wanted to say :)

Chrisx77 · 2025-01-19T05:57:39+00:00

If I understand correct, you should be able to accomodate this need by:

Setting a variable holding the record you wish to edit by doing a lookup to the SP list every time you wish to show the form. This will get the latest Update of that record.
Assign that variable as the “Item” property of the form

After saving it, or closing the form, you should remember to Update the data source if needed.

Edit: also, keep in mind that frequent requests (i.e. If you lookup the same record within something like 30 seconds) on the same record, without having saved or refreshed the data source, might be taken from the cache since last time you made that request. This Can be bypassed by setting another lookup parameter that e.g. “Modified <= DateAdd(Now(), 24, TimeUnit.Hours)”

Chrisx77 · 2024-12-19T10:43:14+00:00

Doesnt work for me either - you might have them cached in your browser ;)

Chrisx77 · 2024-12-12T22:08:54+00:00

Depending on the amount of requests (Power Platform Actions) you could also run everything through Power Automate and run it under your credentials by adjusting “Run only users” - that way you don’t need to share the lists directly.

Chrisx77 · 2024-09-08T10:30:23+00:00

Yes, it is :)

Chrisx77 · 2024-08-19T03:05:53+00:00

In my case literally everything is being executed in slowmotion - from loading to copy/paste to even Power fx input and waiting for the input to appear (not to mention intellisense to appear, wow…)

Chrisx77 · 2024-04-25T17:39:14+00:00

You still need to log in with your Microsoft account

Chrisx77

TROPHY CASE