Hide change the layout of the form and much more so let's get started with the video but first my introduction [Music].
In my modern sharepoint site i will head over to new and create a new list this opens up the option for me to select some of the new microsoft list templates right here.
For the purpose of this demo i will pick the content scheduler list template and as part of this template i can plan schedule and manage my content i will go.
Ahead and use this template click create and this will now create a list based on the microsoft list template for content scheduling.
Now if i click on new this will open the new item default sharepoint form and this form will showcase all the columns that were a part of the list.
Template and we have a wide variety of column types here from text fields to multi-line text fields to choice columns date fields and more.
Now in order for me to customize this sharepoint list form by leveraging powerapps we have to go to the powerapps menu option for the list form and head over.
To customize forms now here there are additional options as well if i pick create an app this will create a power app a standalone powerapp that.
Would be connected to this sharepoint list you can access that app from the powerapps mobile app or through the maker experience.
However by customizing the form using powerapps i will go ahead and create a sharepoint customized list form the only way for me to access this power app will be through the.
Posts Related:
- Add & Update Excel Data to SharePoint List using Power Automate Excel Import using flow
- 20 Graphics Templates Bundle In One Free Download Sheri SK Photoshop Files Office
- Design A CSS Box Shadow Generator Using HTML, CSS & JS (Part 2) BlogSpot
Sharepoint experience in the browser
Only so the advantage here is users can manage the data without leaving sharepoint.And the moment i create that customized app powerapps goes ahead and creates a very simple app with one single screen called the form screen now let's.
Understand the different aspects of this app the first important thing to note is that this app has a connection or an integration.
With sharepoint and this right here is that sharepoint integration object if you see this object that means the app that i'm customizing right now.
Is a sharepoint customized list based app and as part of this object if you head over to the advanced tab on the right hand side properties pane.
There are multiple functions that are exposed as part of this integration object so when the user clicks on a new item button in sharepoint.
Then on new function gets triggered and as part of this function powerapps is creating a new form experience for the form control that is added to.
The screen if the user edits a record it will set the mode of the form to edit if the user is viewing the record.
It will set the mode of the form to view and when the user clicks on the save button to save the data in that case poweramps will go ahead and submit this.
Form data if the user cancels the form
In that case powerapps will just reset the form and the data source here is nothing but my sharepoint list which in this case.Is content scheduler if you observe the main canvas area right here on the top there is a delegation warning now this is because the template that is used to create.
This sharepoint customized list form uses a function that runs into a delegation error and delegation and powerapps basically is the ability of powerapps.
To handle large data sets as part of this template if you look at the item property of the form control here is where we are getting that delegation warning.
To fix this all you have to do is replace the first function with a function called defaults and what is the behavior of this item function.
This item function is basically the item that is associated with this form control the record and sharepoint if the sharepoint integration object.
That is selected is blank or it is empty that means the user is trying to create a new record there is no context to an existing record while coming to this form.
In that case go ahead and use the default behavior of my sharepoint list that means the form will act like a new item form if there is an association to a.
Sharepoint record in the sharepoint integration object in that case go ahead and associate the selected record from that sharepoint integration object.
Now if we look at the form control here and head over to the properties of the form control the data source is my sharepoint list if we look at the fields and head over to.
Edit fields this is listing out all the columns that are associated with that sharepoint list and right here we can start customizing our sharepoint form.
So for example author is the created by column in sharepoint and that's an inbuilt column maybe i do not want that as part of the form i can just simply go ahead and remove it.
From this form experience if i would like to add any columns that are a part of my sharepoint list i can just head over to add field and select.
Any column that i would like to add as part of this form i can even reorder my columns right here by just selecting the three ellipses and moving my cards or my columns up.
Or down i can even select and drag and place them if you would like to test this app right here in the maker experience itself on the top right hand corner.
I can go ahead and click on this play icon so i can preview the app and this now is the experience that the user will get when the user will start interacting with the sharepoint list.
Now you can also create scenarios like conditional formatting conditional validations you can customize this form based on your needs let me show you one.
Simple use case if the user selects the status as published in that case i would like to display the column.
For published link and that column has to be a mandatory column in that scenario so here's conditional formatting and conditional validation both in one.
Go i will close the preview select the published link column every column that you add as part of your form control.
Gets added as a data card if i would like to change any behavior of this column the first step is head over to advanced properties and unlock the card so that you can.
Start making changes to the card now to show and hide this card depending upon the value that is selected right here in this combo box control of my status.
Column i will first select this column copy the name of my control head over to the data card for published link.
Search for a property called visible and if i just click on this property name it will place the property here and open the formula bar this is where i can plug in my functions.
Known as powerfx so my function here would be as follows i would like to make this column or this data card visible if the status value is published.
So for that i will give the name of the control that i copied earlier which is the control name for this combo box dot selected so that'll give me the.
Selected record dot value so it will give me the value is equal to published so if this value is equal to published.
This card will be visible else the card will be hidden if i preview the app again you will note that the published link card is not visible.
If i change my status to published i will see the published link card now i would also like to make this column a mandatory column if the status is.