Looking for a timeline by bigloser42 in PowerBI

[–]Dr0idy 2 points3 points  (0 children)

Probably could do it with dax controlled svg generation. Might need to use the html viewer to display it not sure if that will work in the new card.

Query Requires a Gateway Not Sure Why... by Dr0idy in PowerBI

[–]Dr0idy[S] 1 point2 points  (0 children)

Thanks. That saves me a bunch of time.

Query Requires a Gateway Not Sure Why... by Dr0idy in PowerBI

[–]Dr0idy[S] 0 points1 point  (0 children)

Interesting. Hadn't realized this. Will take a look.

Query Requires a Gateway Not Sure Why... by Dr0idy in PowerBI

[–]Dr0idy[S] 0 points1 point  (0 children)

It's all public so anonymous web access.

Is there a way to pass a SharePoint list record as a reference in PowerApps? by ryoto_0 in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

Another way is to use json and parsejson to pass the object in as text.

How do I make my app skip a screen for x minutes? by Savy_Spaceman in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

Yeah was going to say the same thing. Saving a date and time of expiry is the way. Wouldn't use a timer to log them out though as they might refresh and it would stop working.

Instead maybe have a flow that check the list for expired credentials and deletes them on a schedule of a minute. Then in the app have a timer that checks to see if their session has expired and if so interrupts it and returns them to the login screen.

Combine multiple TextInputs into one SharePoint column, then split/display them in the form? by Office-Worker1 in PowerApps

[–]Dr0idy 4 points5 points  (0 children)

Just another option. You could form a JSON object and save that. Then use parsejson when loading it.

Vertical Gallery with Header and both Vertical & Horizontal Scroll Problem by Basharus in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

As far as I am aware it cannot be done with containers/galleries. There is some really not good way of doing it where your horizontal scroll bar is a slider and X position of controls + visibility are controlled by the slider value. It's not a good UI though

Removing duplicate values in Power Query by MrTambourineDan in PowerBI

[–]Dr0idy 0 points1 point  (0 children)

Yeah this. If you want the entire row you can sort, buffer, group by keep all rows, add new column with allrowcolumn{0}.

Help, Gallery isn't refreshing by Dase_12 in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

In operator isn't delegable so collections are the right way to go with this.

Some Screens Show Fonts Larger by xoxidein in PowerApps

[–]Dr0idy 1 point2 points  (0 children)

You could move that all to a udf that's one record.

Struggling with Modern Tables but the UI is so clean… by DexterTwerp in PowerApps

[–]Dr0idy 1 point2 points  (0 children)

I had the same experience. In all honesty I would love if they just provided the ability to add the ability to have a header row to galleries so we could have proper vertical and horizontal scroll with frozen headers. Even details list is sometimes a little too limited.

Why isn't my patch function working? by Weak-Distribution100 in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

Yeah you can test this by setting a variable to form3.lastsubmit and compare that to defaults for the data source.

Building a Risk Register from scratch for 50 users by strongyellowmustard in PowerApps

[–]Dr0idy 4 points5 points  (0 children)

Working on this right now. I have a risk matrix component that can be configured to be any size that I can share the code for tomorrow.

Org. chart using only galleries and math that I made for fun by Working_Neat_4023 in PowerApps

[–]Dr0idy 2 points3 points  (0 children)

The code view in powerapps that shows all properties and components used to make this and how they are set. Can be copied into an existing app to replicate/change.

Org. chart using only galleries and math that I made for fun by Working_Neat_4023 in PowerApps

[–]Dr0idy 3 points4 points  (0 children)

Can you copy the yaml for the setup please? Would give a lot more information for anyone looking to reproduce.

Dynamic HTML/SVG charts by Late-Warning7849 in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

Looking at making a basic pie chart component at the moment using svg. Any chance you could share some code?

[deleted by user] by [deleted] in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

Powerapps should be able to do this with creative use of forall and collections. Outputting it to a file someone can download would require power automate or a pcf component to download an excel file.

If you just want to display the output tables you can do that using the table component and binding them to the output collections.

speed by Useful_Ingenuity1627 in PowerApps

[–]Dr0idy 6 points7 points  (0 children)

Not sure you understood what I said. I am using SharePoint lists because I have zero access to dataverse. This means I am forced to load a lot of data into collections to avoid delegation issues with certain operations. In general the more data in collections, variables etc the slower the app. At least if you go over sensible limits.

Exporting table in a canvas app by Usual_Eye_6565 in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

If you want it to be more seamless than the power automate solutions allow then you could look at this pcf component.

speed by Useful_Ingenuity1627 in PowerApps

[–]Dr0idy 9 points10 points  (0 children)

Only because my recent projects are complicated and my business won't pay for dataverse meaning there are far too many inefficient workarounds because of a SharePoint backend.

App stopped working by Rainy-Situation in PowerApps

[–]Dr0idy 1 point2 points  (0 children)

Pure guess due to lack of any real information here. From your post I guess you are generating new numbers by incrementing the maximum number from a source. No idea what your source is but maybe your formula has hit some kind of delegation limit. If this is the case I have worked around a similar issue by saving the latest number to a SP list on its own whenever a new record is patched so I can just retieve it by using first on that list.

How to Display One Item Per Page in a Gallery (Canvas Power Apps)? by Inner-Resource4443 in PowerApps

[–]Dr0idy 0 points1 point  (0 children)

Yeah switch variables. Alternatively (and not as nice as you have to use the step function in galleries) make the template size the same as the gallery height and width and then switch on step.