action let's take a scenario employee travel request in my environment I have dat ver and here with.
The help of AI co-pilot I have the ability to describe a new table with co-pilot I can simply describe my intent I'll State travel.
Request and copilot recommends a table schema for me to get started with multiple columns with different data types I can also ask co-pilot to add additional.
Columns add column Transportation mode type text purpose of travel type text and also add a column called approval status type choice I also have the ability to delete.
Generated I can also ask copilot to add data natural language conversations and once I am ready to create the table I simply click.
Create the table's created the sample data is loaded in the table now that I have a table that stores travel request information let's go ahead and build a modern power app so right from the home.
Screen experience we have an option to start with page designs and from page designs I would like to start with the header main.
Section and footer layout style so I'll select this and this will launch the canvas Studio experience the app has a screen that leverages the responsive layout.
Containers at this point I will first go ahead and save my app I will call this employee travel request and save next I will go to settings.
Posts Related:
- Excel VSTACK - Quickly Combine Data from Multiple Sheets (Excel Noob Vs Pro)
- Learn How To Create Tabs in Microsoft Excel In This Easy VBA Tutorial Video
- Background Music in Power Point Office
Support and pick the latest authoring - ID Card Make
Version since I would like to Showcase some of the latest features that I've just been released so I'll reload the.App so I'm back to my power app and I have the latest authoring version set I would like to leverage modern controls for this.
Application so I need to ensure that the modern controls and themes feature is turned on the screen containers now have a new option to directly insert.
Controls so if I select this it launches the insert panel I would like to add a header control for my power app in modern controls we have a new header control which I will select and it will.
Add that header control in the header container fully responsive the title property I will seted to employee travel.
Request the header shows the image of the current logged in user and if that's selected it will show the details of the current logged in user it also has an option to add a logo.
I'll add an image file here I've gone ahead and uploaded an image and that image shows up as the logo for the header next in the main container.
Section I would like to show the data from the travel request table that we created in data I'll click on insert one of the new modern controls.
That we have is a table control it requires a data source I can directly search for my table which is called TR travel requests I can select it this will begin the.
Process of connecting that table in my
App the new table control will display the data alignment and container I will set to stretch so it will take the full.Width and flexible height I will turn on currently it's showcasing a couple of columns I have the option here to pick Fields I'll remove create created on and I'll click on ADD and bring in.
Additional Fields I would like to show the departure date the destination the purpose of travel the return date click add and just like that all those columns will start showcasing in.
This tabular experience now if I preview the app we can see how it showcases all the data in this nice new mod mod table control if you would like to reorder the.
Fields once again I'll go to edit fields and right here I can simply drag and drop to reorder them I also have the ability here to size The Columns as.
Needed now this is a fully responsive app so what happens if I view this let's say on a tablet experience now observe here it does not have enough real estate to fit the.
Columns so it shows a horizontal scroll experience which allows the user to scroll and look at the data across all the columns and if I was to view this on a.
Mobile experience we can see how that table control completely transforms itself to represent data in a different format the table control.
Has a property called Reflow Behavior select grid so if I was to view this on a mobile device it will force the grid view experience even in a mobile form.
Factor the second option we have is list only so at this point no matter which form factor I view this on it will show the data in a list fashion it also has inbuilt pagination.
Shows 25 records and I can navigate through the different pages and the default option which was set to Reflow automatically changes the style.
Of the table depending upon the real estate available currently it's displaying the grid but if I view this on a mobile device it will transform to the.
List the list experience it will only show the first three fields if I was to place Transportation mode ahead of purpose of travel the third option changes to.
Transportation mode I would like to give the user the ability to create new travel requests or edit existing travel requests and for that I will add a few.
Buttons on the screen now the bottom container here which is called the footer container I will use that container as a pan for buttons and I have the ability to right click here and.
This will display properties of containers as well I will reorder this and move this container up this container has a defined height change this let's say to 50 so I'll open.
The insert menu add a button if I right click on the button control I can copy select the container again right click paste I'll hold the control key and select both these controls so I can.
Change their properties at once the modern button control has a property called type I'll change this to subtle for the first button I'll set its text to new and the second button I will.
Set its text to edit I'll select new screen I'll pick the layout type as head and footer the header literally repeat the same steps as.
Before in the main container I will go ahead and insert the modern form control the data source for this control will be my connected travel request table once again I have the ability to.
Pick the fields that I would like to showcase on the form experience theart a date destination and click add so this will go and add all those columns as data.
Cards on the form control each of these data cards I can unlock and make changes of desired for example I would like to make title as required when the user fills.
Out the form and I will do something similar with other data cards as well I also have the ability to reorder the cards by simply selecting them drag.
Drop all of these are the new modern control experiences now in the bottom container I would like to add a button control which will allow the user to.
Submit the data in the form control when this button is clicked I would like to submit the data data in that form so on select of the button I'll use the formula submit form and put.
The name of my form control for the form control we have a property called on success this property will trigger once the data in that form is successfully.
Submitted here I would like to First notify the user that the travel request has been submitted successfully y notification type success and I would like to show this message for 3.
Seconds now the user will come to the form screen from the home screen and once the form is successfully submitted I would like to take the user back to the previous screen and to do that we.
Have a formula called back and if I go back to my home screen when the user clicks on the new button on select set the mode of the form to.
