Customize SharePoint List Forms using JSON Formatting (1)
#SharePoint #Forms #ListFormatting #FormFormatting #ListForms
In this video on Customize SharePoint List Forms using JSON Formatting, we will walk through applying simple form customizations to your SharePoint lists or Microsoft Lists. This newly released feature of form formatting uses the same logic as SharePoint List Formatting (column and view formatting). Hence, we can now customize the look and feel of our SharePoint columns, SharePoint views and SharePoint Forms using JSON and apply conditional formatting.
✅ Documentation: docs.microsoft.com/en-us/shar...
✅ Formatting Samples:
Header Formatting: github.com/rdorrani/SharePoin...
Body Formatting:
github.com/rdorrani/SharePoin...
Footer Formatting:
github.com/rdorrani/SharePoin...
✅ Microsoft List template used: Issue Tracker
Columns added:
Comments - Multiple lines of text
Expected Completion Date - Date
✅ PnP Samples: pnp.github.io/sp-dev-list-for...
Table of Contents:
00:00 - Intro
00:36 - Create list from template
01:48 - Edit columns Option
02:36 - Conditional formatting of columns
04:33 - Configure Layout formatting option
05:05 - Customizing the form body
08:10 - Adding Header to form
08:32 - Adding Footer to form
08:53 - Issue tracking list form customization (tutorial)
16:00 - Customizing SharePoint list form with Power Apps
17:42 - Subscribe
Пікірлер: 765
great video. Thanks for putting it together. The only two things that are missing now are cascading dropdowns with json & modern lookups (to other sites) :-) Let's hope MS is reading...
@RezaDorrani
3 жыл бұрын
Lets hope so
@nickwestmoreland7439
3 жыл бұрын
Could you not conditionally hide other fields to immitate cascading. Select a value in dropdown A which swaps dropdowns according to the value selected. Obviously be a number of extra dropdowns but might be useful in a small case
@RezaDorrani
3 жыл бұрын
@@nickwestmoreland7439 Too much work. I would suggest using Power Apps in that case.
Someone pay this dude! He is the man!
@RezaDorrani
3 жыл бұрын
Thanks for the compliment. Best mode of payment is to share my work within your networks.
14:25 made this whole training video gold! thank you for the preview panel with custom formatting!
@RezaDorrani
3 жыл бұрын
Forms formatting will take SP lists/libraries to the next level. By the ways, I have 4 videos on this topic. You can check them here - kzread.info/head/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
I am going to owe you quite a bit in the not-too-distant future. I am learning so much from these videos! Thank you SO much for what you do with these!
@RezaDorrani
2 жыл бұрын
You are so welcome!
Wonderful session. Using Json itself now able to do more list form customization with conditional formatting without need of jquery and css. Thanks!
@RezaDorrani
3 жыл бұрын
Absolutely. Just by writing simple JSON we can get so much done.
This is one of the best videos that I’ve seen. It showed me something that I thought cannot be done in SharePoint list
@RezaDorrani
3 жыл бұрын
Thank you 😊
Reinforced a few points I knew, and showed a few new ones. Well put together video at a great pace. Thank you :)
@RezaDorrani
3 жыл бұрын
Awesome, thank you!
Nicely done. Never thought I'd need to do this until you gave this demonstration. I've given up on the over-complex approach of PowerApp forms and this is a suitable alternative.
@RezaDorrani
2 жыл бұрын
Thanks! Choosing between SP JSON forms and Power Apps is a video topic I am working on.
Wow! This will be a main reference video for using and customizing SP Lists.
@RezaDorrani
Жыл бұрын
Thanks so much.
this is probably the best sharepoint youtube channel . To the point and talks about we are using , no crazy non free third party non microsoft features .
@RezaDorrani
3 жыл бұрын
Thank you for your kind words.
I'm your No. 1 fan in the Philippines! Great video!
@RezaDorrani
3 жыл бұрын
Wow, thanks. Appreciate the support.
Hi Reza, Thank you for this video, it has greatly improved my understanding of using JSON and SharePoint formatting.
@RezaDorrani
3 жыл бұрын
Glad it was helpful!
This video helped soooooo much in my Sharepoint Development path. Thanks a thousand times Reza !
@RezaDorrani
2 жыл бұрын
Glad to hear that. Thank You for watching.
So glad I found this. SharePoint out of the box is not the best; however, one simply needs to know what to do with it to make it be what it needs to be. More learning to do...! Thanks again!
@RezaDorrani
5 ай бұрын
Most welcome
Thank You! Seriously this is one of the best tutorials on this subject
@RezaDorrani
3 жыл бұрын
Wow, thanks!
Awesome video! Thanks for the great information presented so smoothly!
@RezaDorrani
3 жыл бұрын
Glad you enjoyed it!
I hate that I learned some other third party application for SharePoint first, versus out of box features and JSON manipulation. Either way, glad I made it here now. 😇
Great video as always , love this , it saves a lot of time. Keep them coming
@RezaDorrani
3 жыл бұрын
Thanks
Excellent description. Thanks for this good work !!
@RezaDorrani
3 жыл бұрын
Glad you liked it!
Excellent video. Thank you for sharing all the SharePoint tricks
@RezaDorrani
2 жыл бұрын
Thank You. If you enjoyed list formatting, then check out kzread.info/head/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
Very informative Reza... Loved the content!!!
@RezaDorrani
3 жыл бұрын
Glad you enjoyed it!
Excellent one... Helped me a lot in understanding MS Lists. - Thank you.
@RezaDorrani
Жыл бұрын
Most welcome
Outstanding Tutorial! Thank you I’ve learned so much!!!! New Sub👍🏾
@RezaDorrani
2 жыл бұрын
Awesome! Thanks for the sub!
One word--BRILLIANT!!!!!
@RezaDorrani
Жыл бұрын
Thank You!
Absolutely brilliant. Thank you!
@RezaDorrani
2 жыл бұрын
You're very welcome!
Amazing video, thank you so much...i learned so much with you...and big thanks for the links...extremely useful
@RezaDorrani
11 ай бұрын
Most welcome!
Awesome video. Very well explained. Thank you so much.
@RezaDorrani
3 жыл бұрын
You're very welcome!
Super awesome tips!👏 Thanks for sharing 😃
@RezaDorrani
3 жыл бұрын
Thank you Daniel
This is simple WOW. Amazing Demo.
@RezaDorrani
2 жыл бұрын
Thanks Manish
Excellent video thank you Reza!
@RezaDorrani
Жыл бұрын
Glad you enjoyed it
This very useful. Thank you. I was not aware that you can do this in SP.
@RezaDorrani
3 жыл бұрын
You are most welcome. List form customization is one of my favorites.
Great overview. Thank you!
@RezaDorrani
3 жыл бұрын
Thank you Denis
What a great teacher! Thx
@RezaDorrani
Жыл бұрын
Thank You
Thank you. Very well explained!
@RezaDorrani
3 жыл бұрын
You are welcome!
Great video! Will help a lot with a project…thanks
@RezaDorrani
Жыл бұрын
Glad to know the video is helpful. Thanks for watching
Love your videos. Thank you.
@RezaDorrani
2 жыл бұрын
Thanks for watching!
Thanks a lot Reza. inspirational for starting
@RezaDorrani
2 жыл бұрын
My pleasure
Loved this, thank you so much
@RezaDorrani
2 жыл бұрын
Most welcome!
Great content as always. 👌
@RezaDorrani
3 жыл бұрын
Thank you Sadab
Great session, useful channel
@RezaDorrani
3 жыл бұрын
Thank you
Thanks for this great info! I may be able to avoid PowerApps in some circumstances by utilizing some of these techniques.
@RezaDorrani
2 жыл бұрын
Glad it was helpful!
Great Video. Thanks for sharing.
@RezaDorrani
2 жыл бұрын
Thank You for watching
So useful! Thank you.
@RezaDorrani
2 жыл бұрын
Thanks for watching
Great. Great video. Great!
@RezaDorrani
3 жыл бұрын
Thank you very much!
Nice video. Thanks for your Help! very useful.
@RezaDorrani
3 жыл бұрын
You're welcome!
Amazing video. Thank you
@RezaDorrani
2 жыл бұрын
Most welcome
Awesome video! Thanks
@RezaDorrani
3 жыл бұрын
Most welcome
Another good one 😍
@RezaDorrani
3 жыл бұрын
Glad you like it!
Thank you for your videos, I do have a some trouble getting this funtions to work.
@RezaDorrani
2 жыл бұрын
I will need to learn more about your issues and look at your use case to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Very informative video 👍👍
@RezaDorrani
3 жыл бұрын
Thanks a lot
Great video. Thanks a lot for sharing.
@RezaDorrani
3 жыл бұрын
Thank you for watching
So cool! This is going to be so amazing to avoid PowerApps which is awesome but an administrators nightmare.
@RezaDorrani
3 жыл бұрын
Thank you. I am a fan of both SharePoint formatting and Power Apps. Both have their own strong points and its imp to know when to use them.
@arainla
3 жыл бұрын
Why do you say Admin nightmare? Curious as we are trying to learn it but want to know the negative side too. Thanks.
Thanks for sharing this Sir!
@RezaDorrani
3 жыл бұрын
Thank you for watching Sir
really helpful !!! thnak you
@RezaDorrani
3 жыл бұрын
Thank you for watching
Great Video, thank you for sharing your knowledge.
@RezaDorrani
11 ай бұрын
You’re most welcome
@alpanapradhan2328
11 ай бұрын
@@RezaDorrani HI, I created a list and updated the form's body layout and since I needed conditions for some columns I used Power Apps, after that my layout is not the one I created. If I remove the power apps option from the form settings the functions applied through power app dont work. Is there a way to resolve this? Also, my CSV file of 232 rows does not import in this list. Please advise.
@RezaDorrani
11 ай бұрын
@@alpanapradhan2328 You can either use JSON formatting or Power Apps. You cannot use both.
@alpanapradhan2328
11 ай бұрын
@@RezaDorrani Thankyou for the reply, can we use Lists and Forms instead of PowerApps with similar functionalities.
@RezaDorrani
11 ай бұрын
@@alpanapradhan2328 You could
Fantastic 🎉🎉
@RezaDorrani
2 жыл бұрын
Thanks
Great video
@RezaDorrani
Жыл бұрын
Thanks!
Great video Reza, thank you. My tenant did not receive this update :(
@RezaDorrani
3 жыл бұрын
Currently, rolling out to first release and targeted tenants only.
Great video! Your tutorial was clear and easy to follow. Qsn, can this be apply on Document library as well?
@RezaDorrani
3 жыл бұрын
Yes, absolutely
Very helpful :) Thank You
@RezaDorrani
3 жыл бұрын
Your are most welcome
@kalpanavaidya6788
3 жыл бұрын
@@RezaDorrani I am adding the date in Date column and In the DueDate column, I need a future date depends on the frequency which I selected (monthly, weekly ) is this possible using JSON in list customization.
@RezaDorrani
3 жыл бұрын
@@kalpanavaidya6788 Setting field values in not supported. This is only to add formatting.
great video
@RezaDorrani
2 жыл бұрын
Thanks!
Absolutely stunning Reza. Great Video. Just curious while configuring this layout we have a lot of real estate to play with, is there anyway where we can configure like Dashboards. Like a relational lists on same screen ?
@RezaDorrani
3 жыл бұрын
Currently it only allows formatting the current list or library. For configuring relational lists you would need to use Power Apps. Check - kzread.info/dash/bejne/hXeNu5uTfJeefdo.html
Reza. Do you have any links that people can use to understand which json properties/values etc. are valid to use with SharePoint and what those properties do? It's good to use the community samples but also better to understand how they work, if possible. Thanks for your standard superb content.
@RezaDorrani
3 жыл бұрын
It follows the same principles as column formatting - docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration
Thank you for the prompt response Reza. My next question 3. Can display name of a section be combined with values from the SPO list? Eg- I want section to have a display name Below section has employment details of Adam Jones Here ‘Adam Jones’ is from the Name column of the record
@RezaDorrani
2 жыл бұрын
3 - I believe section name can only be hardcoded text as of now
@manublr
2 жыл бұрын
Thanks Reza. My intention was to keep a few fields read only (for reference) and others editable (update based on reference). I know it’s possible through PowerApp but wanted to take a simple JSON route.
@RezaDorrani
2 жыл бұрын
@@manublr I don’t think it’s possible via JSON at the moment.
Hi, first of all, I learned a lot in this video! Thanks for creating this. Helpful for a beginner. Btw, I’m just wondering if the conditional formulas you’ve set using JSON will be applied to the PowerApp Form as well?
@RezaDorrani
2 ай бұрын
Most welcome! Json formatting does not apply to power apps.
Thank you for being smart so I don't have to. 🤗
@RezaDorrani
2 жыл бұрын
You’re welcome 😊
Hi Reza, your every video give something new. Thanks for sharing knowledge. Is there any way to make attachments in SP list as mandatory ?
@RezaDorrani
2 жыл бұрын
Thank You for liking the video. Not in SP or via JSON formatting. You can do it in Power Apps!
Great video. Loved it! However, i was also looking for information on 1. whether can we make a column required basis on dropdown selection as in PowerApps. 2. as i can see you are editing the column view on the fly. so if the other puts in a request, will he be able to edit the column layout too?
@RezaDorrani
3 жыл бұрын
1 - Conditional required validation cannot be done with JSON 2 - Anyone who can create and manage views in a list can use form configuration to configure the form with header, footer and body with sections.
Awesome 😎
@RezaDorrani
3 жыл бұрын
Thank you! Cheers!
Thanks Reza.
@RezaDorrani
3 жыл бұрын
Your welcome Nilesh
Hi Reza, fantastic explanation. Does this apply modern SP lists or classic SP lists can also be configured using these features?
@RezaDorrani
3 жыл бұрын
Only works with Modern SP lists.
Hi Reza. Thanks for putting this tutorial together as it has helped me out. I did have one question as I've having a hard time trying to make it work. I used JSON to format the form and I used the conditional formatting for a status dropdown that worked, I created a 2nd drop down in a different section where I also want to use conditional formatting that works independently but only the first drop-down works while the other doesn't. Is it possible to have multiple conditional formatting for multiple drop-downs?
@RezaDorrani
Жыл бұрын
Not sure about that one to be honest. Never tried it.
Hi Reza, great information as usual. Quick question, is there a way to auto-populate a column in a list by comparing two columns from separate lists ?
@RezaDorrani
Жыл бұрын
Not using JSON. For that you would need Power Apps.
Thanks for the video Reza - very informative. Quick question - is it possible to change the size and colour of Section Headings in Forms?
@RezaDorrani
3 жыл бұрын
Currently, section heading styling is not supported
Awesome once again Reza! Great job!! I added the JSON for sections and in the body section of my form i have a choice field as radio that displays choices vertically. . .Is it possible in the body section of the form editor to add custom JSON to style the display of a radio choice to horizontal view?
@RezaDorrani
Жыл бұрын
JSON body does not provide formatting options.
Hi Reza, Thanks very much for providing great videos, I am learning a lot by following you. Recently I have project with Json formatting and I came up with scenario where have to display the current user name in the people picker field (Requestor) and disable some fields respective to status column, please let me know how to achieve this using json formatting.
@RezaDorrani
2 жыл бұрын
Thanks for watching and liking my videos. Currently, disabling fields is not supported with JSON formatting. You would need to leverage PowerApps for that.
Thanks a lot for this session; really helpful. Is there any way to control Save or other buttons so far?
@RezaDorrani
3 жыл бұрын
Not yet.
Hi Reza, thank you for the video tutorial. This is awesome, easy to follow and understand. My question: Can you show a video on how to make a page for the sharepoint list (i.e Issue Tracker). I made a simple FAQ list and I would like to create a page for that to show its content (the list). I appreciate it if you have a video for this. Thank you so much. Basically, How do I add a SharePoint list to a page or create a new page for the sharepoint list (like the issue tracker)?
@RezaDorrani
3 жыл бұрын
Hi, You can use the list web part and just connect to the SharePoint list. I do not have a video on it however I am planning for a lot more beginner level videos on SharePoint soon.
@onestopsystems5151
3 жыл бұрын
@@RezaDorrani It would be wonderful to have a tutorial made by you. I saw that information on how to use the list web part posted on Microsoft, here it is: support.microsoft.com/en-us/office/use-the-list-web-part-ef0a1b80-f8b3-443d-b04a-1e76c70b5537
Danke!
@RezaDorrani
10 ай бұрын
Thank You!
Awesome video. A question from my end is whether we could hide the entire section based using the conditional formatting ??
@RezaDorrani
3 жыл бұрын
That option is currently not available. You would have to individually hide each column within a section.
Thank you for response.
@RezaDorrani
6 ай бұрын
You're welcome
@kracken71
6 ай бұрын
@@RezaDorrani do you have a vidio that shows how to make fields hide depending on other fields?
@RezaDorrani
6 ай бұрын
@@kracken71 I have a playlist on json customization. It may be in there else I may not have done it.
Reza - thank you for the great tutorial. Do you know if it is possible to hide an entire section of the body unless a specific response is provided in one of the questions or does each field in that section have to be conditionally hidden?
@RezaDorrani
Жыл бұрын
Each field has to be conditionally hidden. The section title would still show up though.
Love this video! this is exactly what we needed! One question if you have time. We want to add to our header say a field called "client name" and also a "logo" for the client. Is that possible?
@RezaDorrani
3 жыл бұрын
Absolutely Yes. My playlist has 3 videos and many more coming - kzread.info/head/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
@RichardDalrympleplus
3 жыл бұрын
@@RezaDorrani Will watch all three thanks a bunch
@RezaDorrani
3 жыл бұрын
@@RichardDalrympleplus There is also chapter 4 that releases today :)
Great video thanks. Not on my clients tennant yet, do we get this on library doc forms too ?
@RezaDorrani
3 жыл бұрын
Currently available only in first release and targeted release tenants. Yes, will work on Doc forms too.
@Reza, Thanks so much for this video to show how we can leverage utilizing JSON to format a SharePoint list form. I've noticed that the hide/show formula does not seem work for columns that are of person datatype, the "Edit Conditional formula..." window will not allow Save. Any ideas why? Keep up the good work! Jh
@RezaDorrani
Жыл бұрын
I believe person type has a bug. Not consistent.
Thanks
@RezaDorrani
2 жыл бұрын
Welcome
Great video. I do have a question: when you are formatting the header in the list form with JSON can it be possible to change the color of the header based on Yes or No value column?
@RezaDorrani
3 жыл бұрын
I am skeptical to say Yes because there are certain column types that are currently not supported. I would recommend you check the documentation reference linked in the video description.
Thanks Reza
@RezaDorrani
3 жыл бұрын
Thank you Sundra
Great video! Thank you... Is there a way to customize the BODY such as colors, etc without going to PowerApps using JSON?
@RezaDorrani
2 жыл бұрын
Form formatting JSON currently (as of today) only supports sectioning, header and footer. docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration
Great Video Reza. One Question: Is there a way to have a separate configuration for New item form and Edit item form? I want some fields on New and some additional fields on Edit list form along with different conditions. This would be on sharepoint online modern list.
@RezaDorrani
3 жыл бұрын
Currently not possible with List form customization. You would have to use Power Apps for that.
Amazing video, complete and clear! is the code for the status based formatting still available? i can't find it in the new link
@RezaDorrani
2 жыл бұрын
My GitHub repo is up and running.
Thank you for the video!!! It's very helpful. Just wonder is there anyway I can capture the "add new item" link and create a button somewhere outside the list page? I can do that in SharePoint 2013... When I click "copy link" in sharepoint online, it just bring me to the allitems list page.
@RezaDorrani
2 жыл бұрын
I am not sure if that is possible. I will recommend to check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
great video explanation. I have a question not sure being asked before which is how to auto present a simple itemised table at the multi lines rich text column. I know that user have to create out the table and fill up the data, how about if when user create new item the table is ready when user select the column?. Is the current Sharepoint online modern experience can do that?
@RezaDorrani
4 ай бұрын
I don’t believe thats an option
Hi Reja, This was indeed a great video. One quick ques: can we pull calculated field i.e. Status in header using JSON?
@RezaDorrani
3 жыл бұрын
I tried a while back and it did not work. Someone mentioned recently that it did.
@mohit1931989
3 жыл бұрын
@@RezaDorrani thanks for your reply Sir... I hope that someone find my post and reply how it can work.
Great video Reza! Can i using this JSON Formatting to disable the save button depend on status?
@RezaDorrani
3 жыл бұрын
The form formatting options do not allow to disable buttons. For that you would need to use Power Apps.
Hi Reza, thanks; for this video. I've created sections which work fairly well, however I have a field that is not going into the proper section but is instead at the bottom of the form (as if it was not named anywhere in the code - I've checked and I have the right name for the field). Also, a few fields are not in the order that I requested in the code. Any reasons for this or code to add to ensure the proper sort order?
@RezaDorrani
2 жыл бұрын
Should not be the case. I will recommend checking on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Great video! Is there a way to add a description below the displayname? In other words, my form needs a title, instructions in each section
@RezaDorrani
2 жыл бұрын
Currently, I do not believe that is an option. Check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Great video, Reza! Do you know if other people in SharePoint can see Power Apps form customization without Power Apps license?
@RezaDorrani
Жыл бұрын
This video does not use Power Apps. If Power Apps is used, then a Power Apps license is needed.
Thank you for sharing. Do you recommend any source to learn JSON instead we picka codes directly without much understanding.
@RezaDorrani
3 жыл бұрын
Microsoft Docs - docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting PnP Samples - pnp.github.io/sp-dev-list-formatting/
Thank you for this very interesting new video. Is it possible to select and use data stored in ms planner in sharepoint lists?
@RezaDorrani
3 жыл бұрын
Not with the formatting options. Power Apps will make it possible.