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 - th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
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 .
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!
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!
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.
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.
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?
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.
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?
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.
@@RezaDorrani you are exactly correct! I had renamed my columns, not realizing that the original name was what was required to make the formatting work. Thank you!
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. 😇
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?
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.
Reza, at 9:14 when you look at this moment of the video, you will see your "New Item" panel is open with all your fields. Do you see how each field has a small icon to the left of its name? How can replace these icons with Fluent UI icons or any other icons, or remove them? Some of the icon selections could be better for my project so that they match better with my field names. Thanks for any tips.
Those icons are based on the column types and are an inbuilt feature with SharePoint forms that cannot be customized. If you need your own icons and more control, you would need to use Power Apps. I have a video coming this Tuesday on exactly that - "Customizing SharePoint list forms with Power Apps"
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 had the formula prepared beforehand. Check video description. It has links to documentation where you can learn more about the conditional formatting formulas.
Great video! If I create a section in the body with one element, is there any way to set the width of that single textbox as wide as the form itself (without power apps)? Thanks for your proper feedback!
@@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.
Great video Reza! Is there a way to order/organise the columns once they are in a section? Eg I have column names 2A), 2B), 2C), 2D), 2E) that appear in correct order but when I tried putting them into sections, my list now seems to be a mixed order and appear as 2D), 2E), 2A), 2B), 2C). I tried the edit columns to try moving/positioning the correct order but it didn't seem to work. Any ideas/tips please? :)
@@RezaDorrani Thanks Reza, it turned out the columns that were out of order were 'newly added' to the SharePoint list I was using. With the help of a colleague, I was also having syncing issues on my device which seemed to be causing dramas. Thanks for the reply and tips. Great video content :)
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 - th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Great video - outstanding! Is there a way to bold the text of the column headers in the form similar to the section text? Also, is there a way to color shade a section in the form to highlight the section? Thank you so much, Reza!
Hi Reza many thanks for this & I've one extended question. I have a SharePoint list that tracks recruitments. The list's form is customized just like what you showed us here. Now I want to add tasks associated with each item. one recruitment may have many tasks associated with it. For the tasks, I've created another list called 'Task tracker'. My objective is to get something like when the user clicks add task a new child form will pop out with columns(task id, task-topic, task-detail, assigned-to, deadline). Is there a way to configure such things for a similar form without using Powerapps?
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 th-cam.com/video/KjUJZr5Vn_Y/w-d-xo.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
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?
🎉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?
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 :)
thank you so much for this! life saver - just wondering how to add a second condition for the header using json (very new to this!) I'd like to have issue: title_status so "title" plus "status" field, is this possible?
Possible! I have done a full series of videos on formatting. I think I may have shown multiple in one of those. Check th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
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.
Thanks for the video. good job! Perhaps the question has been raised before but when I click on Edit the all formatting is gone. Then I click saved it goes back to normal meaning with the good formatting . do you have the same?
@@RezaDorrani in my case it did not solve the issue but this yes --> turning off the sync for the list in List Settings > Advanced Settings > Set Offline client availability to No."
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
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
Reza in regards to setting a "default" photo image for a column that is a photo for a SharePoint list, can I get away with doing that with JSON? Or do I need Power Apps at this point?
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?
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?
@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
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?
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. The header is great but for some reason when I attempt to adapt it to my list, if does not work. You have a Status Column, min is called 'Request Status'. When I change this the =if([$Status]... To if([$Request Status] and change the statuses to my status values, it simply ignores them or returns an empty header. Am I missing something about this script?
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?
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
Great content Reza..!! I have tried the same and it's very helpful. I have a question though , i have added a new column to the existing SP list but i cannot find the field for entry , also when i look at the Edit column i cannot see it , but i can view it in the grid view .. Any specific reason for that..
I will have to look at your list to know more about your issue. I will recommend you post your issue with screenshots 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.
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 ?
Is there a way to customize the form with JSON without it using the multi-column layout? For example, I want to have sections but just in a single column layout. Thank you.
Nice video. Just one query how to leverage this left popup default form in my homepage because I don't want my user to use this form from list database itself. Like we used to have in promoted link webparts previously where we can define the behavior of the infopath form like dialog box or open in a new tab or same window.
@reza dorrani - Great video. My sharepoint doesn't have the icon to click on to configure layout. Any suggestions? I have edit form>>edit column and customize with power apps. No configure layout.
Nevermind. MS puts it out there in their documentation list as if it is available but it hasn't been rolled out to everyone. What a pain. So your video is super great but a waste of time until you have the option available. Thanks for making it though. Thanks for nothing, Microsoft.
@@jasonparker4969 Hopefully, you get this feature soon and comeback to my video :) Im working on another video with a more advanced option for JSON formatting as well.
@@RezaDorrani yes for sure. Your video is super helpful and easy to follow. I appreciate it. So frustrated with MS though. This is not the first time @microsoft has done this. Grrrr.
@@RezaDorrani how can I use it for that? Let me tell you what I'm doing, maybe you will have a brilliant solution as usual 😂😂 I have an Ms form for the employees to submit some data, I collect this data in excel sheet. When an employee fill it in I verify the submitted info, if this employee fill it In for the 1st time I copy and past the info in a share point list, if the data submitted is not correct I send him an e-mail to correct it, if he submitted the form for the second time after changing the info submitted in the 1st time I verify it and add it in the share point list
The share point list I add the verified info is linked with a power app, so I can proceed with some extra process using the power app, and usually if the employee submitted the info for the second time and I already added him previously in the sharepoint list, I only amend the changes he did using the power app linked with the sharepoint list
@@davidadel2999 Your process sounds right. How to do it? For that I would have to try it out. I would recommend you check on forums at powerusers.microsoft.com in case someone has done something similar
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 - th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
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.
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
I'm your No. 1 fan in the Philippines! Great video!
Wow, thanks. Appreciate the support.
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!
Excellent video. Thank you for sharing all the SharePoint tricks
Thank You.
If you enjoyed list formatting, then check out th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Excellent one... Helped me a lot in understanding MS Lists. - Thank you.
Most welcome
This video helped soooooo much in my Sharepoint Development path. Thanks a thousand times Reza !
Glad to hear that. Thank You for watching.
Thank You! Seriously this is one of the best tutorials on this subject
Wow, thanks!
Hi Reza, Thank you for this video, it has greatly improved my understanding of using JSON and SharePoint formatting.
Glad it was helpful!
Danke!
Thank You!
Great and precise stuff - cheers to you Reza.
Thank You
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.
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.
One word--BRILLIANT!!!!!
Thank You!
This is simple WOW. Amazing Demo.
Thanks Manish
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.
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!
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.
Very informative Reza... Loved the content!!!
Glad you enjoyed it!
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
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
Outstanding Tutorial! Thank you I’ve learned so much!!!! New Sub👍🏾
Awesome! Thanks for the sub!
Awesome video! Thanks for the great information presented so smoothly!
Glad you enjoyed it!
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.
Excellent description. Thanks for this good work !!
Glad you liked it!
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.
@@RezaDorrani you are exactly correct! I had renamed my columns, not realizing that the original name was what was required to make the formatting work. Thank you!
Awesome video. Very well explained. Thank you so much.
You're very welcome!
Amazing video, thank you so much...i learned so much with you...and big thanks for the links...extremely useful
Most welcome!
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. 😇
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.
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.
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.
Reza, at 9:14 when you look at this moment of the video, you will see your "New Item" panel is open with all your fields. Do you see how each field has a small icon to the left of its name? How can replace these icons with Fluent UI icons or any other icons, or remove them? Some of the icon selections could be better for my project so that they match better with my field names. Thanks for any tips.
Those icons are based on the column types and are an inbuilt feature with SharePoint forms that cannot be customized.
If you need your own icons and more control, you would need to use Power Apps.
I have a video coming this Tuesday on exactly that - "Customizing SharePoint list forms with Power Apps"
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.
@10:55 where did you find the conditional formatting formula? you just pasted it in.
I had the formula prepared beforehand. Check video description. It has links to documentation where you can learn more about the conditional formatting formulas.
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!
Great session, useful channel
Thank you
Great video!
If I create a section in the body with one element, is there any way to set the width of that single textbox as wide as the form itself (without power apps)?
Thanks for your proper feedback!
Setting the widths is currently not an option.
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
Great video Reza!
Is there a way to order/organise the columns once they are in a section? Eg I have column names 2A), 2B), 2C), 2D), 2E) that appear in correct order but when I tried putting them into sections, my list now seems to be a mixed order and appear as 2D), 2E), 2A), 2B), 2C).
I tried the edit columns to try moving/positioning the correct order but it didn't seem to work. Any ideas/tips please? :)
My best guess would be the customize columns option where we can reorder fields.
The body JSON will only place fields in a section.
@@RezaDorrani Thanks Reza, it turned out the columns that were out of order were 'newly added' to the SharePoint list I was using. With the help of a colleague, I was also having syncing issues on my device which seemed to be causing dramas. Thanks for the reply and tips. Great video content :)
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
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 - th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Great video - outstanding! Is there a way to bold the text of the column headers in the form similar to the section text? Also, is there a way to color shade a section in the form to highlight the section? Thank you so much, Reza!
The body section does not support formatting.
@@RezaDorrani Thank you again!
Hi Reza many thanks for this & I've one extended question.
I have a SharePoint list that tracks recruitments. The list's form is customized just like what you showed us here. Now I want to add tasks associated with each item. one recruitment may have many tasks associated with it. For the tasks, I've created another list called 'Task tracker'.
My objective is to get something like when the user clicks add task a new child form will pop out with columns(task id, task-topic, task-detail, assigned-to, deadline). Is there a way to configure such things for a similar form without using Powerapps?
Not without power apps.
Json formatting does not have features for linking child forms.
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 th-cam.com/video/KjUJZr5Vn_Y/w-d-xo.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.
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!
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
Great video as always , love this , it saves a lot of time. Keep them coming
Thanks
Thanks a lot Reza. inspirational for starting
My pleasure
Nice video. Thanks for your Help! very useful.
You're welcome!
🎉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.
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.
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
thank you so much for this! life saver - just wondering how to add a second condition for the header using json (very new to this!) I'd like to have issue: title_status so "title" plus "status" field, is this possible?
Possible! I have done a full series of videos on formatting. I think I may have shown multiple in one of those.
Check th-cam.com/play/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf.html
Absolutely brilliant. Thank you!
You're very welcome!
Hi Reza, many thanks for the excellent content.
I'd like to insert the logo of my company on the Header, rather than that icon. Is it possible?
You can add image tags as well. I do not have a video on that though.
Check with twitter.com/techan_k
He is a legend in this field.
Fantastic 🎉🎉
Thanks
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.
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.
Thanks for the video. good job! Perhaps the question has been raised before but when I click on Edit the all formatting is gone. Then I click saved it goes back to normal meaning with the good formatting . do you have the same?
It sometimes is related to browser caching issue.
@@RezaDorrani in my case it did not solve the issue but this yes --> turning off the sync for the list in List Settings > Advanced Settings > Set Offline client availability to No."
@@Chris-mr8qm weird
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
A great video, but in my list of a communication site it does not show the option of Configure layout, min 04:33
They are currently only rolled out to first release and targeted release tenants. Will be rolling out to all tenants soon.
Thanks a lot.
@@RezaDorrani I don’t have this button either, I am looking forward to this function
Hello, an update, the button is now available in my tenant, it's time to practice.
What a great teacher! Thx
Thank You
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
Reza in regards to setting a "default" photo image for a column that is a photo for a SharePoint list, can I get away with doing that with JSON? Or do I need Power Apps at this point?
Check th-cam.com/video/fb0ePBrifP0/w-d-xo.html
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
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?
Should not be the case.
I will recommend checking on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
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.
Thanks for this! is it possible to display a new column when previous column has text (multiple/single line instead of a choic)
Yes. Conditional formulas work for single line of text columns.
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 !
Great content as always. 👌
Thank you Sadab
@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.
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?
Each field has to be conditionally hidden. The section title would still show up though.
Great video, Is there a easy way to transform the list header text orientation ( to vertical)?
I am not sure about that one. I will recommend to check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani - Thank you!
Great video! Thank you... Is there a way to customize the BODY such as colors, etc without going to PowerApps using JSON?
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. Thanks for putting it together. is it possible to apply direction, rtl in the form ?
As per my knowledge,
Rtl is not supported with JSON formatting.
@@RezaDorrani tnx for your reply, is there another way I can change the direction?
@@shlomiisraelov7757 Im not aware of a way to achieve this.
Great video. Does anyone know if I can add a hyperlink under a section title in the body, or must it be in the header/footer?
Must be in header or footer
Great Video.
The header is great but for some reason when I attempt to adapt it to my list, if does not work. You have a Status Column, min is called 'Request Status'. When I change this the =if([$Status]... To if([$Request Status] and change the statuses to my status values, it simply ignores them or returns an empty header. Am I missing something about this script?
Use column internal name
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
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.
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 😅
Great video thanks. Not on my clients tennant yet, do we get this on library doc forms too ?
Currently available only in first release and targeted release tenants. Yes, will work on Doc forms too.
Great content Reza..!! I have tried the same and it's very helpful. I have a question though , i have added a new column to the existing SP list but i cannot find the field for entry , also when i look at the Edit column i cannot see it , but i can view it in the grid view .. Any specific reason for that..
I will have to look at your list to know more about your issue. I will recommend you post your issue with screenshots on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani Thanks Reza for the information ..I was able to debug the issue
@@rohitkumar-dt5qt Great!
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.
Love your videos. Thank you.
Thanks for watching!
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 th-cam.com/video/aFzd5qwS4-c/w-d-xo.html
Is there a way to customize the form with JSON without it using the multi-column layout? For example, I want to have sections but just in a single column layout. Thank you.
Currently, the layout column style cannot be customized.
Thank you. Very well explained!
You are welcome!
Nice video. Just one query how to leverage this left popup default form in my homepage because I don't want my user to use this form from list database itself. Like we used to have in promoted link webparts previously where we can define the behavior of the infopath form like dialog box or open in a new tab or same window.
I don't believe there is an option like that.
I would recommend you check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@reza dorrani - Great video. My sharepoint doesn't have the icon to click on to configure layout. Any suggestions? I have edit form>>edit column and customize with power apps. No configure layout.
Only available in first and targeted release tenants. Will be rolling out to all tenants in near future.
Nevermind. MS puts it out there in their documentation list as if it is available but it hasn't been rolled out to everyone. What a pain. So your video is super great but a waste of time until you have the option available. Thanks for making it though. Thanks for nothing, Microsoft.
@@jasonparker4969 Hopefully, you get this feature soon and comeback to my video :)
Im working on another video with a more advanced option for JSON formatting as well.
@@RezaDorrani yes for sure. Your video is super helpful and easy to follow. I appreciate it. So frustrated with MS though. This is not the first time @microsoft has done this. Grrrr.
@@jasonparker4969 I understand. Feature will come soon.
Loved this, thank you so much
Most welcome!
Hi Raza, thank you for this amazing info,
I have a quick question, is there is any way I can mark the duplicated values in the same column?
Not with JSON formatting. You would probably need to use Power Apps for that.
@@RezaDorrani how can I use it for that? Let me tell you what I'm doing, maybe you will have a brilliant solution as usual 😂😂
I have an Ms form for the employees to submit some data, I collect this data in excel sheet. When an employee fill it in I verify the submitted info, if this employee fill it In for the 1st time I copy and past the info in a share point list, if the data submitted is not correct I send him an e-mail to correct it, if he submitted the form for the second time after changing the info submitted in the 1st time I verify it and add it in the share point list
So I use the excel to mark the duplicated values to know if the employee submitted the form before or no.
The share point list I add the verified info is linked with a power app, so I can proceed with some extra process using the power app, and usually if the employee submitted the info for the second time and I already added him previously in the sharepoint list, I only amend the changes he did using the power app linked with the sharepoint list
@@davidadel2999 Your process sounds right.
How to do it? For that I would have to try it out. I would recommend you check on forums at powerusers.microsoft.com in case someone has done something similar