Hello! Great video! I have a dataverse question. I am trying to move my access database over to Dataverse so I can use powerapps and PowerBI with my data. I'm working on moving my tables over and getting the data types straight and I had a question about the formula data type in the dataverse columns. How would I go about multiplying Column 1 from Table 1 by Column 2 from Table 2 with the column creation being in Table 1? I tried to use an if statement stating that if the IDs are equal in both tables, then multiply the values from the two columns. I currently have this line of code: If(Table1ID = Table2.Table2ID, Column1 * Table2.Column2) and it returns nothing. I have a Many:One relationship between Table 1 and Table 2. Thank you for your help!

This was the 4rth time I started watching this video. The duration is very intimidating so I thought I would start only on a day where I would have enough time to cover a substantial bit of this video so that I don't leave it in between. However, once I got into the groove, it was bingeworthy. I learnt so much from just the first 37 minutes that I didn't want to stop. I like the way you make things very simple, think on the fly, and do loud thinking. PowerApps is not something someone can learn just by following instructions, you need to have a thought process and your way of teaching helps students develop that. Thanks a lot, keep coming up with such videos, but do add a disclaimer - "Don't get scared by the video length, the stuff discussed in here is fairly easy to grasp" This would definitely encourage students like me who have a little bit of basic knowledge and want to take it to the next level. Thanks again, you are awesome!

remove this captions or titles from video they are annoying

How are you planning to get the player data into the database? is there an API you will leverage?

I loved this idea so much that I made it my first SQL DB in learning SQL. So I have it on eval for 6 months. that takes me right up to playoffs. Its perfect. Do you have or know of any videos on setting up the tables in SQL? I'm using GPT for that but would love to see it done as well.

I actually tried recreating my company's app a couple of days ago using this new feature in preview mode. The real challenge is customizing the app because, even though the app I made is different from your demo app, it looks the same, lol. I want to have a sidebar for the menu, sub-menu, footer, etc., not just data from a Dataverse table with a scroll bar on the side. I also noticed in the video that you've put the year of the car in numbers, but you can also ask Copilot to change the type of that variable. For example, 'Change Year column type to Text' to remove the comma in '2,020.' I am also curious about the tables created in that way. Can we put them in one solution so they're not mixed with the default tables? Additionally, if we've created those tables and saved them to build the app, is it possible to later add another table, connect it to an existing table, and rebuild it again?

I may be too naive, but so far, AI is good to create/affect lot of data faster. Everything details (like title, create single column ) you try in this video seems faster if you do the changes by yourself instead of typing to the AI. The fact that it can create all the table at once is really interesting. I repeat, it’s my modest opinion

Great video to get started with Power Apps, thanks Darren

Haha, he sounds bored with what he's doing

Still buggy in July 24. Before publishing a new version of your app you need to remove them from data sources then add them back in.

Great video. Please could you share how to do this but adding data to a new excel sheet that generated each time the power app is used? Perhaps using automate flows for this?

Hi Is it possible to get a copy of your jump starter kit?

🎯 Key points for quick navigation: 00:09 *🛠️ Workshop Setup and Introduction* - Setting up the live stream and beginning the workshop. - Preparing for the session by setting properties and ensuring everything is ready for the audience. - Introduction to the workshop's main focus: creating an organizational chart application. 02:06 *🖥️ Creating User Database and Using SharePoint* - Explanation of building a user database table and using SharePoint as a data source. - Discussing the importance of updating M365 profile photos and how the workshop will address this. - Offering help with using other data sources like Dataverse or SQL Server if needed. 05:07 *🔧 Workshop Topics and Future Planning* - Encouraging participants to suggest topics for future workshops. - Mention of upcoming PPC videos and planning future workshops in advance. - Sharing meeting notes and relevant links with participants. 07:12 *🎶 Music and Workshop Environment Setup* - Adjusting the music volume and discussing the setup for the workshop. - Creating a new table in SQL Server for the workshop. - Announcement of a special offer for the workshop participants. 11:21 *📊 Exploring Power Apps Templates and Features* - Looking at various Power Apps templates and their applications. - Discussing the pros and cons of different templates, especially the org chart template. - Sharing links and resources for participants to access templates and features. 16:03 *🚀 Adding Features to Templates* - Discussing the addition of features like user profile screens and start screens to the template. - Examples of customizing user settings and preferences in the app. - Encouraging participants to follow along and build the app during the workshop. 21:20 *🧩 Using ERD and Data Mapping in Power Apps* - Demonstrating the use of ERD (Entity-Relationship Diagram) in Power Apps. - Attempting to create multiple tables and explaining the related features. - Discussing the use of Power Apps Co-pilot and its limitations. 27:00 *🔄 Finalizing Workshop Elements* - Final adjustments and troubleshooting in the workshop setup. - Discussing various Power Apps functions and how to capture and display user data. - Wrapping up the main content and preparing for interactive Q&A. 29:50 *📝 Discussion on User Notes and Preferences* - Considerations for adding HR notes and personal user notes, - Sharing links and information with participants, - Discussing the creation of user preferences and relevant fields. 31:05 *🧩 Setting Up User Preferences and Fields* - Importance of not storing sensitive information like passwords, - Use cases for creating PINs for user accounts, - Explanation of how to lock down SharePoint lists for security. 33:14 *🛠️ Building Preference Tables and User Mappings* - Creation of app preference tables and their structure, - Setting up a mapping table for user preferences, - Explaining the many-to-many relationship between users and preferences. 36:07 *📊 Integrating Office 365 Users Connector* - Demonstrating how to use the Office 365 users connector, - Creating a new screen to display user profile information, - Capturing and displaying different user properties from the connector. 47:23 *💼 Admin Portal and User Information Management* - Showing how to manage and update user information in the Microsoft admin portal, - Explaining the importance of filling out user details for accurate data representation, - Demonstrating how updates reflect in the Power Apps application. 54:04 *🎨 Customizing User Profile Display* - Setting up the display for user profiles with various properties, - Adjusting the design and layout of user profile information, - Adding interactive elements like clickable links for user sites. 01:00:10 *🔄 Retrieving and Displaying User Profiles* - Methods for retrieving specific user profiles using email or ID, - Discussing how to display relevant user information dynamically, - Preparing the layout for showing various user properties. 01:03:12 *🧾 Finalizing User Information and Preferences* - Identifying key user information to include in the profile display, - Organizing and structuring the layout for user details, - Wrapping up the main content and outlining plans for the next session.

How to get post api response in power apps having post body with some mandatory field

Great tutorial. I was wondering what if I have sub pages that is not any of those buttons. How do I turn off the selected fill? It seems to be on 'Home' by default on a subpage.

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

kzfaq.info/get/bejne/edmEhZB4zLmomo0.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 ⬅