Видео

Fantastic, EXACTLY what the Dr ordered! Question: Where and what would you enter in the filter to show all records if nothing was chosen in the combobox?

Do you have the link to the Combobox Vid? Cant find it on your channel

Great video! Have you used the Notify function for user messages? It displays at the top and is used for error messages and success messages.

Wow very cool

Did something happen to the video?

I love this idea!

Nice video! I'm not much of a database person, but I'm very curious about how you connect multiple sharepoint lists together in a 1 to 1 relationship using the ID column as the primary key. Surely, if the lists have a different amount of records those ID numbers won't match up to another list ... can you explain how you get the two lists to connect via this ID?

Darren is the man!

But AddColumns functions is still not delegable right?

Great stuff. Thanks!

Hi Sir your video is very informative and quite detailed.thanks. I sm just wondering if you have video training also of the template you use before you start this video. Thanks very much

This is fantastic... I am starting to learn and this is one of the most comprehensive tutorials out there... Although you need to combine it with several other learnings but still it is one of the best and detailed one. Thanks. Patch function is now my favorite and I also created the IF function for the gallery using my knowledge from other watching tutorials, so it was a good practice. Thanks!

What if custom connector api has no parameters, not getting reaponse in this case help me out with formula

ruclips.net/video/CsTR-GgSDjY/видео.html Can you build something like this?

Awesome buddy... I am creating my first model driven app for Innovation tracker. So If any one in organization have innovation idea then user can log that in my model driven app. later on it will get validated and approved. For that I was in need to create an INNOVATION_ID. I don't want to use Power Automate. So I spend more than 8 to 9 hours on internet and found your video on youtube which is perfect best fit for my requirement. you are my savvier !!

Thank you!

What is the difference between 'Save Changes' and 'Upload Now'?

hey Thanks so much for your time in sharing this video can you please share Excel file? dont find in your portal as well.Thanks

Hi actually I was using a List in Share point . In That List there is column where we can search and select employee id(People type) . When I am conneting that with EDit Form I am getting a drop down list where if i search and click user id and save it will save in that list But When I am Trying select Default Selected Item as Office365 user Id it will select but after saving the form it will not send that data to list as There was no click operation from suggestion box. If you have any idea Please share ?!

Would this also work if the excel file is in a Sharepoint folder?

🎯 Key points for quick navigation: 00:00 *🔧 Modernizing Power Apps* - Discusses recent disruptions and how they are managing them. - Highlights the importance of modernizing Power Apps for a more elegant and modern user experience. - Example of revisiting app settings to apply modern themes and controls. 02:27 *🎨 Applying Modern Themes* - Explanation of applying modern themes to classic controls in Power Apps. - Emphasizes the need to save a restore point before applying new themes. - Discussion on the benefits of using modern themes for a cohesive user interface. 04:15 *📅 Workshop Overview* - Introduction to the upcoming workshop focused on modernizing Power Apps. - Details about affordable pricing and the value provided in these workshops. - Encouragement for participants to bring their older apps for modernization exercises. 06:51 *🛠️ Refactoring and Updating Apps* - Explanation of refactoring old Power Apps to use modern formulas and functions. - Importance of updating from imperative to declarative code for better efficiency. - Example of converting a clear collect function to a declarative table function. 11:27 *📚 Practical Exercises in Workshop* - Description of practical exercises planned for the workshop. - Focus on moving imperative code from app on-start to app formulas. - Benefits of using declarative code for dynamic updates and easier maintenance. 16:06 *💡 Advanced Tips and Tricks* - Discussion on advanced features and tips for using Power Apps. - Importance of continuous learning and adapting to new updates in Power Apps. - Encouragement to join workshops to stay updated and enhance skills. 20:56 *🚀 Power Apps Accelerator* - Introduction to the Power Apps Accelerator program for rapid skill development. - Details on how the program helps IT professionals and developers with projects and skills. - Invitation to join the program for personalized guidance and accelerated learning.

