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.

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.

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?

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!

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.

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.

I guess... technically it's possible.

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?

If You Were Tasked to Create a Tool that is needed to Track Metrics, Which Tool Would You Use? And Why?

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.

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

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?

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?

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.

What are the features of PowerApps that you recently discover and how did it improve your business or office work performance?

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.

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)) &&

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))

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

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?

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).

- https://youtu.be/4z4ftdGX6zE

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?

Do You Use Power Apps in Teams ? If so, what has been your experience?

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.

🔊 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

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?

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.

How to patch to lookup column in list

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?