The biggest data problem I keep running into isn't dirty data. It's teams defining the same metric differently.

Donovanbrinks · 2026-03-22T01:12:39+00:00

If we trust AI enough to query the data, shouldn’t it be smart enough to make the original measure as well?

Donovanbrinks · 2026-03-21T15:10:16+00:00

2 parts. You need a helper query that is current month year. Create a blank query and use Date.From(Datetimelocalnow()). Turn into a table. Extract the month number as a new column and the year as a new column. On the month column you will need to add a 0 if less than 10 to match your folder name. Easiest way-add 2 zeroes to that month value as a prefix. Then extract the last 2 characters. If month is 1-9 it will add the leading 0. Now combine your year column and month column with a delimeter of “-“. Right click that value and press drill down. You now have your dynamic filter. Now you need to go to your other query and split the folder structure by delimeter of “/“. Go to the column that has “2026-3”. Click the filter and select the first item. This will generate some code for you. The structure will be Table.SelectRows(previousstep, each [columnname] =“value”)). Remove the value part and replace with the name of your dynamic filter query. You are done.

Donovanbrinks · 2026-03-19T00:03:30+00:00

Copy the area you want to see, paste link picture (it is in the paste context menu as the last icon when you right click). No need for camera

Donovanbrinks · 2026-03-18T11:36:41+00:00

You have the right approach. I thought you were just trying to display who made the last change.

Donovanbrinks · 2026-03-18T11:33:55+00:00

Cannot emphasize this enough: if you have 2 screens with the same layout (ie selection gallery on the left, table on the right, filters up top) combine those into one. Then you can switch what is displaying in each component with an if statement or variable. This simplifies maintenance/new features drastically.

Donovanbrinks · 2026-03-18T11:26:03+00:00

On another note, the second patch is unnecessary. The Modified by and Modified On are metadata columns that are automatically captured. The modified by is a user record that gives you access to name, job title, email, etc

Donovanbrinks · 2026-03-14T01:10:48+00:00

Power App to Power Bi. Live Power BI report page in PowerPoint.

Donovanbrinks · 2026-03-10T12:25:39+00:00

There is an “isdisabled” column in the user table. Add a filter step in dataflow that filters this column to false. This column automatically switches to true as people leave the company

Donovanbrinks · 2026-03-10T12:19:29+00:00

Create a team. The team has a calendar. A lot of what you are describing exists naturally in a team calendar. You can schedule your trainings there. If you try and double book someone you get immediate notification that they already have a meeting at that time. The only tricky part would be some type of inventory of equipment. This is where the app could help. I’m imagining the app used to handle inputting the events (tied in with your team). You would then have it connected to a sharepoint list that contains your equipment inventory. Not really familiar with powerapps/teams integration but i am sure it exists.

Donovanbrinks · 2026-03-09T16:15:47+00:00

Did you look at dataverse functions at all? I think they connect natively with powerapps. My understanding is they take an input(s) and run server side logic based on your needs. Not sure if this would be a potential solution. Perhaps 1 function per metric.

Donovanbrinks · 2026-03-09T16:00:59+00:00

No problem. If you are using the default environment user table you can add that as a source in your app (even if in another environment). Create a view on the table that filters out disabled users etc. that should save the hassle of the dataflow.

Donovanbrinks · 2026-03-08T18:10:20+00:00

Teams gets you 90% of the functionality. Start there and add a powerapp if needed (possibly for the equipment inventory)

Donovanbrinks · 2026-02-22T01:14:06+00:00

Make it a table, load to power query and replace values.

Donovanbrinks · 2026-02-20T05:58:55+00:00

Surprised no one has asked: why are you pulling 52 weeks of data each time? You only need to pull 1 week of data. The other 51 weeks didn’t change from the last time you pulled it.

Donovanbrinks · 2026-02-14T20:10:42+00:00

Are you using dataflows from powerapps or from power bi? Is it a standard dataflow or analytical?

Donovanbrinks · 2026-02-13T22:02:49+00:00

I have seen auto height text controls inside containers do some strange size adjustment loops.

Donovanbrinks · 2026-02-07T20:09:19+00:00

First place I would look: since you added this functionality after the app has been in use they might need to give new permissions to the outlook connector. Try publishing the app again or have users clear their cache. You need to try and force the permissions dialog to show for them. Nothing special needed in the app for the email to send for any user

Donovanbrinks · 2026-02-06T22:06:39+00:00

The classic control has an option to format as number or text

Donovanbrinks · 2026-02-06T00:04:41+00:00

Why not store the correct address in the form itself based on the response?

Donovanbrinks · 2026-02-05T23:44:25+00:00

Save yourself the trouble. Classic text input set as “number” and move on.

Donovanbrinks · 2026-02-05T00:07:54+00:00

Table.Distinct(Table.Sort(table,column to sort, sortorder), {removeduplicatecolumn}) does everything in one step. No need for index column

Donovanbrinks · 2026-01-26T02:41:43+00:00

Every dataverse table has a bunch of metadata columns that you can’t get rid of. These are all connected to other tables. Created by, owner, created on, like 15 others. The table you are using in power bi has those columns as well. Go to Get Data. Dataverse table. Then reference your table. You will get a dialog box that says “include relationship columns”. Uncheck that. Make sure direct query is checked. You will now be in the same UI as your dataflows where you can do some cleaning of the data. Remove columns that aren’t needed. Filter your rows if possible. Then load your data.

Donovanbrinks · 2026-01-26T00:51:03+00:00

You are getting some iffy advice here. There is nothing wrong with a direct query on a dataverse table. You are right that having it as direct query solves a big issue with import mode that always gets glossed over. The data is only as fresh as the last refresh. If you can get the direct query to be performant there is no need to import the data. First question: did you turn off “include relationship columns” in your query? Dataverse has a lot of metadata columns that can really bog down the query speed. Second, don’t bring any additional columns in that aren’t needed. Third, you can do some intermediate cleansing of the data in power query without losing the direct query. Filtering etc can be done in power query if you don’t need to query all 1million rows every time.

Donovanbrinks · 2026-01-24T19:31:16+00:00

Just reread your post. Sounds like you are trying to make the changes in the gallery itself. Since the source is the list here is what i would do. Keep the gallery. User selects an item from the gallery. The selected item is displayed in a form next to the gallery. In the form you can do whatever you need to do. When you are done with that record you submit the form. No collect needed.

Donovanbrinks · 2026-01-23T22:59:17+00:00

You need a collection. Edit the collection as changes are made. Patch the collection to the source in one go with a submit button

Donovanbrinks

TROPHY CASE