Activity
Mon
Wed
Fri
Sun
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
What is this?
Less
More

Memberships

Learn Power Apps

2.5k members • Free

Power Apps Templates

125 members • $25/m

The Microsoft Stack

108 members • Free

145 contributions to Learn Power Apps
Dynamic Column Names in Filter Query??
I am wondering if anyone has done a filter a SP List and used a variable, say from a With statement, as the column name to filter for certain criteria (and gotten it to work). Something like: With({FilterCritera:DropDown1.Selected.Value}, ClearCollect(colEvidenceCollection, Filter(SPListName, FilterCriteria = "Yes")))
Dynamic Column Names in Filter Query??
0 likes • 14d
[attachment]
0 likes • 14d
So it appears that Power Apps will not let you put the dynamic value in the column name. You can however, use a switch statement to figure out which column name value is in the dynamic value: With( { FilterCriteria: drpEvidenceFilter.Selected.ColumnName, HQID: drpEvidenceHeadquarters.Selected.ID, MyStartDate: udfGetDateValue(dpEvidenceStartDate.SelectedDate), MyEndDate: udfGetDateValue(dpEvidenceEndDate.SelectedDate) }, ClearCollect( colEvidenceCollection, Switch( FilterCriteria, "AFWUsed", Filter( JobSafetyAnalysis, HeadquartersID = HQID, AFWUsed = "Yes", JSADateValue > MyStartDate, JSADateValue <= MyEndDate ), "ConfinedSpaceEntry", Filter( JobSafetyAnalysis, HeadquartersID = HQID, ConfinedSpaceEntry = "Yes", JSADateValue > MyStartDate, JSADateValue <= MyEndDate )... Each item in the source of the drop down needs to be referenced in the Switch statement to make it work.
Hey Everybody
Lots of new faces in here since I last saw things. Hope to talk to folks about PowerApps, Coding in general, data and Gardening! :) Allow me to introduce myself. I used to be a regular in here but have been off saving the world one PowerApps at time. I love to code. I love to teach coding. Im a friend of Darren's and hope to be an asset in here. Oh....and Darren thinks Im old.
0 likes • 15d
Welcome back Cotter!
Cranking Out Bread & Butter Business Apps Like They're Buttered Up Flap Jacks!
Would you guys go to a session at a Power Platform conference with this info? - Title: Cranking Out Bread & Butter Biz Apps Like They're Flap Jacks! - Content Type: Full Day Hands-On Workshop - Approximate "Level" of This Session or Workshop: 300 - Advanced - Primary Product: Power Apps - Secondary Product(s): Agent 365, Copilot Studio, Power Automate - Primary Topic: Code-First and Fusion Development - Secondary Topic(s): Power Fx - General Audience: IT Professional (some advanced and IT related tasks) - Description: Using a stack of tools (VS Code, GitHub Copilot, and M365 AI tools, etc.), implement an app factory for canvas Power Apps based on a set of best practices for everyday business needs. - ✅ Define flexible workflows that conform to your business processes - ✅ Leverage best practices for gathering requirements, mapping out viable plans for each application, documentation, project management, testing, and deployment. - ✅ Replace Access DBs, Excel DBs, and 3rd part tools like Smart Sheets, AirTable, etc. with fresh new Power Apps applications.
Poll
14 members have voted
Cranking Out Bread & Butter Business Apps Like They're Buttered Up Flap Jacks!
1 like • 17d
Are you going to have a booth as well, or just the workshop? I hope I get to attend again this year. I came back from vacation the beginning of the month and got a semi-permanent rotational assignment 1 1/2 - 2 years working on a major overhaul to our antiquated SAP platform. So, I will have to see if they let me escape to Las Vegas in October...
View different screen sizes in design mode
This comes in handy 🫳 when building responsive apps. How often do you make use it. (See attached👇👇👇)
View different screen sizes in design mode
1 like • 19d
I don't see that in my tenant
1 like • 18d
@Elvis Eyobor 3.25123.14 in my default environment and 3.26012.11 in my early release environment
String Interpolation Issue
I am working on a code generator and running into a weird feature with string interpolation. With the code below in the button's on select property it generates the Add Media control as intended. I have also put the controls into a formula in App Formulas. When I try to look up the YAML code from App Formulas the string interpolation does not pick up the formatting, it just grabs the code as is leaving the {Char(10)} and spaces inline. Any ideas on how to make the look up work? locControlYAML: Switch( drpCodeGeneratorControlType.Selected.Type, "Add Media", $"- {udfGenerateControlName( drpCodeGeneratorControlType.Selected.Type, drpCodeGeneratorTargetScreen.Selected.Name, txtCodeGeneratorControlName.Text )}:{Char(10)} Control: AddMedia@2.2.1{Char(10)} Properties:{Char(10)} AlignInContainer: =AlignInContainer.Stretch{Char(10)} BorderColor: = fxAppDefaults.Theme.PrimaryFont.Clr{Char(10)} BorderThickness: =4{Char(10)} Color: =fxAppDefaults.Theme.PrimaryFont.Clr{Char(10)} Fill: =fxAppDefaults.Theme.{drpCodeGeneratorControlFill.Selected.Value}.Clr{Char(10)} Height: =75{Char(10)} LayoutMinWidth: =0{Char(10)} Size: =17{Char(10)} Width: =281{Char(10)} X: =(Parent.Width - Self.Width) / 2{Char(10)} Y: =(Parent.Height - Self.Height) / 2",
1 like • Dec '25
OK, so I got it working! Trial and error and error and error and BOOM! One of the things I noticed was that when I tried to use string interpolation in the YMLCode field of the Formula it threw an error on every one of the "controls" in the table/formula. In the second image you can see the fxControlTTypes with the Add Media control. In the Fill property you can see Fill: =fxAppDefaults.Theme.{drpCodeGeneratorControlFill.Selected.Value}.Clr What threw the error was that the curly braces needed to be escaped like this: Fill: =fxAppDefaults.Theme.{{drpCodeGeneratorControlFill.Selected.Value}}.Clr When I escaped the curly braces in the YMLCode field, they all worked! So instead of a massive Switch statement in the button on select code I was able to shorten it to this: UpdateContext( { locControlYAML: $"- {udfGenerateControlName( drpCodeGeneratorControlType.Selected.Type, drpCodeGeneratorTargetScreen.Selected.Name, txtCodeGeneratorControlName.Text )}:{LookUp( fxControlTypes, Type = drpCodeGeneratorControlType.Selected.Type, YMLCode )} " } );
1 like • Dec '25
I ran into another issue with the named formula, so I set variables in the button selection code and used those variable names in the named formula. Then I go the great idea to get a list of all the properties, for all the controls, to be able to add to the code generator. There sure are a lot of properties in Power Apps...
1-10 of 145
Dustin Rocksvold
5
222points to level up
@dustin-rocksvold-6086
A hydroelectric operator delving deep into the Power Platform

Active 15h ago
Joined May 13, 2024
Pioneer, CA
Powered by