🎯 Key points for quick navigation: 00:00 *📱 Introduction to Microsoft Power Apps* - Microsoft Power Apps allows the creation of apps for organizations using various data sources. - Designed for citizen developers with minimal coding, similar to Excel functions. - Demonstrates the ease of creating an app with Power Apps, introducing the new Co-Pilot feature for beginners. 01:55 *🔄 Power Platform Components and Integrations* - Power Apps is part of the Power Platform, which includes Power Automate for automation and Power BI for reporting. - Supports over a thousand connectors to integrate various applications and databases like SQL Server, MySQL, and PostgreSQL. - Co-Pilot feature assists in creating database tables and app designs, simplifying the development process. 03:42 *🛠️ App Creation and Customization with Co-Pilot* - Demonstrates creating a database for dad jokes using Co-Pilot and customizing the app generated. - Shows how to modify app controls, set default values, and ensure data validation within the app. - Highlights the improvement and evolving capabilities of the Co-Pilot feature for better user experience. 06:12 *🖥️ Advanced Customization and Data Management* - Explains advanced customization of the app, including setting properties and handling data updates. - Emphasizes the flexibility of Power Apps in managing data and creating responsive designs for different devices. - Illustrates the process of forcing text boxes to accept only specific types of input, enhancing data integrity. 09:11 *🚀 Exploring Templates and Rapid Development* - Showcases the variety of templates available in Power Apps for rapid application development. - Provides an example of an onboarding task app template, demonstrating how connectors and services are integrated. - Encourages exploring different templates to understand the potential and versatility of Power Apps in various scenarios. 11:27 *🎨 Building and Customizing Screens* - Discusses the ease of modifying screens and controls within Power Apps, using Excel-like functions. - Demonstrates navigating between screens and setting up interactive elements in the app. - Highlights the extensive customization options available to tailor apps to specific organizational needs.

Thanks a lot, very well explained

Hi! one question, can you put two collections or more in a datatable? if so, how? thanks!!

I have a note application which has a question "do you have anything to add to the do list" and then there is text field (microsoft forms) that accepts items separated by a comma. the intention is to have some power sutomate magic that calls the the task app as soon as the note is completed, I"m going to change this to a radio button and then on Yes I want to open the task app. I love to know how to make that work.

