PowerApps: Build a full business app in 10 minutes – THR2072

PowerApps: Build a full business app in 10 minutes – THR2072


>>>ALL RIGHT. LET’S GET STARTED. IT’S 4:00. WHAT WE’LL COVER TODAY IS HOW TO BUILD A FULL BUSINESS APP IN TEN MINUTES ON POWERHOUSE. NOW, IF ANY OF YOU ARE FAMILIAR WITH POWERHOUSE, QUICK RAISE OF HANDS WHO HAS USED IT BEFORE. YOU PROBABLY USED THE CANVAS APPS WHERE YOU DRAG AND DROP THINGS IN PLACE. YOU HAVE THE FORMULA BAR. YOU PROBABLY CAN’T BUILD A FULL APP IN TEN MINUTES USING THAT WAY OF APP BUILDING. RAISE OF HANDS WHO IS FAMILIAR WITH USING D365 CUSTOMIZATION? A HANDFUL. THIS SHOULD LOOK FAMILIAR TO YOU. YOU GO TO THIS BOTTOM LEFT-HAND CORNER, YOU WILL SEE HOW TO BUILD MODERN DRIVEN APPS. THIS WAY ALLOWS YOU TO CREATE MANY MORE SCREENS, MORE COMPONENTS, MUCH FASTER THAN THE TRADITIONAL WAY. WHAT WE’LL BE DOING IS HELPING A CHARACTER NAMED RYAN. HE WANTS TO BE ON THE POWER PLATFORM AND USE THE COMMON DATA SERVICE. HE IS TRYING TO MANAGE ALL THIS ORDER. HE HAS PEOPLE TRYING TO ORDER PARTICULAR ITEMS. RIGHT THERE IN THAT ONE INCIDENCE WE HAVE THREE DIFFERENT TYPES OF ENTITIES WE WANT TO MODEL AND THEN AUTOMATICALLY GENERATE AN APP FROM. TODAY WE’LL SET UP MORE ENTITIES. ADD SOME BUSINESS LOGIC. SHOW YOU WHAT THAT IS LIKE IN POWER APPS. CREATE A FEW COMPONENTS, CREATE A FORM. AT THE END WE’LL WRAP THIS TOGETHER IN A SINGLE APP. WE’LL BE DOING THIS FOR TEN MINUTES. BETWEEN TALKING, CLICKING, REALLY SLOW WIFI, I MIGHT MISS THIS MARK, SO BE KIND TO ME. LET’S GET STARTED. WE’RE IN THE MODEL DRIVEN AREA. A LOT OF PEOPLE HAVE BEEN ASKING ME WHAT IS THE COMMON DATA SERVICE, IF YOU GO INTO POWER APPS, BASICALLY EVERYTHING UNDER HERE IS CDS. WE CAN SEE ALL OF THE OUT OF THE BOX ENTITIES THAT CDS COMES WITH AS SOON AS YOU PROVISION YOUR DATABASE. AT THE TOM WE HAVE ACCOUNTS. THAT’S ONE ENTITY WE NEED. WE DON’T HAVE TO REBUILD THAT. WE CAN GET STARTED WITH THE ITEMS. RYAN ALREADY HAS A LIST OF ITEMS IN AN EXCEL SHEET. THIS SHOULD BE EASY TO BRING INTO CDS. SO HOW DO YOU GO ABOUT DOING THAT? UP TOP WE HAVE A GET DATA BUTTON WHAT IS OPENING NOW IS POWER QUERY. THIS SHOULD LOOK FAIRLY FAMILIAR. WE WILL GET THE URL TO OUR EXCEL DOCUMENT. NICE. PASTE THAT IN. WE’RE SIGNED IN. CLICK NEXT. THIS IS PULLING IN ALL THE DATA OF THE EXCEL DOCUMENT SO WE CAN ULTIMATELY BUILD AN ENTITY FROM IT. IT WILL CREATE A SCHEME FROM DIFFERENT COLUMNS. THIS IS THE POWER QUERY BIT THAT SHOULD LOOK FAMILIAR TO YOU. WE CAN HAVE CHANGES TO WHOLE NUMBER OR MINIMUM NUMBER OF THINGS YOU HAVE TO ORDER. THIS IS A CURRENCY, THE COST OF THE ITEM. YOU CAN CLICK NEXT. HERE WE WILL TELL IT WE’LL BUILD A BRAND-NEW ENTITY TO BRING IN TO CDS. SO IF YOU WANTED TO, IF YOU ALREADY HAVE IT, AND YOU WANT TO PULL IN EXTRA DATA, YOU CAN DO THAT AS WELL. THEN PRESS THE CREATE BUTTON. IF I ALREADY CREATED THIS BECAUSE IT TAKES TIME FOR IT TO LOAD IN. WE’LL SKIP TO THE ORDER. HERE I WANT TO SHOW YOU WHAT IT’S LIKE TO CREATE AN ENTITY FROM SCRATCH. IF YOU CLICK UP HERE, TO NEW ENTITY, WE CAN GIVE IT A NAME. THIS IS VERY SIMILAR TO CREATING A TABLE IN SQL. WE’LL CALL THIS ORDER. NEXT. WE CAN SEE THE DIFFERENT PROPERTIES OF THE ENTITY. WHAT WE’RE FIRST GOING TO DEAL WITH ARE THE FIELDS, THE COLUMNS WITHIN THE ENTITY. I WANT TO CALL THIS SUMMARY. SOME OTHER THINGS WE PROBABLY WANT TO KNOW, HOW MANY OF THE ITEMS ARE WE ORDERING. THAT’S A WHOLE NUMBER. YOU CAN SEE THE DIFFERENT DATA TYPES WE SUPPORT. MAYBE WE WANT A DISCOUNT IF A CUSTOMER IS KIND TO US, WE WANT TO SHAVE OFF SOME OF THE COSTS. I WANT TO SHOW YOU MORE ADVANCED DATA TYPES THAT WE HAVE. IF WE’RE GOING TO ORDER TYPE, MAYBE WE WANT A DROP DOWN OF THE DIFFERENT TYPES OF ORDER TYPES. DOWN AT BOTTOM WE HAVE AN OPTIONS TAB. RIGHT IN LINE WE CAN GO AHEAD AND CREATE AND CREATE A NEW OPTIONS SET. SO MAYBE STANDARD ORDER, A BULK ORDER, A REPLACEMENT ORDER. WE CAN HAVE ALL THESE DIFFERENT SETTINGS. GO AHEAD AND SAVE THAT. IN NO TIME AT ALL WE WERE ABLE TO CREATE A BUNCH OF DIFFERENT FIELDS AND RELATIONSHIPS. THAT’S IMPORTANT WITH ANY SORT OF DATABASE THAT YOU’RE TRYING TO MANAGE. WE RELATE THIS TO THE ACCOUNTS OF PEOPLE MAKING THE ORDER. OF COURSE TO THE ITEMS THEMSELVES. WE CAN SAVE OUR ORDER. THE WAY WE BUILT THIS IS PREVIOUSLY IN THE D365 WORLD, YOU WOULD HAVE TO CREATE THE FIELD, CLICK SAVE, WAIT FOR THE PROGRAM TO RECORD IT. WHAT WE’VE DONE NOW, YOU CAN CREATE YOUR DIFFERENT FIELDS, ALL YOUR DIFFERENT RELATIONSHIPS, CLICK THE SAVE ENTITY AND IT WILL BULK THOSE CHANGES TOGETHER. IT SAVES IT ALL AT ONCE. NOW I WANT TO SHOW YOU MORE ADVANCED CAPABILITIES THAT ARE HARD TO DO IN SOMETHING LIKE SQL. WE MIGHT WANT TO CREATE A CALCULATED FIELD. WE MAY WANT TO KNOW WHAT IS THE TOTAL COST OF THIS ORDER. TOTAL OR LINE TOTAL. FOR THIS ONE IT’S A CURRENCY. WE WANTED TO KNOW HOW MUCH IT WILL COST. WE CAN CREATE A CALCULATED FIELD. THIS ALLOWS US TO TAKE A BUNCH OF DIFFERENT FIELDS WITHIN THIS PARTICULAR ORDER ENTITY AND CALCULATE A TOTAL VALUE OF THE ENTITY. HERE WE HAVE A NICE POP UP. HERE I LIKE TO BE TRANSPARENT AND SHOW THAT, HEY, WHILE WE’RE TAKING THINGS FROM D365 AND BRINGING IT INTO POWER APPS THERE ARE A FEW EXPERIENCES WHERE WE ARE BUFFERING YOU OUT TO THE LEGACY EXPERIENCE. BUT WE WILL BE MORE EMBEDDED COMING UP IN THE POWER APPS EXPERIENCE. SO WE CAN SAY, HEY, QUANTITY TIMES THE ITEMS COST. THEN SUBTRACT THE DISCOUNT. SO WE’LL DO 1 MINUS THE DISCOUNT. DIVIDED BY 100. WE’LL GO AHEAD AND SAVE AND CLOSE THAT GUY. SO IN NO TIME AT ALL WE HAD OUR FIELDS, RELATIONSHIPS, WE DID SOME BASIC THINGS IN SQL. CALCULATED FIELDS IS NICE. THEN THE REAL POWER COMES WHEN WE HAVE LOGIC OR SOMETHING LIKE BUSINESS RULES. I WANT TO ADD A BUSINESS RULE. PERHAPS WHEN YOU ARE FILLING OUT A FORM, WHEN YOU HAVE A BILK ORDER, SO LET’S SEE, WHENEVER THE — WHENEVER THE — WHENEVER THE ORDER TYPE IS BULK, WE’LL DEFAULT THE QUANTITY TO 20. THAT WILL HELP OUT OUR CHARACTER RYAN AS HE FILLS OUT THE FORM. WE WILL SELECT ORDER TYPE. WHENEVER IT’S EQUAL TO BULK, APPLY. AULT VALUE. ANOTHER FIELD, IN THIS CASE, QUANTITY TO 20. OKAY. WE CAN SAVE THAT. ACTIVATE IT SO LATER ON IN THE DEMO WHEN WE FILL OUT OUR FORM WE’LL SEE SOME OF THE FORM FIELD ALSO AUTOMATICALLY BE SET. WHAT’S NICE ABOUT THIS, BECAUSE WE’RE PUTTING THIS LOGIC ON THE ENTITY ITSELF, IF WE BUILD ONE APP, TWO APPS, THREE APPS, 100 DIFFERENT APPS ON TOP OF THIS ONE ENTITY THEY’LL ALL HAVE THIS SAME BUSINESS LOGIC. YOU DON’T HAVE TO RECREATE IT OVER AND OVER AGAIN. SO THAT’S BUSINESS RULES. WE CLICK DONE. IT WILL REFRESH HERE. NEXT WE HAVE FORMS. SO YOU HAVE TO INPUT INFORMATION INTO YOUR ORDER. HERE WE HAVE THE FORM DESIGNER, ALL THE DIFFERENT FIELDS. THIS I’M HAPPY TO SAY IS ONE OF THE FIRST THINGS THAT WILL BE BROUGHT INTO THE NEW EXPERIENCE BY THE END OF THE YEAR. DOUBLE CLICK ON QUANTITY, ORDER TYPE, WE DEFINITELY WANT THE ITEM, LINE ITEM. ADD ALL THESE THINGS IN, CLICK SAVE, PUBLISH. THIS IS NOW ADDING THIS FORM TO MY ENTITY. IF I’M BUILDING MULTIPLE APPS, I CAN REUSE THE FORM I BUILT ON TOP OF THE DATA INSIDE MY DATABASE. SO NOW THAT WE CREATED OUR ENTITY, WE ADDED SOME LOGIC THROUGH BUSINESS RULES, WE ADDED COMPONENTS, FORMS, LET’S BUILD THE APP. THIS IS PERHAPS THE EASIEST PART OF THE WHOLE EXPERIENCE. SO IF WE GO UP TO APPS, WE CAN CREATE AN APP . WE CAN GIVE IT A NAME. CALL IT ORDER. WE’RE SEEING A LOGICAL REPRESENTATION OF OUR MAP. THIS IS DIFFERENT THAN THE CANVAS WAY WHERE YOU’RE DRAGGING A BUNCH OF DIFFERENT ELEMENTS. WHAT ARE THE TYPES OF THINGS WE WANT TO INCLUDE. WE WANT TO SAY WE WANT TO INCLUDE, OF COURSE, OUR ORDERS. LET’S ACTUALLY SEARCH FOR IT. WE CAN ADD ADDITIONAL ITEMS. MAYBE WE WANT TO SEE THE LIST OF ITEMS SO WE CAN SEE HOW MUCH THEY COST. WE CAN SAVE THIS GUY. PUBLISH. CLOSE. WHEN WE COME BACK TO OUR APP, OUR LOGICAL REPRESENTATION OF THE MAP, WE CAN ACTUALLY SEE IT’S PULLED IN THE ITEM ENTITY AND THE ORDER ENTITY. AND IT’S PULLED IN ALL THE COMPONENTS THAT ARE ASSOCIATED WITH IT. SO I CAN LICK ON THE FORMS OF THE ORDER, I CAN SEE THE MAIN FORM I JUST UPDATED. WE CAN HAVE VIEWS. IF YOU HAVE A GALLERY OF ORDERS, ALL OF THEM GET ASSOCIATED WITH THIS APP. ALONG WITH CHARTS, DASHBOARDS. YOU DON’T HAVE TO MANUALLY DRAG THEM IN. THEY COME IN FOR FREE. WE’LL SAVE OUR APP. PUBLISH IT. WE HAVE A PLAY BUTTON. WE’RE EFFECTIVELY DONE. WE HAVE OUR FINISHED APP. WE CAN SEE WHAT IT LOOKS LIKE. ON THE LEFT NOW WE CAN SEE THE DIFFERENT ENTITIES. IF WE CLICK ON ITEMS, WE’LL SEE THE VIEW OF ITEMS IN MY EXCEL SHEET THAT I IMPORTED OVER. I CAN CLICK INTO THEM AND SEE THEIR DETAILS. IF I GO TO THE ORDERS, WHICH IS WHAT WE SPENT MOST OF THE TIME CREATING, WE CAN SEE THERE’S ALREADY ONE ORDER THAT I CREATED EARLIER. IF WE WANT TO CREATE A NEW ONE, WE CAN SEE ALL THE FIELDS WE CREATED EARLIER. LET’S NAME THIS CONTOSO ORDER 2. HERE THE ITEM, THIS WAS A RELATIONSHIP. THIS IS A LOOK UP. AND IT’S SMART ENOUGH TO GIVE ME A WONDERFUL DROP DOWN FOR ME TO SELECT THE ITEM I WANT TO USE. MAYBE I WANT TO SET THE ORDER TYPE TO BULK. SO REMEMBER WE HAD THAT BUSINESS RULE THAT WOULD SET THE QUANTITY TO 20 WHENEVER WE SET THE TYPE TO BULK. SO THAT THE USER, THE END USER DOESN’T HAVE TO DO THAT. MAYBE WE WANT TO SET THE DISCOUNT TO 10. BECAUSE WE HAD THAT LINE ITEM THING, WHENEVER WE SAVE IT, IT WILL AUTOMATICALLY CALCULATE THE EXACT AMOUNT THAT THE PERSON OWES US. SO WE WERE ABLE TO DO ALL OF THIS IN A RELATIVELY SHORT AMOUNT OF TIME. I’M NOT SURE IF I HIT THE TEN MINUTES. I MAY HAVE GONE OVER. HOPEFULLY IN THIS SHORT EXPERIENCE YOU WERE ABLE TO SEE THE POWER OF THE MODEL-DRIVEN APPROACH OF CREATING APPS VERSUS THE CANVAS SIDE. NOW, ON THE POWERAPPS TEAM, WHAT WE BELIEVE IS BOTH OF THESE DIFFERENT APP TYPES HAVE DIFFERENT PROS AND CONS. CANVAS YOU GET PIXEL PERFECT, HERE IT’S FASTER. AS WE INTEGRATE THESE THINGS MORE DEEPLY YOU WILL GET THE BEST OF BOTH WORLDS. WLR THIS COMING FALL YOU CAN DO SOME OF THE CANVAS APPS THAT YOU BUILT IN THE PAST, YOU CAN EMBED THOSE INTO A MODEL-DRIVEN FORM SO THAT YOU CAN GET SOME OF THAT PIXEL PERFECT CAPABILITY. WITH THAT I WILL WRAP IT UP AND I WILL OPEN IT UP TO QUESTIONS. OF COURSE PLEASE, WE LOVE YOUR EVALUATIONS. HIGH EVALUATION IS GOOD, OF COURSE. WITH THAT, I’LL OPEN IT UP TO ANY QUESTIONS PEOPLE HAVE IN THE CROWD.>>TEN MINUTES, 32 SECONDS.>>32 SECONDS I WAS OVER. DRATS. THANK YOU FOR COUNTING. THE QUESTION WAS WILL CANVAS DATA BE MIGRATED OVER TO HERE WHEN WE RELEASE THIS. SO IF YOU HAVE BEEN USING THE COMMON DATA SERVICE, ALL OF YOUR DATA IS ALREADY THERE. THE REALLY NICE THING IS THAT IF YOU’RE BEING USED IN THE COMMON DATA SERVICE, IF YOU’VE BEEN USING DYNAMICS, ALL THE DATA IS LOCATED THERE. SO GO AHEAD AND BUILD MODEL-DRIVEN APPS ON TOP OF THE DATA. YES. YOU WILL BE REBUILDING THE FORMS LOGICALLY HERE. IF THERE’S NO MORE QUESTIONS, I’LL PACK UP.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2019 Geted Tabs Online. All rights reserved.