Another great video. To get the internal names of columns, I copy the columns from List Settings, paste them in Excel and use an User Defined Function to extract the URL and then extract the name after the last =. Function GetURL(rng As Range) As String On Error Resume Next GetURL = rng.Hyperlinks(1).Address End Function One of my lists has 100+ columns. As a best practice, I always try to create columns without spaces in the name and then insert spaces or underscore etc in the Display name.
Very very excellent video, by this JSON Customization will reduce a lot effort of developer. Even if we don't have requirement of other connectors, then I think no need to go development of Power Apps for responsiveness only.
Reza, once again, you are the man. 5:16 - I'm hitting my forehead on the desk wondering why my JSON code isn't picking up the columnname. I wasn't using the internal name of the column.
Thank you very much Reza Dorrani!! Excellent! A doubt, I have a column of the type hyperlink or image, would there be any way to display this image Url in the header?
Many thanks, Reza - excellent video! May you show more detail for the "Dynamic Multi-Steps Approvals Base on Expense Type"? I need help how to get the Approvers in the Sharepoint list. Thanks a lot.
Thank you for the great video. Is there a way to display the read-only fields like the Created, Created By, Modified, etc. Tried including them in the sections but they would not display
Currently, those read only columns are not available in the form customization. I wish it was. One subscriber did mention that if you create a calculated column that gets its data from those read only columns, then you could include them in the form. I have not tried it, but worth a shot.
@@RezaDorrani Hello. Just tried the calculated column which reads a single text column and those don't work... oh well, I'm sure they'll figure that one out soon!
Thanks Reza for this awesome video. May I ask an additional question? Is there a possibility to check the default language or site language of the users choice and then display the cells/columns according to the language?
The schema does not have a formula to check the default language or site language today developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json
Awesome video. I noticed when you added your json formatting to the list, 3 columns were displayed across the canvas. When I did it, only 2 columns across the canvas. Can the width of the canvas be increased to allow more columns across? I noticed as I pulled my browser to widen it, the form remained the same size with only 2 columns. Do you know how this value is set and why it would be different between your build and mine?
Great video as always... you helped me avoid building a power app! Have you managed to get object variables in the header to work at all? Eg put a person's name in the header or a lookup column value?
It does act up for complex data types. I'm sure these will be fixed soon. Here is my ull playlist which has more scenarios covered: ua-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Hi Reza thanks a lot for the video!!! Is there a way to add clickable button to trigger a power automate flow in the forms view? i seem to only to make it work in the list view :(
Great video as always, Reza! Do you whether it is possible or not to have a group of fields not available for editing when someone belongs to a SharePoint group?
Possible but in Power Apps not with the JSON formatting. I am working on a video around role based column editing in Power Apps which will cover exactly the scenario you mentioned.
Hello friend, excellent video. Is it possible to hide and show entire sections like fields? That way I wouldn't have to hide every field in a section. Thanks for sharing your knowledge.
thanks Reza one more time for this fantastic video. I was just wondering if there is a way to perform validation more than show/hide of column?? Can we display error message based on drop down value selected or similar like in SharePoint online list form??
Possible by using the list validation settings and writing expressions there. I think I covered it in one of my videos. Check this playlist ua-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
@@RezaDorrani Thanks Reza!, one more question, when you use json in the body of the form, can you split the form with different layouts? e.g top half is two rows of three, then under that is maybe a section that is just two columns? hope that makes sense - luv your work!
Hi Reze , Nice one!! thanks to your videos which its help lot of users. any ways to format body column fields labels? Means the important fields I want change the filed label colour to Red. its posible?
@@RezaDorrani Thank you Reza. Appreciate your response. I'm delivering my first few json forms today in public health sector in Australia. All thanks to you. Your videos have been a great reference.
Hi, cool video, is it possible to add different contact email address? Is it also possible to add an button to add a new item to this list instead of going to the standard version?
is it possible to add different contact email address? - You can create multiple person type columns and user can pick any user from AD Is it also possible to add an button to add a new item to this list instead of going to the standard version? - Add button opens the custom form. Not sure what you mean by standard version.
Hi Reza, many thanks for that very helpful video. Unfortunately the link to the PnP Samples doesn't work anymore. can you fix it or send me the correct link?
Hi Reza, is there any way with JSON to show a Field in "read mode" in the Sharepoint List form? Because this Field is completing only in a Power App and I do not want that someone change it in SharePoint. Thanks in advance
Hi Reza, I want give permission to user to read or read and write only based on the stage value . What factors should i consider in formatting json so that based on stage value, user can either just read or sometimes can write value on it too?
Hi Reza, why my default list form there is not a edit icon there? only a cross to close and show comments icon....OK, found it, in details mode Thank you share...
developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json Not all features are supported for form formatting and I did not see any official documentation on what is supported.
Hi Reza when using Json formatting, SharePoint list is showing alot of performance degradation. There are hardly 30-40 items but page loading takes more than 15 seconds to load up. Any solution for that ? Thank you
Did not experience this. I have a client using a list with around 15-20 formats but works fine. I would recommend you raise a ticket with Microsoft to check on the issue.
Hi Reza I want to remove "New Item" ribbon while creating a new entry to the list and also want to set the current user email id to people field. Please help me....
@@suthanchidambaram3880 Create a Power App from the SharePoint list. I do not have a video based on your scenario. I will recommend checking on the forums at powerusers.microsoft.com
The body JSON only allows creating sections and no other formatting is allowed. You would have to use Power Apps to create tabs - ua-cam.com/play/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR.html
@@RezaDorrani i saw your vídeos i really apreciate but Just need a symple script that i can input image column data on header sharepoint list. Your solution vídeos it' s to much advanced for me
@@icarooliveira2688 Most of list formatting videos have samples shared. Links in video description. If you need any additional help, I would recommend checking or posting on SharePoint Forums.
The final part (page setup) is dangerous and therefore becomes useless. If a user makes more than one selection the asset reference becomes blank and is automatically saved as blank changing the record. If it is a mandatory field, the properties area just displays the field and a save button. Deselecting the asset reference safely returns you back but it is unclear that that is the action required. Making the whole properties record read only doesn’t really work either . The only solution is if the user is only allowed to make one selection at a time in the asset reference list on the left. Unless there is a clever validation I am missing. Shame as it so close to being useful
Many thanks Reza - great video!. Shows just how much power exists in SharePoint as a standalone platform
SharePoint is still alive and powerful
Super useful - my brain is already concocting use-case scenarios! Thanks for taking the time to put this together.
Glad to hear that. Thanks for watching.
Another great video.
To get the internal names of columns, I copy the columns from List Settings, paste them in Excel and use an User Defined Function to extract the URL and then extract the name after the last =.
Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function
One of my lists has 100+ columns.
As a best practice, I always try to create columns without spaces in the name and then insert spaces or underscore etc in the Display name.
Great tip! Thanks for sharing.
Very very excellent video, by this JSON Customization will reduce a lot effort of developer. Even if we don't have requirement of other connectors, then I think no need to go development of Power Apps for responsiveness only.
Agreed.
Thanks for this, I will do it tomorrow, and I will leave everyone with a square eye, I promise to give you the credits🙊
Nice 👍
Go for it.
I didn't understand some of it but I think by trial and error i'll learn it. Appreciate the video
Video description has links to sample code.
Thanks Reza you are a star! I need to follow this over the weekend as I need to send an email once the status is complete.
Enjoy the videos this weekend
Your voice ,style of topic explanation , and your content Quality you compels us for watch full video 😎😊😊 like a magnate.
It’s really amazing
Thank you so much 😀
Reza, once again, you are the man. 5:16 - I'm hitting my forehead on the desk wondering why my JSON code isn't picking up the columnname. I wasn't using the internal name of the column.
Internal names are a must now
Reza is the synonym of awesome videos! Thanks for sharing! 👏👏
Thank You Sir
I love all the videos, using json in list formatting helps me lots
Happy to hear that
Top video Reza! You are a source of knowledge and inspiration.
Thank you Mario
love you stuff. Digital smart forms are such a vital aspect of good project management and I honestly do not feel as they are user nearly enough.
Agreed 100%
Thanks Reza, I will be learning new things in each of your vidoe. Thanks for sharing these.
My pleasure!
Thanks again. We either learn this stuff through osmosis, using the force or from your videos.
Glad to hear it!
Your video is really helpful Reza. Thank you very much.
You're welcome
Excellent session and tremendous effort, thanks for sharing 👏🏻
Thanks for appreciating the effort.
I really like it. Thank you for doing this.
My pleasure!
Amazing! Subscribed!
Thanks for the sub!
Reza thanks for videos. You are really awesome. Thank you.!!!
Thanks Bob
This is a great live 👏 🙌 👌 👍 ❤
Thank You
Thank you very much Reza Dorrani!! Excellent! A doubt, I have a column of the type hyperlink or image, would there be any way to display this image Url in the header?
I believe that is possible.
Check the documentation - docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
Thks for sharing!
Most welcome
GREAT!!
Thanks
Hi Reza,
Great video, really helpful. Is it possible to show the map based on the location field withing the form formatting?
Check ua-cam.com/video/40NJOwydzHE/v-deo.html
Many thanks, Reza - excellent video!
May you show more detail for the "Dynamic Multi-Steps Approvals Base on Expense Type"?
I need help how to get the Approvers in the Sharepoint list.
Thanks a lot.
I have done 18 videos on approvals. They are all in my approvals playlist. I recommend checking that.
Thank you for the great video. Is there a way to display the read-only fields like the Created, Created By, Modified, etc. Tried including them in the sections but they would not display
Currently, those read only columns are not available in the form customization. I wish it was. One subscriber did mention that if you create a calculated column that gets its data from those read only columns, then you could include them in the form. I have not tried it, but worth a shot.
@@RezaDorrani Hello. Just tried the calculated column which reads a single text column and those don't work... oh well, I'm sure they'll figure that one out soon!
@@zghaboos I hope they do :)
Thanks Reza for this awesome video. May I ask an additional question? Is there a possibility to check the default language or site language of the users choice and then display the cells/columns according to the language?
The schema does not have a formula to check the default language or site language today
developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json
Awesome video. I noticed when you added your json formatting to the list, 3 columns were displayed across the canvas. When I did it, only 2 columns across the canvas. Can the width of the canvas be increased to allow more columns across? I noticed as I pulled my browser to widen it, the form remained the same size with only 2 columns. Do you know how this value is set and why it would be different between your build and mine?
That width is set automatically depending upon window width. You may have to refresh the web page to see the updates.
Great video .. is there a way to wrap column headers on MS list? The default is no-wrap, which doesn't work for long column names
I don’t think we have an option for that
Great video as always... you helped me avoid building a power app! Have you managed to get object variables in the header to work at all? Eg put a person's name in the header or a lookup column value?
It does act up for complex data types. I'm sure these will be fixed soon. Here is my ull playlist which has more scenarios covered: ua-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Hi Reza thanks a lot for the video!!! Is there a way to add clickable button to trigger a power automate flow in the forms view? i seem to only to make it work in the list view :(
Currently calling a flow is not supported.
Great video as always, Reza! Do you whether it is possible or not to have a group of fields not available for editing when someone belongs to a SharePoint group?
Possible but in Power Apps not with the JSON formatting. I am working on a video around role based column editing in Power Apps which will cover exactly the scenario you mentioned.
great video!
Thanks
Hello friend, excellent video. Is it possible to hide and show entire sections like fields? That way I wouldn't have to hide every field in a section. Thanks for sharing your knowledge.
Hide/Show sections is currently not supported.
thanks Reza one more time for this fantastic video. I was just wondering if there is a way to perform validation more than show/hide of column?? Can we display error message based on drop down value selected or similar like in SharePoint online list form??
Possible by using the list validation settings and writing expressions there.
I think I covered it in one of my videos. Check this playlist ua-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Thanks Reza
Most welcome
Hey Reza Great Video. I was wondering if there is any way to conditionally hide columns based on form type i.e new form or edit form?
That option is currently not available.
as always great stuff Reza!, question: can you make a field like status read-only? so when a user opens the form the status field cannot be edited?
This feature only supports formatting. To make field read-only based on status, you would need to use Power Apps
@@RezaDorrani Thanks Reza!, one more question, when you use json in the body of the form, can you split the form with different layouts? e.g top half is two rows of three, then under that is maybe a section that is just two columns? hope that makes sense - luv your work!
@@chaddytee726 One cannot define how the columns will be displayed in sections. It automatically places it in the sections.
Hi Reze , Nice one!! thanks to your videos which its help lot of users. any ways to format body column fields labels? Means the important fields I want change the filed label colour to Red. its posible?
Body formatting is not an option at the moment.
You would want to look at Power Apps for that.
Hi Reza, fandtastic video! Is it possible to add a button to trigger a flow in the header or footer? Similar to a column list view formatting?
Unfortunately not. Currently, this is not supported.
Great video. Can we also increase column width in body section? For example - Increase width of Condition Notes column
Currently, No option to increase width.
@@RezaDorrani Thank you Reza. Appreciate your response. I'm delivering my first few json forms today in public health sector in Australia. All thanks to you. Your videos have been a great reference.
@@akshaykathuria06 Best of luck
@@RezaDorrani Thanks.
Waiting
Hope it’s worth the wait
Reaza great work, but can i use lookup columns in the list form i see alla other columns in the list form but not the lookup columns, Thanks!
I believe you can. Not sure why it wont show up on forms for you.
@@RezaDorrani Thanks. but the Lookup Columns does not show in the list form more then one
@@tommyrihu824 I don’t know why that is happening
Do you also have a video how to mange 100+ images in sharepoint? Or are there any tipps should I use assets or list?
I do not have a video reference on this scenario. 100+ images would be best to store in doc libraries.
Hey Reza, Is it possible to format the view names at the top pf the list in classic experience?
Classic SharePoint does not support json formatting
Hi, cool video, is it possible to add different contact email address? Is it also possible to add an button to add a new item to this list instead of going to the standard version?
is it possible to add different contact email address? - You can create multiple person type columns and user can pick any user from AD
Is it also possible to add an button to add a new item to this list instead of going to the standard version? - Add button opens the custom form. Not sure what you mean by standard version.
Which permission will impact editing the JSON by user on the list column and form?
I believe its Edit permission.
Hi, can we highlight the duplicate values in a particular column?
That is currently not an option with JSON formatting.
Reza, is it possible to disable a column in a OOTB sharepoint list form based on a condition like a column status?
Disable columns is currently not an option.
Hi Reza, many thanks for that very helpful video. Unfortunately the link to the PnP Samples doesn't work anymore. can you fix it or send me the correct link?
They changed the link :) Here is the updated one - pnp.github.io/List-Formatting/
Is there anyway to input a search above the assets manager on the SharePoint page for a large number of assessts
I am not aware of an option to do that
Hi Reza, is it possible to make specific fields in New/Edit Form read-only/disabled using the BODY Json Formatting?
I don’t think there is currently an option to make field read only with JSON formatting
Hi Reza, is it possible to line break in displayname (ie title)?
I would like create body title like this:
By submitting this form, you must checked
(a) XXXX
(b) XXXX
field
I tried
doesn't work
May be possible.
Check with twitter.com/techan_k or check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi, Reza, is working in JSON Form Formatting also possible when your field on which you want to rely is a managed metadata choice field ?
I believe MMS columns are not currently supported.
@@RezaDorrani any chance it will become in the future in your opinion?
@@eddyfeys Hopefully it would.
👍Thks Resa, where is source of json header please, ?
Video description has all the links.
Hi Reza, is there any way with JSON to show a Field in "read mode" in the Sharepoint List form? Because this Field is completing only in a Power App and I do not want that someone change it in SharePoint. Thanks in advance
JSON form formatting only allows formatting. Not possible to change field modes as of today.
My first comment. ❤ where can we get the json header template to copy and paste it? Hope to hear from you?
Thanks!
Did you check the link in video description?
Can we auto populate field data based on another column data using JSON?
I don’t believe that is possible as of now.
Hi Reza,
I want give permission to user to read or read and write only based on the stage value . What factors should i consider in formatting json so that based on stage value, user can either just read or sometimes can write value on it too?
Json is only for formatting data. You cannot set permissions or make fields read-only with it.
Hi Reza, why my default list form there is not a edit icon there?
only a cross to close and show comments icon....OK, found it, in details mode
Thank you share...
Looks like you got the answer!
I'm wondering if can we link a list to another list?
Yes, you can add anchor tags - docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#create-clickable-actions
can we achieve 'fetching data from another list' without Rest-API calls & Lookup??
using JSON formatting mechanism.
No. JSON formatting is only to format data.
@@RezaDorrani Okay, Thank you
BTW it's an excellent session.
@@RezaDorrani and one more doubt, can we make a lookup column as an 'auto-complete' textbox, unlike drop-down.
@@manoharmeesala3827 Only formatting is allowed. No changing control types. For those kind of changes, you will need Power Apps.
Can you share the JSON code that you showed in the Video?
Video description has link to download the JSON code from my GitHub repo
Thanks Reza for the video! is it possible to use person column on the header ? I try [$ColumnName.title] or [$ColumnName.email] without success.
it works but only in new mode not in view or edit mode
Known issue. Works when you click on the control. That was one of the reasons why I avoided it as part of my demo.
@@RezaDorrani Thanks Reza. in my use case, the user could use the form to update their photo
@@bambaseye Currently, not possible. Hopefully, more options open up in future.
Hi is there a way to remove the list element automatically if the date is over and archive?
Not with list formatting. You may want to look at flow for that.
@@RezaDorrani thanks for your response. So can you maybe make a video where it shows how to handle such a case?
@@shin81able I make videos when I receive multiple requests on a topic. I have video ideas with over 30+ requests in my backlog.
@@RezaDorrani OK I see thanks
How would I change the font in the body
I don't believe that is an option.
@@RezaDorrani awww that sucks.. my boss is obsessed with Cambria which makes life a bit difficult for me thanks for the response
Never heard of "Cambria"
Where can I find a reference for the functions I can use in the JSON code?
developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json
Not all features are supported for form formatting and I did not see any official documentation on what is supported.
Hi Reza when using Json formatting, SharePoint list is showing alot of performance degradation. There are hardly 30-40 items but page loading takes more than 15 seconds to load up. Any solution for that ?
Thank you
Did not experience this. I have a client using a list with around 15-20 formats but works fine.
I would recommend you raise a ticket with Microsoft to check on the issue.
Hi Reza I want to remove "New Item" ribbon while creating a new entry to the list and also want to set the current user email id to people field. Please help me....
New Item ribbon cannot be changed using JSON. It will show up depending upon user access to SharePoint list.
@@RezaDorrani is there any other way to remove that. And I also want to auto populate email id field with the current user's E-mail ID. Please help...
@@suthanchidambaram3880 Create a Power App from the SharePoint list.
I do not have a video based on your scenario.
I will recommend checking on the forums at powerusers.microsoft.com
hi, how do i convert this code to json code
I'm not sure about this.
Check on the forums techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint or connect with twitter.com/techan_k
How can we add tabs in list ?
The body JSON only allows creating sections and no other formatting is allowed.
You would have to use Power Apps to create tabs - ua-cam.com/play/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR.html
how i can put img to my list header sharepoint view? someone have any script?
SharePoint view or form?
Video shows how to add image on form.
I have a playlist on SharePoint list formatting. You can check that.
@@RezaDorrani i saw your vídeos i really apreciate but Just need a symple script that i can input image column data on header sharepoint list. Your solution vídeos it' s to much advanced for me
@@icarooliveira2688 Most of list formatting videos have samples shared. Links in video description.
If you need any additional help, I would recommend checking or posting on SharePoint Forums.
Note: validation doesn't work against metadata fields - those fields are not available / visible.
Silly of MS....
Certain field types are currently not supported.
I cannot find Validation Settings under "List Setting"
social.technet.microsoft.com/Forums/office/en-US/187771bf-b60b-46b4-b871-9d593627b69d/missing-validation-settings-under-general-settings
The final part (page setup) is dangerous and therefore becomes useless. If a user makes more than one selection the asset reference becomes blank and is automatically saved as blank changing the record. If it is a mandatory field, the properties area just displays the field and a save button.
Deselecting the asset reference safely returns you back but it is unclear that that is the action required. Making the whole properties record read only doesn’t really work either .
The only solution is if the user is only allowed to make one selection at a time in the asset reference list on the left. Unless there is a clever validation I am missing. Shame as it so close to being useful
I believe there is a way to avoid showcasing the selection option.
In the formatting itself, a link or icon can be provided to launch the properties.
@@RezaDorrani Thank you for taking the time to reply. A good idea hampered by a flaw in the design, as is the MS way.