🎯 Key points for quick navigation: 00:00 *📝 Overview of template inspiration and customization* - Overview of starting from scratch using Microsoft's service desk template. - Customization approach to sidestep issues from the original template. - Plans to integrate YAML code copying feature into the Power App. 01:52 *🛠️ Choosing SharePoint over SQL Server for backend* - Decision to use SharePoint due to accessibility without premium licensing. - Discussion on how similar functionalities would apply to SQL Server or Dataverse. - Considerations for adapting functionalities based on different database environments. 02:48 *🖥️ Designing the dashboard screen* - Detailed walkthrough of designing and cleaning up the dashboard UI. - Removal of unnecessary features like forms and unnecessary controls. - Integration of navigation controls for improved user interaction. 10:13 *🎨 Implementing color coding with Switch statements* - Introduction and comparison of using Switch statements over nested if-else for cleaner code. - Implementation of color-coded status indicators based on ticket status. - Explanation of declarative versus imperative coding in Power Apps properties. 23:01 *🖥️ Customizing ticket display in Power Apps* - Adjusting gallery template size for better visibility. - Naming and setting dynamic properties for UI elements. - Discussing the benefits of clear UI organization for user understanding. 25:54 *🎨 Designing a header bar for ticketing system* - Creating a header container with color theming. - Aligning labels dynamically within the header bar. - Importance of consistent design for scalability and user interaction. 42:06 *🛠️ Using dynamic positioning for UI elements* - Applying dynamic X and Y positioning for labels within a gallery. - Demonstrating the flexibility of dynamic UI adjustments. - Discussing the educational value of interactive UI development projects. 52:00 *🖌️ Customizing visual elements in the Power App* - Customizing visual elements such as icons and circles in the Power App interface. - Adjusting dimensions and positions using Power FX expressions. - Exploring color schemes and visual alignments for better UI/UX. 57:26 *🛠️ Implementing screen navigation and user interactions* - Configuring screen navigation using the `Navigate` function in Power Apps. - Managing user interactions with buttons and input controls. - Utilizing imperative functions like `Patch` and `Back` for data updates and screen transitions. 01:00:04 *🎨 Styling buttons and enhancing user interface* - Applying styles to buttons using different types and properties. - Enhancing UI elements with modern controls like text inputs and labels. - Incorporating design principles for better visual appeal and user experience. 01:17:41 *📝 Creating a new record entry and styling adjustments* - Demonstrates adding a new record to an app. - Adjusts UI styling such as row height and label colors. - Addresses syntax errors and adjusts UI elements for better alignment. 01:19:06 *🛠️ Delegation issues and handling data sources* - Discusses delegation challenges with SQL Server and SharePoint. - Mentions strategies to overcome delegation issues. - Previews upcoming workshop on mastering delegation. 01:21:07 *🎨 Customizing UI elements and color themes* - Explores customizing UI elements using FX themes. - Adjusts color schemes and evaluates aesthetic preferences. - Demonstrates creating a custom gray color for UI components. 01:38:03 *🖥️ Rapid development of CRUD screens from SharePoint data* - Shows rapid creation of CRUD screens from SharePoint lists. - Copies and adapts UI components across screens. - Discusses the use of YAML for screen creation and customization. 01:45:10 *🎨 Screen Design and Functionality Adjustments* - Adjustments made to screen layout and color scheme. - Copying template fill code to ensure consistency across screens. - Adding transparent elements and resizing accents for visual appeal. 01:46:40 *🛠️ Customizing UI Elements and Functionality* - Configuring form elements for user interaction. - Ensuring visual and functional consistency across UI components. - Exploring options for optimizing screen layout and button functionalities. 01:48:34 *🔄 Implementing CRUD Functionality for Departments* - Creating CRUD screens for managing departments. - Utilizing patch statements for data updates. - Exploring UI design choices for user-friendly navigation and interaction. 01:55:11 *📝 Setting Up Questionnaire Functionality* - Designing a schema for managing questionnaires and answers. - Defining table structures and relationships in SharePoint. - Discussing implementation strategies for question types and answer formats. 02:01:06 *📊 Advanced Table Design and Configuration* - Refining table designs to accommodate various question types. - Discussing best practices for handling boolean values and choices. - Exploring data validation and integration with app functionalities. 02:09:34 *🗂️ Configuring Answer Management and Relationship Handling* - Setting up a separate table for managing answers linked to tickets. - Avoiding lookup columns in SharePoint for better data management practices. - Planning for future scalability and usability of the implemented data structures. 02:10:35 *🛠️ Building a basic CRUD screen for ticket management.* - Setting up basic functionalities for managing tickets. - Customizing screen layout and UI components. - Implementing best practices recommended by Microsoft for screen naming. 02:13:47 *📝 Creating and managing different ticket statuses.* - Defining various ticket status types such as 'New', 'Resolved', 'In Progress', 'On Hold', and 'Closed'. - Configuring form elements to display and manage ticket status data. - Discussing the importance of consistency and standard practices in app development. 02:18:53 *🔄 Implementing question management in the application.* - Integrating functionality to manage questions within the application. - Utilizing dropdowns and text inputs dynamically based on question types. - Demonstrating how to handle multiple question types and their data representations efficiently.

