User

Write something

Pinned
Have a question? Stuck? Need support?
If any of you have a question, or if you're stuck, have a video idea, or need support, here are the best ways to get help: 1 - Search here on Skool to see if an answer has been provided in the past. As time goes on, the questions and answers will grow to be quite the helpful knowledgebase. 2 - Post here in Skool: Chances are, others here in the group may benefit from any answers or interactions here in Skool in this "Community" tab. You and your fellow students can search here on Skool to see if any others have had a similar question and thus, see the answer or resolution. 3 - If you feel that what you need help with just isn't appropriate for the whole group, feel free to email us at support@neese.us 4 - If you need some serious help, book a call with us: https://calendly.com/super-power-labs/power-apps-success-planning
26
35
Lanee Nye
Benoit Lorant
Jeff Bratton
Wes Benson
Darren Neese
New comment Oct 27
Pinned
Need access to a course/product you purchased?
We're in the process of moving away from software or platforms we have been using to new ones that serve you guys better. For example, this Skool community instead of the Facebook group and our Kartra system. If you have purchased anything, but aren't able to access to what you purchased over on the "Classroom" tab, please respond to this post here in the comments below, and I'll get you squared away as soon as I can. Thanks! Darren
16
21
Carl Wakefield
Darren Neese
Enrique Chong
Brian Bryson
Karen Branson
New comment 27d ago
Pinned
Access All Content for Free
Hi guys! How do you level up here in this community? You simply post and become active and engage. Any post or comment you make here in Skool can be liked. Each like adds points! If you introduce yourself, and comment on the things that interest you, you'll level up in no time. 😊👍 To find out where you're at, click here: https://www.skool.com/learn-power-apps-9036/-/leaderboards - 🟡At yellow belt (level 2), you will earn the Crash Course. - 🔵At blue belt (level 5), you will earn the JumpStart Kit. - 🟤At brown belt (level 7), you will earn the Ticketing App Course. - ⚫At black belt (level 9), you will earn 12-months access to the Accelerator Program! Once you guys reach the level, post a comment below and I'll get you all set up! Thanks for bringing this community alive with your engagement! If you've already purchased these, you can gift one to a friend.
24
48
Darren Neese
Randy Greig
Travis Parris
J A
Elvis Eyobor
New comment 11d ago
Having Dataverse Import Nightmares
For the life of me, I cannot get a complete data import into Dataverse from Excel workbooks. Might an Excel -> SharePoint List -> Dataverse increase the probability of getting all of the data into Dataverse? Is there a limit to the number of rows your can import per file? 2024 records seem to be the magic number for me... Any suggestions, thoughts, and/or word(s) of encouragement will be greatly appreciated.
1
8
Darren Neese
Eric Gamble
Kendall Outlaw
New comment 1h ago
1d ago 
in 
Memes
Mucho trabajo
Except in my case, no one at the company I work for really care that I keep making their lives easier with apps instead of forms and spreadsheets.
1
3
Elvis Eyobor
Guy Johnsen
Wes Benson
New comment 4h ago
Choices function on SQL datasource
I have a field in SQL which is a VARCHAR(10) type even though it only takes in 'Male' or 'Female' as it is a gender column. I am trying to pull up the field as a combo box in my gallery to no avail. I have tried choices and distinct in the Item property of my control and they both are simply not working. Was wondering if I can get some suggestions?
0
1
Eric Gamble
New comment 6h ago
What Industry Do you Guys Work In?
I want to cater to my target audience's specific industries. Which are you in? For me, it is Information Technology, but I can't assume everyone comes from IT. Please share!
Complete action
9
87
Benjamin Rackley
Michele McBride
Tarek Marach
Will Cauthen
Sarah Scurlock
New comment 14h ago
Red underline, stil code are working
Red underline even when the code works. Done mine before Patch but when I type the code I get red underline. Save and click play. the code works as it should. And back in edit mode, the underline is gone.
1
3
Darren Neese
Elvis Eyobor
New comment 18h ago
Criteria for determining whether an app is "no-code" or not
Where is the line drawn that determines whether an app is "no-code" or not? The "no-code" capability of Power Apps seems to be an attractive feature to folks who don't want to spend more money on expensive developer resources. Is the determination based on whether the "developer" has entered any content into the formula bar? I suspect that my initial guess is too naive. Any ideas? Thanks.
1
2
Kendall Outlaw
Elvis Eyobor
New comment 23h ago
Social media power app?
I guess... technically it's possible.
0
3
Elvis Eyobor
Guy Johnsen
New comment 23h ago
Challenging co-workers to get out of thier comfort zone
I left the Federal Government 2 years ago due to lack of software, low pay, and no internal on the job training. I then landed a contracting job that forced me to learn how to use Power Apps and Power Automate because I had to find an alternative solution to 20+ Access databases that were inefficient for the company. It was a great experience for me because it allowed me to learn how Power Apps and Power Automate works and I was able to leverage these tools to increase the company's productivity. I recently came back to the Federal Government 2 months ago and they now have better tools that they did not have when I left such as Power Automate Desktop and Power Apps for Teams. It kind of frustrates me that most of my co-workers don't want to learn how to use these tools to become more efficient in their role. They instead would prefer using Excel Spreadsheets and Access databases. I know first hand that the training on the Federal Government side is lack luster at best. The only solution that I have come up with is to create the training materials myself and to schedule time to train my co-workers. What are your thoughts?
4
5
Darren Neese
Elvis Eyobor
Sarah Scurlock
Kendall Outlaw
New comment 23h ago
Using the Right Tool for the Task
If You Were Tasked to Create a Tool that is needed to Track Metrics, Which Tool Would You Use? And Why?
Poll
2 members have voted
1
1
Elvis Eyobor
New comment 23h ago
Why isn't the Jumpstart "varGlobalMenuSettings" a gbl?
The Jumpstart toolkit App object OnStart property contains a variable "varGlobalMenuSettings" that's prefixed with "var" rather than "gbl". Is there a reason that this one has been singled out to be different? Thanks.
0
1
Guy Johnsen
New comment 1d ago
Create a Countdown Timer
Below are the steps to change a Timer to a Countdown: 1. Insert a Timer Control and Rename it Timer1 2. Create a Text Input above the Timer Control and Rename it SecTextInput 3. In the Duration property of the Timer Control, put in the following: SecTextInput.Text * 1000 4. In the Text property of the Timer Control, put in the following: Text(Time(0, 0, (Timer1.Duration - Timer.Value) / 1000), "ss") 5. Play the app and Type in a Number in seconds in the Text Input 6. Press the Timer Control Button and Watch it Countdown from the Number that was Entered in the Text Input
4
2
Elvis Eyobor
Travis Parris
New comment 2d ago
Digital Contacts - Power Apps -> Power Automate -> ??
Does anyone have any experience with creating digital contracts from data in Power Apps/ Dataverse? I'm aware of the PDF function in Power Apps but I'm looking to insert data into a pretty/tuned PDF (created in Canva). I can run a Power Automate flow from my estimating power app and I'm familiar with JSON however I'm stuck with getting the data into the PDF. The closest thing I have found is Encodian's integration that will allow a PDF form to be filled. Any ideas?
0
0
Attitudes of Assistance: "RTFM" or "HHIUTM (see the reference)"
Over the years, I have run into three (3) technologist attitudes on assisting others: 1) "RTFM", 2) "They will figure it out, no assistance from me necessary", or 3) "HHIUTM" (with a little guidance) What camp do you fall into? Is there another camp that should be listed?
1
1
Eric Gamble
New comment 2d ago
[SOLVED]Gallery column sum()
Hello Team, I am still very new to Power Apps and trying to work on a very small project, but I encountered an error with the sum() function on a Gallery column. I have this code in a Label text (not in the gallery): plaintextCopy code Sum(Gallery3.AllItems, Value(Text(Label4))) I also tested: plaintextCopy code Sum(Gallery3.AllItems, Value(Label4.Text)) But I still get the error message: "sum(number; number), number: a numeric value for this summation process." In my app, Label4 contains only numeric values or is sometimes empty.
0
4
Darren Neese
Tarek Marach
New comment 2d ago
Your PowerApps New Discovery! Share Here!
What are the features of PowerApps that you recently discover and how did it improve your business or office work performance?
6
17
Fabian Van Wyk
Wes Benson
Scott Hoyt
Rianne Estella
Kendall Outlaw
New comment 3d ago
Filter with And() and Or()
I am working on a custom filter for a gallery where the user may choose to filter from multiple fields. I found a great video on the subject from Reza Dorani, but I have no idea why it works. It works very well in my application, but because I don't understand why it works, I am hesitant to publish it. If anyone can explain why the And and the Or aren't returning true/false results, I would love to understand it better. Here is my sample code (I have shortened the list from 6 Or()s to just 2 for the example: Filter( 'Price Change', And( Or( IsBlank(drp_CustomSearch_PriceRequestStatus.Selected.Value), 'Price Request Status' = drp_CustomSearch_PriceRequestStatus.Selected.Value ), Or( IsBlank(drp_CustomSearch_CPQStatus.SelectedText.Value), 'CPQ Update Status' = drp_CustomSearch_CPQStatus.Selected.Value ) ) ) In each Or() case, if the first argument is false, the second argument is executed in the filter. If argument 1 in both Or()s is true, the whole list is returned. If the status dropdown has a value, then the list is returned with that field filtered on the dropdown value. I just don't get why the Or seems return something other than true/false in this case. Link to Reza's video: https://www.youtube.com/watch?v=1QflzfPyPe0 Applicable coding starts at about 5:00. Thanks for any improvement in my understanding.
2
10
Elvis Eyobor
Brett Woodward
Guy Johnsen
Eric Gamble
New comment 3d ago
[SOLVED] Should the results be placed in a variable?
I am using the following code to allow users to filter a large dataset. The results of the filtered not only populates the gallery but is also used to calculate some aggregate numbers. Currently the filtering logic is duplicated for each aggregate calculation. Am I able to placed the filtered data into a variable and then use that variable for the gallery and the various aggregate calculations? Sort( Filter( pudo_load_searches, ( // search within a PO# (IsBlankOrError(tbSearchPO.Text) || tbSearchPO.Text in load_po) && // search a booking date range (IsBlankOrError(searchDatePicker1.SelectedDate) || load_booking_date >= searchDatePicker1.SelectedDate) && (IsBlankOrError(searchDatePicker2.SelectedDate) || load_booking_date <= searchDatePicker2.SelectedDate) && // search for equipment type, make, and/or model (IsBlankOrError(tbSearchEquipType.Text) || tbSearchEquipType.Text in item_equip_type) && (IsBlankOrError(tbSearchMake.Text) || tbSearchMake.Text in item_make) && (IsBlankOrError(tbSearchModel.Text) || tbSearchModel.Text in item_model) && // search for the Min/Max of weight, Length, Height, and/or width (IsBlankOrError(tbSearchMinWeight.Text) || item_weight >= Value(tbSearchMinWeight.Text)) && (IsBlankOrError(tbSearchMaxWeight.Text) || item_weight <= Value(tbSearchMaxWeight.Text)) && (IsBlankOrError(tbSearchMinLength.Text) || item_length >= Value(tbSearchMinLength.Text)) && (IsBlankOrError(tbSearchMaxLength.Text) || item_length <= Value(tbSearchMaxLength.Text)) && (IsBlankOrError(tbSearchMinHeight.Text) || item_height >= Value(tbSearchMinHeight.Text)) && (IsBlankOrError(tbSearchMaxHeight.Text) || item_height <= Value(tbSearchMaxHeight.Text)) && (IsBlankOrError(tbSearchMinWidth.Text) || item_width >= Value(tbSearchMinWidth.Text)) && (IsBlankOrError(tbSearchMaxWidth.Text) || item_width <= Value(tbSearchMaxWidth.Text)) && (IsBlankOrError(tbSearchMinDistance.Text) || load_distance >= Value(tbSearchMinDistance.Text)) &&
0
4
Eric Gamble
Kendall Outlaw
New comment 3d ago
Highlight the Active Record in a Gallery
1) Select the Gallery. 2) Place the code below In the Template Fill property: If(ThisItem.IsSelected,RGBA(0,255,255,.5),RGBA(255,255,255,1))
3
1
Elvis Eyobor
New comment 4d ago
Extract Invoice Details With Power Automate And AI Builder
Power Automate can use AI Builder’s prebuilt model to effortlessly identify and extract the details from an invoice. Then additional actions can be added to write the invoice data to an Excel spreadsheet, a SharePoint document library or even use Power Automate Desktop to enter them directly into an Accounting system. There is great potential here to drastically reduce manual data-entry. In this article I will show you how to automatically extract invoices details using Power Automate & AI Builder. Table of Contents • Introduction: The Invoices Library With Automated Data Extraction • Create A SharePoint Document Library • Get An Invoice PDF File From The Document Library • Extract Invoice Details Using AI Builder • Test The Invoice Data Extraction Flow • Determine Whether An Invoice Requires Manual Review With Confidence Scores • Tag An Invoice As Needing Human Review In SharePoint • Run The Flow To Test The Needs Human Review Feature
14
8
Elvis Eyobor
Guy Johnsen
Howard Nathan
Isaacs Luf
Michele McBride
New comment 5d ago
Trouble with buttons
Hello everyone, here is my question: I connected my app to a SharePoint list. I have a question with two options, and I want this question to be answered from the home page with the buttons. Clicking one or the other should save the response to the question. Then, using the formula 'Navigate(Screen2),' it will take me to the next screen to continue answering the other questions in the form. How can I configure these two buttons? Or there is any video that explain this?
0
5
Kendall Outlaw
Elvis Eyobor
Bryam Najera
New comment 5d ago
Light Bulb Finally Warming Up - The power of Selected()
The following is one of those situations other programmers would think (or say) "you did not know that?". CONTEXT: Navigating from one screen to another. Ol' Dog Thought: Moving from "Here" to "There" goThere(stuff_From_Here_01, stuff_From_Here_02, stuff_From_Here_03, stuff_From_Here_n) POWER APPS Env: [once on the THERE screen] - reference the stuff from the HERE screen Navigate(There) txtbox01.Default = hereGallery.Selected.field_01 txtbox02.Default = hereGallery.Selected.field_02 txtbox03.Default = hereGallery.Selected.field_03 txtboxN.Default = hereGallery.Selected.field_N No passing of parameters needed. The record you just selected on the HERE screen is still selected. therefore you can reference the fields from that selected record (Session Aware).
5
6
Darren Neese
Eric Gamble
Elvis Eyobor
New comment 6d ago
Live Stream Today - 11/25/23 - 10am EST
- https://youtu.be/4z4ftdGX6zE
6
0
The Easiest Way to Put in a Menu in Your Canvas App
I do have a popular video here: https://youtu.be/P5TQWgYaEc0 ...where I walk through how to create a menu in canvas Power Apps. It is done the "right way" by creating it as a component, and I actually use what I create there in my own portrait template. Just this morning, I had a comment on that video by @WeedsePoentah asking: "This seems like such an unconvential way, Is this not possible in a more direct way in powerapps?" My answer...? There has never been a menu control, as of yet, in canvas Power Apps. However, Microsoft did release a new series of controls called the "modern controls", wherein you can find a "Tab List" control. You could use that as a menu. It even has an Alignment property where you can make it vertical. I plan to make a video on this soon! 😋 ...have you guys looked at this control before?
4
11
Howard Nathan
Darren Neese
David Abew - Baidoo
New comment 7d ago
Power Apps in Teams
Do You Use Power Apps in Teams ? If so, what has been your experience?
Poll
4 members have voted
1
8
Darren Neese
Elvis Eyobor
Kendall Outlaw
Kelley Heath
New comment 7d ago
From my previous post i filtered a >90k sheet with office script in PowerAutomate, now i need to only post new records found
My previous flow i am filtering excel sheet with 90k rows on specific records/rows with office script, I am getting them and posting on a teams chat this is working fine. This flow runs every 20min and get the data and most times it is the same data every 20min. I now need to only post new records/rows found, so every time i get the file my flow filters the sheet and get the strings and rows i need, but if the found records is the same as last run i do not want to post the message to the chat, only when a new record/row is found. See my below screenshot in teams in the 3 teams posts i see the 1st two posts and the 3rd has the exact same first 2 rows/records found and then the 3rd one has a new record/alarms highlighted in green found so i only want to post the new record/row found.
2
6
Elvis Eyobor
Fabian Van Wyk
New comment 7d ago
🚀 Hey PowerApp Pioneers! 🚀Do you have a question/suggestion?
🔊 ATTENTION, tech-savvy trailblazers! 🤓✨ Are you lost in the PowerApps wilderness, grappling with questions or thoughts? Fret not! 🤔🌐 Our squad of PowerApps aficionados is on a mission, armed with magnifying glasses and coffee mugs, to seek out and conquer your queries! ☕🕵️‍♂️ ⚡️ Don't let those challenges turn your development journey into a snail's pace! 🐌🚫 Let out a mighty roar for HELP, and our heroes will swoop in with capes fluttering, ready to rescue you from the clutches of confusion! 😱💪 Remember, in the realm of PowerApps, there's no problem too big or question too small. Together, we shall triumph over the coding conundrums! 🎉💻 So, fellow tech explorers, unleash your questions and thoughts – the PowerApps party is in full swing, and you're invited! 🎈🚀 Let the digital festivities begin! 💃🕺 #PowerAppsPalooza #TechRescueSquad
4
0
Images not showing in gallery
Hello i got an issue about base64.. I've been watching https://www.youtube.com/watch?v=XS0IJEE6uLo and made the same solutions like Darren. The issue is my gallery is not showing anything. Maybe im missing something?
1
1
Elvis Eyobor
New comment 7d ago
Capture date and time everytime clicking on buttons
Hi everyone, I have sharepoint list linked to powerapps form. The Powerapps form has 3 buttons as validation process. The question: is there a way to capture date and time the user and approver click on button to submit. My goal is to add columns to SharePoint list and capture these times/dates for each record. Thank you. I am available for explaining more if anything not clear.
3
2
Darren Neese
S Gates
New comment 8d ago
Patch to lookup column
How to patch to lookup column in list
1
4
Elvis Eyobor
Muni Al
New comment 8d ago
Uploading Files into Dataverse from a Power Apps Gallery
I recently found a solution to uploading files to a specific record in a Dataverse table. I have posted my solution below with screenshots. You will see that I have a column in my Dataverse table called num which assigns every record in the Dataverse table a unique number. The code in the update button matches the number that the user is working on to the same number that is in the Dataverse table. That is how I was able to update the record with the attachment. Just wondering if anyone else has a similar problem?
Poll
1 member has voted
0
3
Elvis Eyobor
Kendall Outlaw
Darren Neese
New comment 8d ago
1-30 of 278

Public group

A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!

Leaderboard (30-day)

powered by