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...
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
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 - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
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 .
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
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.
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. 😇
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!
THANK YOU!! Watched your video today and was able to configure the look of my list form. Unfortunately, I could not get the conditional formatting to work no matter how hard I tried, but I'll play around with it more.
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!
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.
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 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.
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.
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
Very thorough and informative! I am really enjoying those forms. I also implemented Site Columns and unfortunately when I am refreshing them the conditional setting for the column is disapearing. Is there a way to add it together with other json formatting via site column? If not maybe there is file with settings, a schema I could plunk in each time I do the refresh of the columns, cause it will be a lot of work to set it up manually again. Any thoughts?
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
Thx for the tutorial Something to note, if you rename the column name, it wont find the field and add it to the last section. Renaming isnt impacting power apps though if you add new field, it wont reflect in powerapps. Choose the right solution for you and your users :)
Thank you so much for the video. Everything worked perfectly except one thing: I am completely stuck at the conditional formatting when it comes to unhide the column when the assigned person is logged in. I tried every scenario even with different formulas all referred to "Person" fields but nothing work. Do you have an idea what could be wrong with my formatting when it comes to get info from a "Person" field? Maybe some settings I should change? Please help 🙏
I have not come across this issue hence not sure what can be the reason for it not working. I will recommend posting your issue on forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint in case someone else has run into something similar
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?
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)?
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.
@@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
Just a tip for this, if you hide columns in the default view that you are not using, for example calculated columns and the like, then they won't appear in the form at the end of it after formatting it
@@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.
As always, great stuff Reza. I have a question, it appears that a calculated column will not appear in the new/edit form that you add to the body JSON. I have tried it a couple of times and every thing else (so far) does show up as placed, except calculated columns. Is this a problem or is another wrinkle required to include such column types for display using JSON?
Hi Reza! GREAT video, i love it, i could increase the customization of my forms without PowerApps, because we don't want mu end-users to have license of powerapps assigned. Then, we have found problems if the name of columns are complex 3 or 4 words and blanks spaces. How can we use the value of this fields in the form or in the formulas to hide/show other columns? And another more question, it's possible to customize the background color of the body section in json?
Show hide columns is possible. Body does not allow customizations apart from sectionizing. Here is my full playlist on JSON formatting - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
Hi Reza, I am following your videos for the past few days in search of my problem. I have an excel file containing four spreadsheets having a single similar column in all of them. The column contains the initials of different departments whose work is pending, done, and on hold. I want to automate that column so that only the person of the respective department with pending work gets the email notification twice a week. Can you suggest to me the process to achieve this or any of your video(s) with a similar context? BTW your videos are really informative and I have created some flows by watching your videos for my org which got greatly appreciated as I have zero knowledge of coding and business tools.
Thanks for the feedback on the video content. I do not have any video reference on your scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza great video thank you for this ill be adding the header and footer section to my list. I have a question but im not sure if its possible: Im trying to increase the width of just one of my inputs (Multiple lines of text) to twice the width so it easier to read the desriptions instead of scrolling down, is there a JSON formula that will allow one of the fields to be twice as long as others? Thank you in advance.
I would like to have a section called "instructions" that doesn't have any fields in it but rather only some text explaining to user how to fill out the form. I started with the sample JSON for body section and have been trying to modify it to handle this. I have gotten it to the point of showing the section, but am having trouble figuring out how to add the instruction text. If you can help you will save me a lot more googling! Ty in advance, your videos are awesome
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?
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?
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.
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?
@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
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.
Thanks for watching and liking my videos. Currently, disabling fields is not supported with JSON formatting. You would need to leverage PowerApps for that.
Thank You for liking the video. Tabs is currently not possible with JSON but you could build Tabs by customizing the form with Power Apps. Check ruclips.net/video/KjUJZr5Vn_Y/видео.html
Thanks for fast answer, but I'm looking for a possibility without PowerApps. Do you know another implementation option in JSON body formatting to get more clarity?
Thanks. One more question: Is it possible to Edit conditional Formular for a multi value field with more them one value? With the Normal oporator == its not possible
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?
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.
I love the new feature, but just for information, what would be the negatives if we use customize forms using PowerApps, do we have issues like delegation(I guess its no, as its not searching or filtering anything), or another negative apart.
No delegation issues. JSON form formatting is native SP functionality. There is no such negative aspect to it. This is another alternative to customize list forms.
Thanks Reza for this. I have a problem with a column that is date and time. Assume I enter a new element and specify a date and time. If I select the element and say modify, the time will be 3 hours ahead. Every time I say "Modify", the time advance by 3 hrs. This does not happen if I right click and I say "details". Then, I see the correct time. Any idea what the problem might be? Thanks in advance.
This seems to be a time zone-based issue. SP site time zone vs your local time zone. I have not come across this issue though. I would recommend posting your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint in case someone else has run into a similar issue.
Excellent demo Reza. Do you know if it is possible to associate an onclick event to the save button in the New form via the json? I would like to redirect to a success message page rather than returning to the list.
If you are hiding columns for your form and it does not work - check the column name via list settings, then click column name. For example "Case Type" could be name by SP as "Case_x0020_Type" check at the the end of the url after = for actual technical name if your if formulas for hiding columns doesnt work.
🎉love your channel! Question: I have a customer who’d like a Julian date calendar number that would be system generated with assigned task/number series. Any advice?
Very brillant demonstration. Nevertheless, i have one question . When i have integrated my list to powerapps, the only size available was a phone size FORMS. Is there any way to get a tablet size integrating the list related to a powerapps app FORMS ?
Hi Reza, i hope you are fine, i have a question, when i edit the JSON to give format to the form it goes wider, however if i a new user consults the form or i completely close the sharepoint and reopen, the form goes back to the narrow version. I definitely like more the wider version, how can i set up the form to display always the same wider version? I hope you can help me out. Nice videos in your channel, i appreciate your work :)
@@RezaDorrani Update: I've had a coffee and revisited and it works exactly as shown on screen, I can now have custom fields that show only for certain case types - use case HR casewok - grievance, disciplinary, probation etc edit JSON layout. once again thanks! :D
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...
Lets hope so
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
@@nickwestmoreland7439 Too much work. I would suggest using Power Apps in that case.
Someone pay this dude! He is the man!
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!
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 - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
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 .
Thank you for your kind words.
This is one of the best videos that I’ve seen. It showed me something that I thought cannot be done in SharePoint list
Thank you 😊
Wow! This will be a main reference video for using and customizing SP Lists.
Thanks so much.
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
3 - I believe section name can only be hardcoded text as of now
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.
@@manublr I don’t think it’s possible via JSON at the moment.
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. 😇
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!
Most welcome
THANK YOU!! Watched your video today and was able to configure the look of my list form. Unfortunately, I could not get the conditional formatting to work no matter how hard I tried, but I'll play around with it more.
Most welcome!
Keep trying, it might have to do with internal names of your columns.
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!
You are so welcome!
I'm your No. 1 fan in the Philippines! Great video!
Wow, thanks. Appreciate the support.
Wonderful session. Using Json itself now able to do more list form customization with conditional formatting without need of jquery and css. Thanks!
Absolutely. Just by writing simple JSON we can get so much done.
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.
Thanks! Choosing between SP JSON forms and Power Apps is a video topic I am working on.
This video helped soooooo much in my Sharepoint Development path. Thanks a thousand times Reza !
Glad to hear that. Thank You for watching.
Thanks for this great info! I may be able to avoid PowerApps in some circumstances by utilizing some of these techniques.
Glad it was helpful!
Amazing video, thank you so much...i learned so much with you...and big thanks for the links...extremely useful
Most welcome!
Hi Reza, Thank you for this video, it has greatly improved my understanding of using JSON and SharePoint formatting.
Glad it was helpful!
Excellent video. Thank you for sharing all the SharePoint tricks
Thank You.
If you enjoyed list formatting, then check out ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
So cool! This is going to be so amazing to avoid PowerApps which is awesome but an administrators nightmare.
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.
Why do you say Admin nightmare? Curious as we are trying to learn it but want to know the negative side too. Thanks.
Excellent one... Helped me a lot in understanding MS Lists. - Thank you.
Most welcome
One word--BRILLIANT!!!!!
Thank You!
Reinforced a few points I knew, and showed a few new ones. Well put together video at a great pace. Thank you :)
Awesome, thank you!
Thank You! Seriously this is one of the best tutorials on this subject
Wow, thanks!
Thank you for being smart so I don't have to. 🤗
You’re welcome 😊
Excellent video thank you Reza!
Glad you enjoyed it
Great video! Will help a lot with a project…thanks
Glad to know the video is helpful. Thanks for watching
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?
Most welcome!
Json formatting does not apply to power apps.
Great Video. Thanks for sharing.
Thank You for watching
Great Video, thank you for sharing your knowledge.
You’re most welcome
@@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.
@@alpanapradhan2328 You can either use JSON formatting or Power Apps. You cannot use both.
@@RezaDorrani Thankyou for the reply, can we use Lists and Forms instead of PowerApps with similar functionalities.
@@alpanapradhan2328 You could
This very useful. Thank you. I was not aware that you can do this in SP.
You are most welcome. List form customization is one of my favorites.
This is simple WOW. Amazing Demo.
Thanks Manish
Thanks a lot Reza. inspirational for starting
My pleasure
Awesome video! Thanks for the great information presented so smoothly!
Glad you enjoyed it!
Awesome video. Very well explained. Thank you so much.
You're very welcome!
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.
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
Loved this, thank you so much
Most welcome!
Excellent description. Thanks for this good work !!
Glad you liked it!
Great video Reza, thank you.
My tenant did not receive this update :(
Currently, rolling out to first release and targeted tenants only.
Love your videos. Thank you.
Thanks for watching!
Amazing video. Thank you
Most welcome
Thanks you saved my life !!!
Happy to help
Outstanding Tutorial! Thank you I’ve learned so much!!!! New Sub👍🏾
Awesome! Thanks for the sub!
Fantastic 🎉🎉
Thanks
Hi Reza, your every video give something new. Thanks for sharing knowledge. Is there any way to make attachments in SP list as mandatory ?
Thank You for liking the video.
Not in SP or via JSON formatting. You can do it in Power Apps!
Absolutely brilliant. Thank you!
You're very welcome!
Very thorough and informative! I am really enjoying those forms. I also implemented Site Columns and unfortunately when I am refreshing them the conditional setting for the column is disapearing. Is there a way to add it together with other json formatting via site column?
If not maybe there is file with settings, a schema I could plunk in each time I do the refresh of the columns, cause it will be a lot of work to set it up manually again. Any thoughts?
I have not tried with site columns, hence not sure if there is some limitations there of changing json.
Thank you for your videos, I do have a some trouble getting this funtions to work.
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
Thx for the tutorial
Something to note, if you rename the column name, it wont find the field and add it to the last section. Renaming isnt impacting power apps though if you add new field, it wont reflect in powerapps. Choose the right solution for you and your users :)
True. But this is new and things will improve. I wish they took the internal name of the column.
So useful! Thank you.
Thanks for watching
Great video
Thanks!
What a great teacher! Thx
Thank You
Very informative Reza... Loved the content!!!
Glad you enjoyed it!
Thank you so much for the video. Everything worked perfectly except one thing: I am completely stuck at the conditional formatting when it comes to unhide the column when the assigned person is logged in. I tried every scenario even with different formulas all referred to "Person" fields but nothing work. Do you have an idea what could be wrong with my formatting when it comes to get info from a "Person" field? Maybe some settings I should change? Please help 🙏
I have not come across this issue hence not sure what can be the reason for it not working. I will recommend posting your issue on forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint in case someone else has run into something similar
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?
I don’t believe thats an option
Great session, useful channel
Thank you
really helpful !!! thnak you
Thank you for watching
Great video as always , love this , it saves a lot of time. Keep them coming
Thanks
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)?
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.
@@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
Thank you. Very well explained!
You are welcome!
Super awesome tips!👏 Thanks for sharing 😃
Thank you Daniel
Thanks for the video Reza - very informative. Quick question - is it possible to change the size and colour of Section Headings in Forms?
Currently, section heading styling is not supported
great video
Thanks!
Just a tip for this, if you hide columns in the default view that you are not using, for example calculated columns and the like, then they won't appear in the form at the end of it after formatting it
Thanks for sharing!
Very helpful :) Thank You
Your are most welcome
@@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.
@@kalpanavaidya6788 Setting field values in not supported. This is only to add formatting.
As always, great stuff Reza. I have a question, it appears that a calculated column will not appear in the new/edit form that you add to the body JSON. I have tried it a couple of times and every thing else (so far) does show up as placed, except calculated columns. Is this a problem or is another wrinkle required to include such column types for display using JSON?
Calculated columns are calculated at run time. Not when editing or creating items.
Sad to hear, but thanks for the info on this. @@RezaDorrani
Very informative video 👍👍
Thanks a lot
Hi Reza! GREAT video, i love it, i could increase the customization of my forms without PowerApps, because we don't want mu end-users to have license of powerapps assigned.
Then, we have found problems if the name of columns are complex 3 or 4 words and blanks spaces. How can we use the value of this fields in the form or in the formulas to hide/show other columns?
And another more question, it's possible to customize the background color of the body section in json?
Show hide columns is possible. Body does not allow customizations apart from sectionizing.
Here is my full playlist on JSON formatting - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
Thank you for response.
You're welcome
@@RezaDorrani do you have a vidio that shows how to make fields hide depending on other fields?
@@kracken71 I have a playlist on json customization. It may be in there else I may not have done it.
Hi Reza, I am following your videos for the past few days in search of my problem. I have an excel file containing four spreadsheets having a single similar column in all of them. The column contains the initials of different departments whose work is pending, done, and on hold. I want to automate that column so that only the person of the respective department with pending work gets the email notification twice a week. Can you suggest to me the process to achieve this or any of your video(s) with a similar context? BTW your videos are really informative and I have created some flows by watching your videos for my org which got greatly appreciated as I have zero knowledge of coding and business tools.
Thanks for the feedback on the video content.
I do not have any video reference on your scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Great overview. Thank you!
Thank you Denis
Hi Reza great video thank you for this ill be adding the header and footer section to my list. I have a question but im not sure if its possible: Im trying to increase the width of just one of my inputs (Multiple lines of text) to twice the width so it easier to read the desriptions instead of scrolling down, is there a JSON formula that will allow one of the fields to be twice as long as others? Thank you in advance.
Thanks so much.
Currently, JSON formatting does not allow increasing width of the controls.
Nice video. Thanks for your Help! very useful.
You're welcome!
I would like to have a section called "instructions" that doesn't have any fields in it but rather only some text explaining to user how to fill out the form. I started with the sample JSON for body section and have been trying to modify it to handle this. I have gotten it to the point of showing the section, but am having trouble figuring out how to add the instruction text. If you can help you will save me a lot more googling! Ty in advance, your videos are awesome
I have not tried this before so not sure. Googling will be an option :)
@@RezaDorrani lol I know how I will be spending my day tomorrow 😅
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?
Not sure about that one to be honest. Never tried it.
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?
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.
Great video, Reza!
Do you know if other people in SharePoint can see Power Apps form customization without Power Apps license?
This video does not use Power Apps.
If Power Apps is used, then a Power Apps license is needed.
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?
Absolutely Yes.
My playlist has 3 videos and many more coming - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
@@RezaDorrani Will watch all three thanks a bunch
@@RichardDalrympleplus There is also chapter 4 that releases today :)
@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
I believe person type has a bug. Not consistent.
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.
Thanks for watching and liking my videos.
Currently, disabling fields is not supported with JSON formatting.
You would need to leverage PowerApps for that.
Great video! Your tutorial was clear and easy to follow. Qsn, can this be apply on Document library as well?
Yes, absolutely
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
Currently, I do not believe that is an option.
Check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Grate introduction! THANKS!
Is it also possible to separate the form into tabs, for switching between them and have a good overview?
Thank You for liking the video.
Tabs is currently not possible with JSON but you could build Tabs by customizing the form with Power Apps.
Check ruclips.net/video/KjUJZr5Vn_Y/видео.html
Thanks for fast answer, but I'm looking for a possibility without PowerApps.
Do you know another implementation option in JSON body formatting to get more clarity?
@@mauricehermsdorf1509 Tabs is currently not possible with JSON formatting
Thanks. One more question: Is it possible to Edit conditional Formular for a multi value field with more them one value? With the Normal oporator == its not possible
@@mauricehermsdorf1509 Operations are very limited with multi select fields. Documentation has all the information.
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?
JSON body does not provide formatting options.
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.
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
I love the new feature, but just for information, what would be the negatives if we use customize forms using PowerApps, do we have issues like delegation(I guess its no, as its not searching or filtering anything), or another negative apart.
No delegation issues. JSON form formatting is native SP functionality.
There is no such negative aspect to it.
This is another alternative to customize list forms.
Hi Reza! excellent video, One question,
How can I do so that a member of the sharepoint list cannot modify body format Json? Thank you so much!
Break list permissions and set members permission level to contribute instead of edit
Awesome video. A question from my end is whether we could hide the entire section based using the conditional formatting ??
That option is currently not available. You would have to individually hide each column within a section.
👏🏾👏🏾👏🏾
👍
Hi Reza, as usual, great job with your video. Is it possible to customize the new list form using JSON or is that solely done using PowerApps.
Can be done using JSON or Power Apps
@@RezaDorrani OK Thank you, I was able to modify the edit form but did not see a place where I could add JSON for the new list form.
@@MrBookerSam it should be as shown in video
@@RezaDorrani OK great, I will check the video again. I may have missed where JSON is used to modify the new list form. Thank you Reza !
Thanks Reza for this. I have a problem with a column that is date and time. Assume I enter a new element and specify a date and time. If I select the element and say modify, the time will be 3 hours ahead. Every time I say "Modify", the time advance by 3 hrs. This does not happen if I right click and I say "details". Then, I see the correct time. Any idea what the problem might be? Thanks in advance.
This seems to be a time zone-based issue. SP site time zone vs your local time zone. I have not come across this issue though.
I would recommend posting your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint in case someone else has run into a similar issue.
Danke!
Thank You!
Excellent demo Reza.
Do you know if it is possible to associate an onclick event to the save button in the New form via the json? I would like to redirect to a success message page rather than returning to the list.
Thanks!
Currently, that’s not an option as far as I know.
If you are hiding columns for your form and it does not work - check the column name via list settings, then click column name.
For example "Case Type" could be name by SP as "Case_x0020_Type" check at the the end of the url after = for actual technical name if your if formulas for hiding columns doesnt work.
Well said. It’s important to use the internal names of the columns.
🎉love your channel!
Question: I have a customer who’d like a Julian date calendar number that would be system generated with assigned task/number series. Any advice?
Thanks so much.
Ohh this is not something I have tried or have a reference for.
Nice video. Can u please create a video of displaying project lists from Project online........in sharepoint modern list.
I have not done any work with project online.
@@RezaDorrani No Problem. But it would be good to create a new risk or issue or lessons learned for a project.
@@Anilkumar-cd7yr Yes but project online is not my expertise. If I ever learn it, I will blog about it.
Very brillant demonstration. Nevertheless, i have one question . When i have integrated my list to powerapps, the only size available was a phone size FORMS. Is there any way to get a tablet size integrating the list related to a powerapps app FORMS ?
Check ruclips.net/video/aFzd5qwS4-c/видео.html
Great content as always. 👌
Thank you Sadab
Hi Reza, i hope you are fine, i have a question, when i edit the JSON to give format to the form it goes wider, however if i a new user consults the form or i completely close the sharepoint and reopen, the form goes back to the narrow version. I definitely like more the wider version, how can i set up the form to display always the same wider version? I hope you can help me out.
Nice videos in your channel, i appreciate your work :)
The form size is dynamic (auto handled) and cannot be controlled.
They've made show and hide colums way harder now (july 2021) so many other tips I've used though thanks!
Welcome
@@RezaDorrani Update: I've had a coffee and revisited and it works exactly as shown on screen, I can now have custom fields that show only for certain case types - use case HR casewok - grievance, disciplinary, probation etc edit JSON layout. once again thanks! :D
@@samhall100 So the ☕️ worked 😊
@@RezaDorraniI think sometimes I get that excited with your video's I rushed into it + coffee did help. You've helped me so much through RUclips
@@samhall100 Thank you 🙏 for watching my videos. I am always so nervous prior to every video release.