🎯 Key points for quick navigation: 00:00 *🌟 Introduction to Power Apps Code View* - Introducing the new Code View feature in Power Apps Studio. - Highlights the excitement over this new feature surpassing previous updates like name formulas and user-defined functions. 01:19 *🛠️ Exploring YAML Code Structure* - Demonstrates accessing and navigating the YAML code for controls in Power Apps. - Shows how to view and interpret YAML properties such as X and Y coordinates, essential for control customization. 03:08 *🔍 Benefits of Copying Code Snippets* - Illustrates how to copy code snippets from one control to another within Power Apps. - Discusses the practical applications of copying YAML code for reuse and sharing among different app components. 06:50 *📄 Viewing and Manipulating Entire Screen YAML* - Shows how to access and modify YAML code for entire screens in Power Apps. - Highlights the capability to manage multiple controls and their configurations within screen YAML. 09:20 *🚧 Preview State and Future Developments* - Discusses the current preview status of the Code View feature in Power Apps. - Mentions upcoming enhancements like editable YAML editing and advanced customization options. 13:30 *🖥️ Integration with External Code Editors* - Explores using external code editors like VS Code for editing copied YAML code. - Highlights potential future extensions and tool integrations for enhanced development workflows. 23:15 *🛠️ Creation of environments and community feedback* - Discussion on creating environments with new features. - Community feedback on the usefulness for documenting control setups. - Importance of control and flexibility in software development. 24:08 *🖥️ Managing complex layouts and invisible containers* - Challenges with managing complex layouts in Power Apps. - Benefits of accessing properties easily with YAML code view. - Use cases for managing invisible containers and interacting with layered controls. 25:34 *🎨 Customizing galleries and interface interactions* - Demonstrating customization of galleries using YAML code. - Interface enhancements through color and template adjustments. - Managing interactions and interface components more efficiently. 26:35 *🧩 UX/UI improvements and user interface adjustments* - Changes in UX/UI elements like navigation bars. - Exploring the impact of UI adjustments on user experience. - Addressing challenges with interface elements overlapping. 28:00 *🚀 Future enhancements and integration possibilities* - Excitement around upcoming features for code-first developers. - Integration possibilities for collaborative programming efforts. - Speculation on future enhancements and Microsoft Build updates. 29:22 *📄 Documentation and feature exploration* - Accessing detailed documentation and resources for new features. - Future potential for editing directly within Power Apps Studio. - Emphasis on transparency and software project management. 30:58 *🔍 Functionality insights and usability tips* - Detailed exploration of functionality insights with Power FX. - Usability tips for turning on preview features like the Power FX formula bar. - Enhancing usability through advanced functionality insights. 32:41 *🛑 Limitations and current constraints* - Discussion on limitations such as no code view for app objects. - Workarounds using external tools like Power Apps Soapa. - Managing known limitations in current feature sets. 35:19 *🌐 Community engagement and content sharing* - Encouraging community engagement through content sharing platforms. - Subscription-based access to exclusive content and resources. - Plans for expanding community contributions and template updates.

Exactly what i needed thanks

ok but how do I add an "ALL" selection to the dropdown list???

Was interested until you said dataverse. Oh well.

Just yesterday I was following your guide

I’ve been wanting to replace our KACE system!! I’ve been wondering of PowerApps is the way to go.

This is a great replacement for ServiceNow! Looking forward towards more content

Thank you so much, it is really useful video.

🍬 Get the popular Power Apps crash course and access to my free community: www.skool.com/power-apps-community ⬅

@PowerAppsTutorial Love the video and i "reverse engineered" how this app works and created my own version of an Onboarding app with the Microsoft To-Do (Business) connector. I was wondering if you know of a way to store a task with the HTML in its body in a collection and to keep the content type as html? When i store it in the default way - it stores the body with a content type of a Text and not HTML (even if i created it using the app as a HTML).

Great demo. I'd love to see more of the build out of this APP. 😊

I recently went back to watch this again. Yes, I'd love to see this APP further in regards to adding other data type questions such as drop down ratings 1-5 are other drop down question categories that the answer data type is different.

Nice, I missed a function that would make de debuging toggle visible or not depending on if the user is a developer or not.

What do you recommend instead of using choices in SharePoint? We want to avoid creating another list for instead of choice columb and the values from that choice column needs to be shown in more than one other list.

How can we disable ?

This is an interesting point about the "Future of Power Apps". Recruiters have wanted me to apply to BMW, Walgreens, Capitol One and other large companies that are pushing for it. Makes me feel secure in taking the deep dive into Power Platform.

I like the modern date picker, but can't do dd/MM/yyy

Very cool and informative!

interaction with ai is gonna be so much easier. hope they push this faster without compromising quality.

Hey Darren, awesome series of videos ...newly subscribed. I am using a choice box to auto fill in a form. The text inputs work fine my issue is the dropdowns wont come in with the .selected based off the combo box etc... how should I go about formatting the dropdowns to pull the selected dropdown from the combobox...btw I am using Dataverse tables and canvas app

Everyday is Saturday!!! I love that, Kurt!!!! ❤️💯

You are a godsend! Do you know how long I have been trying to do this??? Thank you so much!

This is a great feature but I still don’t have it.