Thank you for this, so awesome I joined paid subscriber instantly after seeing this video, your simple explanations and sharing all the materials makes not hesitate to join as paid subscriber.
Brilliant Overview - great we have this video as the Forms are something new. Please keep these video's coming as I"m sure a number of us will be designing forms shortly (once it appears in our Tenant !)
Hi Reza, I've tried so many different ways before to display the map to no avail. This is fantastic , first try and got the map. I'm very happy 🤣thank you for making it very easy for us, just copy/paste!!!!👍
Great thanks Reza! Power Platform is pretty great. Not the most intuitive however. This is the type of video msft should do. If it weren't for people like you many would be flailing around in the dark.
Hello Reza, this is excellent! Thank you. May I please ask, I see that you placed a Google map image in part of header, having that said, may I use a full image (banner) across the header itself? Or as a background? Thanks!
Thank you. Will add your topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
@@robertlenz1969 I did a demo of this solution to a client to show them the power of low code in M365 and they loved this demo. I normally demo my videos with clients or my colleagues in advance to get their feedback so I can improve the use case for my videos. I am so happy to see the response of all my videos.
@@RezaDorrani Even if there is no need for a travel approval it is a good example when you need approvals in your process and don't have the budget for pro development or an expensive third party app ;-)
This is great, thank you! I tried to recreate this but i can't have two "When a new item in created" flows. How did you have both Manager and HR approvals running at once?
Another great video , you are the best cook for Microsoft applications. I have put json to format header but map is not being reflected, do I need to change any settings from my end?
It is difficult to provide guidance here on chat without looking at how your key is setup. I would recommend you post your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Awesome video. Have utilised this at work with few amends. Question though, is it possible to have these colours based on the value of a calculated field? I’ve got policies checked and policies correct field for an audit, the calc field does a basic calculation correct / checked to give a % and if that is over x then shows correct, otherwise incorrect. I’d want these indicators in the header to colour based on the result. Can’t seem to get it working
Thanks Reza. As always very helpful. Hey, do you have a solution as well for PowerApps Sharepoint list custom forms where the OnStart() only executes once ? 😞 I would love a video for that and would guess many developers are having this same problem/issue. Where should we put crucial global initialization code?
Thanks Reza for sharing this solution! I would like to disable the workflow related fields (e.g. WF status, Approval date) so that they cannot be changed by the user in edit mode.
That is one of the limitation of the list formatting today. You need the column on the form to read its data. If you customize your form with Power Apps you will be able to disable the workflow related fields.
Brilliant video and I am sure many of us will be using it for our requirements very often. When will the "configure layout " option be available in the list for us?
Awesome Video Reza! I have a question: How to disable the 'requestor' who created the record from making changes to it after the approval started? Ideally, we need to make sure that no one is changing the information after the approval has started....
Great question. From flow, you can break permissions on the list item and grant requestor read access. I had to keep video below 25 mins. Hence avoided adding that part :)
Great demo. I think where many would struggle with something like that is that in the list if you can get to the data you can effectively approve your own travel :) still it is only a demo. I think Microsoft need to try to democratise the permissions of lists and versioning etc. I guess that is another reason to look at dataverse . It depends on the needs I guess.
Great point. Once the flow gets triggered, we can break permissions on the item and grant the creator just the read access. I was going to do that but wanted to keep the video simple and within 25 mins.
@@RezaDorrani That's a great idea. How would be restrict all creators to see the requests of every other person though? Maybe this is where powerapps would be needed?
@Reza Dorrani : can we render the elmType based on conditions ? I dont think so. If Microsoft allows this, then it will be great. Loved your demo !! Learnt a new way of formatting.
@@RezaDorrani : Thanks for your awesome videos. i was able to do few hide and show elements based on conditions (css- display none / flex). But complexity increases based on requirements. I agree with you. Hope more formatting options will be available in future.
Reza - thank you for this tutorial, really pleased I’ve found your content - have subscribed! Can you tell me if there is a way to format field width for individual fields? For example in the body formatting, can I make a multi line text field display across 3 columns? Many Thanks!
Thanks Ben. Currently the body section cannot be formatted. No column width span options either. Only option is to add sections. Hopefully more options open up in future.
@@RezaDorrani Thank you! Will keep an eye out for updates. One last question - if I configure a hyperlink at in the Footer formatting, is there a way to make the link open in a new tab? By default it opens using the same browser tab; if a user has gone through the process of filling out the entire form, they will lose all their information if they click the link! This could annoy users... Many thanks in advance
@@benadams109 Yes I believe you can. When creating anchor you can define the target attribute as new. Check documentation and PnP samples (links for both are in description of video)
I like the Header formatter a great deal - but I can' seem to find a way to remove the Approval Process JSON without impacting the entire header. I assume I simply cut certain section(s) of your JSON code sample?
The JSON has to be valid. Any incorrect syntax and the header won't render. Test your JSON's validity by pasting it here - jsononline.net/json-validator
Great demonstration, Approver comment and status can be made read only ? I suggest to disable quick edit feature so that users go through the form to edit. This kind of example would be better in dataverse for teams i think ? Thx rezza
Hi Reza, Great video as usual. Very informative. Thank you !! One question, is it possible to change the display text for the column when showing in the sections? For example, instead of "Requestor" can we show "For the Requestor"? OR can we show the description of the column? Please suggest.
@@RezaDorrani Thanks!! Yeah that option I am aware , it was mainly for a use case where you would like to keep the column name short but wants to provide big caption in the form. Anyways thanks for the response
As always excellent content! Reza! Where can we find other resources for writing JSON as shown in your header example? Also, is it possible to write the JSON dynamically from flow values? I am thinking of the very common parent/child list relationship scenarios and the possibilities that may exists. Thanks!
Video description has link to most of the resources. Also, I did a 101 video as well on this topic which has a lot of useful links in the description. Currently, JSON cannot be written dynamically. Hopefully more scenarios open up soon.
@@RezaDorrani Thank you! Hopefully the PnP Samples will have some SharePoint form examples soon. To bad we cannot support parent/child as that is a common request and we are limited with SharePoint forms to PowerApps or SPFX. I really appreciate the work you do to help get this content out to us all. Superb job!
Hi Reza, thank for the very informative video. Could you please tell me what MS certification cover Sharepoint learning and administration ? What I can study to become sharepoint expert?
MS Certifications for SharePoint- docs.microsoft.com/en-us/learn/certifications/browse/?terms=sharepoint No one will ever become an expert by giving certifications. Nothing beats hands-on experience (project experience).
I agree 💯- but seeing your videos I noticed how much more things can be done in Sharepoint- I been using sharepoint for 3 years - Didn’t know all of the list functions and features. Thank you very very much Reza. I have small IT business in NYC - we do cloud migration Azure and AWS - I will definitely contact you if you are interested for projects.
Great video! can't wait to try some of this out. i have a side question.. I notice my approvals are being send out by ME because i create the flow.. I noticed Approval actions is not assigned to me but +Approvals. How do i change the approvals to be sent from someone else (i.e a service account) I don't want approvals to have the developers name embedded.
Hi, thanks for the video - it's awesome. I have one follow-up question. Can you make a field visible to members of a group (based on permission groups on sharepoint)?
Hi, Reza, thanks for another great tutorial! I love your videos and you have taught me so much. I am struggling with one issue with this one, and I hope you can help: I am summing together the costs in the header as you are doing here, I have 5 different costs that are summed together in the header in my solution. It works fine when the person is creating a new application, however, when they open one that is already made, it only shows the two first numbers in the header and removes the zeroes. So, if the sum is 3500, it only returns 35. If the number is 3000 it returns 3. Do you have any idea what is causing this issue?
My guess is data is being output as text and it is truncating the last few characters. I know someone who is really great at list formatting. Check with twitter.com/techan_k
Hi Reza, I have been following this series of customization, its quit interesting. Our SharePoint is not updated yet with this feature, usually how long does it take for the feature to be updated for all tenants.?
Awesome. What if the manager requires more information before approval. Is there a way to put a 3rd button require more info instead of cancelling the request and having to resubmit
Great tutorial as always. There is one thing I have not seen in any approval tutorial and it is a slight variant of this. I want to create a multi layer approval using sharepoint like this but I want the requester to select who that approver is. It is not always the persons manager depending on what it is for. The same thing goes for the second and third layer of the approval. There are so many ways the approval might need to go that I cannot create a flow to have it go to the same person, like a specific manager, each time a form is created. Any help would be appreciated.
For that you would have to use a selected item trigger so the users can start the flow and define the approvers. I also have a full playlist on approvals. Do check it out - ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hi Reza, In one of your video you showed how to have mandatory validation in case of conditional column validation. But that is not working for multi select dropdown in SharePoint list, do you know any way to do that ?
In my tutorial I did not showcase multi select dropdown for validation. It may not be working because the formula you have put in place may not be right. I do not have a video reference of multi select validation. I will recommend posting your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi Reza, thanks for the sharing, just a bit confused on the approval flow. As the flow is only triggered upon the list item is created, which happened once only. If the item is approved, that’s fine. What if the item is rejected? So the flow will update the item and exit. However, the approval process is not ended yet. Usually the requester will revise the item, it shall trigger another around of approval process. But I don’t see there is a logic to handle that again. Maybe I overlook something important, can you elaborate a bit more? Thanks.
Hi Wayne, This video was just to illustrate what is possible with SharePoint + JSON + flow approvals. If you want approvals to trigger when item is added or updated, then you would need to change the trigger and handle your approval scenario. Here is my approvals playlist link - ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hi Reza, thanks for your quick response. I try to create a flow triggered on List item Create or Edit, encounter a dead loop here. After approval/Reject received, we need to Update the status/comments fields of the List item, which again trigger the same flow recessively, need your advice on how to overcome such issue gracefully Just noticed that if we turn on the versioning of this list, the sharepoint will auto generate 2 additional fields “Apprival Status” & “Approver Comments”, but I couldn’t use them in the list form layout JSON. So far I have tried: 1. [$Approval Status] 2. [$Approval_x0020_Status] None of above is recognized in Layout JSON, do you have any idea on how to use these 2 columns?
@@RezaDorrani I See, actually my question comes from MS lists. If you use MS Lists instead of sharepoint, you have no possibility to search the list based on keywords. I suppose Microsoft will soon extend the MS lists fonctionality...
@@RezaDorrani Yes the global Search on the sp site works fine for finding results in the list. But if you only use the list app, you cannot search on keywords.. maybe in a future update for lists it will be possible
Hello again Reza, I figure if anyone would know, you would. How do you format values using a "contains" in list formatting. Is it possible, I have seen an article by CKent but when I try to enter it , "It says that it is not valid". Is there a way to check if the filed contains a word, it does hide it? Thank you.
Hi, thank you for your very helpful videos! I have a question with regards to conditional formatting of a specific column on the form. I would like it to be only visible to list owners. I've tried playing around with different if statements but I don't know how to refer to owners. Something like =if(@me==owners, 'true', 'false'). I've tried making a user column hidden to everyone that populates from power automate and using =if([$User.email]==@me, 'false', 'true') but the column formatting keeps disappearing and I would prefer to hard code it to the owners rather than be dependent on the user in case the item is shared to their colleagues. At the moment the user has edit access while the submission is 'open' then when it is is closed permissions are wiped then replaced with read only access. They need to have edit access while it is open so that we can use the comments section to communicate with them in a way that is visible to all list owners.
Hi Reza, thanks for your video. it is very useful for me. I have a little problem on the bing map on my header. i copy and paste the bingmap key in my header but the map did not display out. i went to the given website and create bing map key, they ask on Key type. I created key type dev/test. I copy paste into my header in MS list Json column , preview it, the map still did not display out. Can you help me ? what have gone wrong ?
Its been a long while since I did this video. But based on last recollection, bing maps was still working. I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Is there a way that an email can be sent to approvers to approve multiple line items on a list instead of sending separate emails for each line item? I am looking to develop a approval flow for multiple terms in an RFP or Contract. Approvers might be required to approve 10+ line items in 1 RFP or Contract.
Possible. You would have to create a mechanism through which users can select multiple line items (Power Apps) and then run 1 approval process on them.
Reza, do you know if there is a problem with viewing this header? I can no longer view it the way you taught in the video, when I try to save, it returns to the default list view.
I dont think so. Still works fine for me. I would recommend posting your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi Reza, it seems if the approval status column is a calculated column type, the status don't work. No prob with a choice column...but need to use calculated column because i Don't wan't my users can change the value of it. Do you try with a calulated column ?
I have not tried with a calculated column. Approval Status is a System column that comes alive when Content Approval is setup. Flow has actions to update Approval Status column as shown in video.
@@RezaDorrani Yes, but in this scenario a user can modify the status. It's a bit more complicated with calculated value. I add this formula to the calculated column if([status]="Pending","Pending") because when i pick the source code from Edge i read "Status, Pending, Read Only" instead of "Pending". Now it's okay but i think i need to change a little thing in the JSON code to make it work
Do u know how to increase field width size of SharePoint list? I’m using tiles as view where I got column (rich text) which the width is not adjustable, so when I paste a table in it, it looks horrible. Thanks
This is amazing. Does anyone know how we can implement this solution with *multiple approvers*, and have the Approval Status change according to the collection of Responses?
Hey Reza, may I ask how you were able to display the person column profile picture in the View area? ( Body Config ). Person column profile shows on the list but it doesn't show on the view page.. Thank you.
Body JSON cannot be formatted. The list view shows the profile image since it's a feature of the column. If you head over to column settings in modern view, it will have an option to show profile feature.
@@noNumber2Sherlock Its a simple column setting. You might have missed something. I will recommend posting your issue on forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Do you know if there is a way to add the Created by of the request to the form? It's useful to see this when editing the form or sending a comment to the Creator. Then I don't have to close the form to go look at the Created by column.
I don't believe system columns are supported on the form. I would also recommend to check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani Thanks for the reply the forums have been a great help. Here is the answer: techcommunity.microsoft.com/t5/sharepoint/add-created-by-column-to-list-form/m-p/2634285?emcs_t=S2h8ZW1haWx8c29sdXRpb25fdG9fcXVlc3Rpb258S1M3N0VEVDBVMURSQkd8MjYzNTAyNnxBQ0NFUFRFRF9TT0xVVElPTlN8aEs
@@RezaDorrani super. able to configure the logo pal. Thanks a lot. Here is link to my github if anyone interested. github.com/vayin/ListFormatting/blob/main/Header_StaticBackGround_YourCompanyLogo.txt
How can I hide a field in sharepoint based on a person column like whenever a person column in equal to login user the field shoud visible otherwise hide
My top tipp for a better handling of JSON in Sharepoint Lists, Use SP Formatter (Browser Extension) and opt. SP Formatter for VSCode. Improves the editing of JSON files by miles. github.com/pnp/sp-formatter
![YoungBoy Never Broke Again - Sneaking [Official Video]](http://i.ytimg.com/vi/1ILUps2zDFU/mqdefault.jpg)
SharePoint and Lists are starting to come into their own. Amazing example of the power of the modern power platform Reza!
Thank You Joseph. Just finished recording my next video in the series. Video will be live next week.
Thank you for this, so awesome
I joined paid subscriber instantly after seeing this video, your simple explanations and sharing all the materials makes not hesitate to join as paid subscriber.
Thanks sor the sub and membership Wira!
Welcome to the channel.
Brilliant Overview - great we have this video as the Forms are something new. Please keep these video's coming as I"m sure a number of us will be designing forms shortly (once it appears in our Tenant !)
Thank you Mark. If I keep getting such positive responses, I will keep building them.
Reza, you are getting all best ingredients and getting out a fresh pizza from a pan. !!! you are the best cook in power platform..!!!
Thank you so much 😀
Another gem of knowledge, Reza! Thank you again for sharing your knowledge and time with us! The links above are priceless!
Thank you 🙏
Hi Reza, I've tried so many different ways before to display the map to no avail. This is fantastic , first try and got the map. I'm very happy 🤣thank you for making it very easy for us, just copy/paste!!!!👍
Great to hear! Thank You so much for the feedback.
@@RezaDorrani do you know of any Microsoft plans to support this on the mobile app?
@@olgamelo4416 I am not aware of the timeline. Hope mobile support for this amazing feature comes soon.
Great thanks Reza! Power Platform is pretty great. Not the most intuitive however.
This is the type of video msft should do. If it weren't for people like you many would be flailing around in the dark.
Wow! Thank you for the compliments. Appreciate all the feedback.
@@RezaDorrani Haha, you're welcome. Give credit where credit is due. But, just wait till you get the bill. 😁
@@carlw lol
Form layout customization is awesome improvement.. Thanks for letting us know
My pleasure
Hello Reza, this is excellent! Thank you. May I please ask, I see that you placed a Google map image in part of header, having that said, may I use a full image (banner) across the header itself? Or as a background? Thanks!
You could add any image of your choice in header. Its JSON code. You can change the href of the anchor tag to your image.
Nice Video and good 23 min of learning. One request can you create a video on "how to utilize SharePoint with external users".
Thanks!
Thank you.
Will add your topic suggestion to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Congratulations on the content. I speak here from Brazil
Thanks so much
Great overview about the new features. It is always a pleasure to watch your videos and getting inspiration :-)
Thank you Robert
@@RezaDorrani I will try to rebuild this in our environment - also a good example to show the power of low code development!
@@robertlenz1969 I did a demo of this solution to a client to show them the power of low code in M365 and they loved this demo. I normally demo my videos with clients or my colleagues in advance to get their feedback so I can improve the use case for my videos. I am so happy to see the response of all my videos.
@@RezaDorrani Even if there is no need for a travel approval it is a good example when you need approvals in your process and don't have the budget for pro development or an expensive third party app ;-)
Awesome, thanks for this great video. Q: Is it possibel to build with this formatting columns function a cascading dropdown?
Currently No.
This awesome Reza! Thank you so much.. for such great tutorial and access to coding samples! Tremendous help!
You're very welcome!
Awesome tutorial. You really do an outstanding job making it accessible to any level of user.
Thank you Kevin
This is great, thank you! I tried to recreate this but i can't have two "When a new item in created" flows. How did you have both Manager and HR approvals running at once?
Video description has links to download sample flow.
Nice video and great information, Thank you!!! Is there a way to add overlay/color code into this calendar?
Overlay color code option is currently not available.
Another great video , you are the best cook for Microsoft applications. I have put json to format header but map is not being reflected, do I need to change any settings from my end?
Thanks for the compliments.
Map not reflecting. Check if your bing maps key is accurate.
@@RezaDorrani Sorry but How do I check that my bing maps key are accurate?
@@Dany-ns6hg Video description has link on how to setup a bing maps key. On the bing maps portal you can see if your key is active.
It is difficult to provide guidance here on chat without looking at how your key is setup. I would recommend you post your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani Sorry for troubling you, I created a key and now I am able to see map. Thank you so much for your time and patience around this.
Great video Reza, Is there a way to add cascading fields using JSON formatting without customizing the form using PowerApps?
Currently adding cascading with JSON is not possible. JSON only allows us to add formatting.
Hey, as always great video , and thank you for taking time to put chapters really helps
Most welcome
Awesome video. Have utilised this at work with few amends.
Question though, is it possible to have these colours based on the value of a calculated field?
I’ve got policies checked and policies correct field for an audit, the calc field does a basic calculation correct / checked to give a % and if that is over x then shows correct, otherwise incorrect.
I’d want these indicators in the header to colour based on the result. Can’t seem to get it working
I don’t remember json supporting calculated columns
Noooo - maybe I’ll have to revert to a drop list box instead.
Let’s hope those that are going to use it can do math 😂😂
Hi Reza, excellent explanation as always.
Thanks
What an amazing tutorial! Is it possible in the bing image put a travel path (from Point A to Point B)?
Thanks.
I believe there is an API in bing maps where it can send path image between 2 points.
Excellent video as always, thanks for sharing.
Thank you for watching as always :)
Thanks Reza. As always very helpful. Hey, do you have a solution as well for PowerApps Sharepoint list custom forms where the OnStart() only executes once ? 😞 I would love a video for that and would guess many developers are having this same problem/issue. Where should we put crucial global initialization code?
Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
Thanks Reza for sharing this solution! I would like to disable the workflow related fields (e.g. WF status, Approval date) so that they cannot be changed by the user in edit mode.
That is one of the limitation of the list formatting today. You need the column on the form to read its data. If you customize your form with Power Apps you will be able to disable the workflow related fields.
Brilliant video and I am sure many of us will be using it for our requirements very often. When will the "configure layout " option be available in the list for us?
Its rolled out to all targeted release customers. I don’t think there is a GA date yet.
Thanks Reza... for your Spoon-feeding video
Any time!
Awesome Video Reza!
I have a question: How to disable the 'requestor' who created the record from making changes to it after the approval started?
Ideally, we need to make sure that no one is changing the information after the approval has started....
Great question. From flow, you can break permissions on the list item and grant requestor read access. I had to keep video below 25 mins. Hence avoided adding that part :)
@@RezaDorrani Excellent !! Thanks for replying :)
Very useful Reza, Thumbs up!!!
Thanks for liking
Great demo. I think where many would struggle with something like that is that in the list if you can get to the data you can effectively approve your own travel :) still it is only a demo. I think Microsoft need to try to democratise the permissions of lists and versioning etc.
I guess that is another reason to look at dataverse . It depends on the needs I guess.
Great point. Once the flow gets triggered, we can break permissions on the item and grant the creator just the read access. I was going to do that but wanted to keep the video simple and within 25 mins.
@@RezaDorrani That's a great idea. How would be restrict all creators to see the requests of every other person though? Maybe this is where powerapps would be needed?
@@yannis18 Item level permissions via flow would do the trick. Power Apps can show hide fields but that is not true security.
@Reza Dorrani : can we render the elmType based on conditions ? I dont think so. If Microsoft allows this, then it will be great. Loved your demo !! Learnt a new way of formatting.
Hopefully we have a lot more good formatting options coming.
@@RezaDorrani : Thanks for your awesome videos. i was able to do few hide and show elements based on conditions (css- display none / flex). But complexity increases based on requirements. I agree with you. Hope more formatting options will be available in future.
Reza - thank you for this tutorial, really pleased I’ve found your content - have subscribed!
Can you tell me if there is a way to format field width for individual fields? For example in the body formatting, can I make a multi line text field display across 3 columns?
Many Thanks!
Thanks Ben.
Currently the body section cannot be formatted. No column width span options either. Only option is to add sections. Hopefully more options open up in future.
@@RezaDorrani Thank you! Will keep an eye out for updates.
One last question - if I configure a hyperlink at in the Footer formatting, is there a way to make the link open in a new tab? By default it opens using the same browser tab; if a user has gone through the process of filling out the entire form, they will lose all their information if they click the link! This could annoy users...
Many thanks in advance
@@benadams109 Yes I believe you can. When creating anchor you can define the target attribute as new. Check documentation and PnP samples (links for both are in description of video)
I like the Header formatter a great deal - but I can' seem to find a way to remove the Approval Process JSON without impacting the entire header. I assume I simply cut certain section(s) of your JSON code sample?
The JSON has to be valid. Any incorrect syntax and the header won't render.
Test your JSON's validity by pasting it here - jsononline.net/json-validator
Great demonstration,
Approver comment and status can be made read only ?
I suggest to disable quick edit feature so that users go through the form to edit.
This kind of example would be better in dataverse for teams i think ?
Thx rezza
Another approach would be to break item permissions and make it read only for creator using flow.
Hi Reza, Great video as usual. Very informative. Thank you !! One question, is it possible to change the display text for the column when showing in the sections? For example, instead of "Requestor" can we show "For the Requestor"? OR can we show the description of the column? Please suggest.
Column names in the body cannot be changed. You can rename the columns in SharePoint list/library and that would reflect in the form.
@@RezaDorrani Thanks!! Yeah that option I am aware , it was mainly for a use case where you would like to keep the column name short but wants to provide big caption in the form. Anyways thanks for the response
Simply exzellent! Keep Up this great work
Thank You
Excellent one.... Thank you....
Thanks for watching
Your Videos are very helpful - thank you Q: Can you place multiple links on Footers? All sample I see show only 1
Yes! You can add multiple anchor tags in the JSON body.
Something like:
"children": [
{
"elmType": "a",
"txtContent": "link1",
"attributes": {
"target": "_blank",
"href": "='url1",
"class": "ms-fontColor-themePrimary ms-borderColor-themePrimary ms-fontWeight-semibold ms-fontSize-m ms-fontColor-neutralSecondary-hover ms-bgColor-themeLight-hover"
}
},
{
"elmType": "a",
"txtContent": "link2",
"attributes": {
"target": "_blank",
"href": "url2",
"class": "ms-fontColor-themePrimary ms-borderColor-themePrimary ms-fontWeight-semibold ms-fontSize-m ms-fontColor-neutralSecondary-hover ms-bgColor-themeLight-hover"
}
}
]
this is gold. thanks for sharing
Glad you enjoyed it!
As always excellent content! Reza! Where can we find other resources for writing JSON as shown in your header example? Also, is it possible to write the JSON dynamically from flow values? I am thinking of the very common parent/child list relationship scenarios and the possibilities that may exists. Thanks!
Video description has link to most of the resources. Also, I did a 101 video as well on this topic which has a lot of useful links in the description.
Currently, JSON cannot be written dynamically. Hopefully more scenarios open up soon.
@@RezaDorrani Thank you! Hopefully the PnP Samples will have some SharePoint form examples soon. To bad we cannot support parent/child as that is a common request and we are limited with SharePoint forms to PowerApps or SPFX. I really appreciate the work you do to help get this content out to us all. Superb job!
@@TheStoibz Thank You
Hi Reza, thank for the very informative video. Could you please tell me what MS certification cover Sharepoint learning and administration ? What I can study to become sharepoint expert?
MS Certifications for SharePoint- docs.microsoft.com/en-us/learn/certifications/browse/?terms=sharepoint
No one will ever become an expert by giving certifications. Nothing beats hands-on experience (project experience).
I agree 💯- but seeing your videos I noticed how much more things can be done in Sharepoint- I been using sharepoint for 3 years - Didn’t know all of the list functions and features. Thank you very very much Reza.
I have small IT business in NYC - we do cloud migration Azure and AWS - I will definitely contact you if you are interested for projects.
@@alexmart2019 Thank you for following and liking the videos.
You can always contact me on reza.dorrani@outlook.com
you are awesome, thank you for sharing
Thanks Wira
Great video! can't wait to try some of this out.
i have a side question.. I notice my approvals are being send out by ME because i create the flow.. I noticed Approval actions is not assigned to me but +Approvals.
How do i change the approvals to be sent from someone else (i.e a service account)
I don't want approvals to have the developers name embedded.
You would have to build the approval flow from your service account.
Hi, thanks for the video - it's awesome. I have one follow-up question. Can you make a field visible to members of a group (based on permission groups on sharepoint)?
SharePoint does not support column level security
Hi, Reza, thanks for another great tutorial! I love your videos and you have taught me so much.
I am struggling with one issue with this one, and I hope you can help: I am summing together the costs in the header as you are doing here, I have 5 different costs that are summed together in the header in my solution. It works fine when the person is creating a new application, however, when they open one that is already made, it only shows the two first numbers in the header and removes the zeroes. So, if the sum is 3500, it only returns 35. If the number is 3000 it returns 3. Do you have any idea what is causing this issue?
My guess is data is being output as text and it is truncating the last few characters. I know someone who is really great at list formatting. Check with twitter.com/techan_k
Thanks for sharing, Insightful!
Thanks for watching
Want to be want to be like Reza! Air Reza #23 MVP for the win! Great video once again! :)
Thank You. Made my day :)
Great Video as always thanks Reza
Thanks Sundra
Hi Reza,
I have been following this series of customization, its quit interesting. Our SharePoint is not updated yet with this feature, usually how long does it take for the feature to be updated for all tenants.?
Currently it is rolled out to targeted tenants only (100%). Based on my knowledge, no official date is out for the GA release.
@@RezaDorrani Thank Reza
@@RezaDorrani Got surprise this morning , the functionality is now working
@@robinjamesnjarlely Enjoy. I just finished building another scenario that I plan to share soon.
@@RezaDorrani Awesome
Awesome. What if the manager requires more information before approval. Is there a way to put a 3rd button require more info instead of cancelling the request and having to resubmit
Possible. Approvals can have custom response options.
@@RezaDorrani sure, is there a tutorial for it pls
@@jaggyjut I do not have a reference for it.
Great tutorial as always. There is one thing I have not seen in any approval tutorial and it is a slight variant of this. I want to create a multi layer approval using sharepoint like this but I want the requester to select who that approver is. It is not always the persons manager depending on what it is for. The same thing goes for the second and third layer of the approval. There are so many ways the approval might need to go that I cannot create a flow to have it go to the same person, like a specific manager, each time a form is created. Any help would be appreciated.
For that you would have to use a selected item trigger so the users can start the flow and define the approvers.
I also have a full playlist on approvals. Do check it out - ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hi Reza. Thank you so much for this. However, the map image on the header of my list item is not showing. What should I do?
You need to enter the key for bing maps in json
Hi Reza, In one of your video you showed how to have mandatory validation in case of conditional column validation. But that is not working for multi select dropdown in SharePoint list, do you know any way to do that ?
In my tutorial I did not showcase multi select dropdown for validation. It may not be working because the formula you have put in place may not be right. I do not have a video reference of multi select validation. I will recommend posting your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi Reza, thanks for the sharing, just a bit confused on the approval flow. As the flow is only triggered upon the list item is created, which happened once only.
If the item is approved, that’s fine. What if the item is rejected? So the flow will update the item and exit.
However, the approval process is not ended yet. Usually the requester will revise the item, it shall trigger another around of approval process. But I don’t see there is a logic to handle that again.
Maybe I overlook something important, can you elaborate a bit more? Thanks.
Hi Wayne,
This video was just to illustrate what is possible with SharePoint + JSON + flow approvals.
If you want approvals to trigger when item is added or updated, then you would need to change the trigger and handle your approval scenario.
Here is my approvals playlist link - ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hi Reza, thanks for your quick response. I try to create a flow triggered on List item Create or Edit, encounter a dead loop here. After approval/Reject received, we need to Update the status/comments fields of the List item, which again trigger the same flow recessively, need your advice on how to overcome such issue gracefully
Just noticed that if we turn on the versioning of this list, the sharepoint will auto generate 2 additional fields “Apprival Status” & “Approver Comments”, but I couldn’t use them in the list form layout JSON.
So far I have tried:
1. [$Approval Status]
2. [$Approval_x0020_Status]
None of above is recognized in Layout JSON, do you have any idea on how to use these 2 columns?
@@waynejin4873 Check my flow approval playlist. It has steps to avoid infinite loop.
Very nice video! Could you have a solution to have an easy way to search for an item within a ms list? a search box or something?
Kind regards
The form formatting options is just to format the current item. No searching options available. To search for items, use the filter option in views.
@@RezaDorrani I See, actually my question comes from MS lists. If you use MS Lists instead of sharepoint, you have no possibility to search the list based on keywords. I suppose Microsoft will soon extend the MS lists fonctionality...
@@stevedaregmailcom I believe it is in the global search in the Office 365 Menu bar on the top.
@@RezaDorrani Yes the global Search on the sp site works fine for finding results in the list.
But if you only use the list app, you cannot search on keywords..
maybe in a future update for lists it will be possible
@@stevedaregmailcom Hopefully that gets added soon
Thanks Reza
Most welcome
Hello again Reza, I figure if anyone would know, you would. How do you format values using a "contains" in list formatting. Is it possible, I have seen an article by CKent but when I try to enter it , "It says that it is not valid". Is there a way to check if the filed contains a word, it does hide it? Thank you.
Hey, I would recommend to follow and check this with Techan twitter.com/techan_k?s=21
He is on top of the list formatting feature.
@@RezaDorrani You are SO awesome Reza. Thank you! I wish you all the good karma you deserve!
@@noNumber2Sherlock Thanks
Great video... Is it possible to disable one field in form using json?
Currently, disabling fields are not supported.
Hi, thank you for your very helpful videos! I have a question with regards to conditional formatting of a specific column on the form. I would like it to be only visible to list owners. I've tried playing around with different if statements but I don't know how to refer to owners. Something like =if(@me==owners, 'true', 'false'). I've tried making a user column hidden to everyone that populates from power automate and using =if([$User.email]==@me, 'false', 'true') but the column formatting keeps disappearing and I would prefer to hard code it to the owners rather than be dependent on the user in case the item is shared to their colleagues. At the moment the user has edit access while the submission is 'open' then when it is is closed permissions are wiped then replaced with read only access. They need to have edit access while it is open so that we can use the comments section to communicate with them in a way that is visible to all list owners.
I don’t think you can do conditioning formatting based on user permissions
Hi Reza, can both the Approval Status and Approval Comments be set to read only?
You could hide them from the form. But no option to force read only.
Wow. Just wow.
Can i use a default image stored in my SharePoint instead the location image ? or is it possible to specify a default location ?
Or based on the people field…
ok works with image. I paste in on my SharePoint Library and copy the direct link of the image. Working...
Thanks
You could use the html image attribute and point to an image stored elsewhere.
Hi Reza, thanks for your video. it is very useful for me. I have a little problem on the bing map on my header. i copy and paste the bingmap key in my header but the map did not display out. i went to the given website and create bing map key, they ask on Key type. I created key type dev/test. I copy paste into my header in MS list Json column , preview it, the map still did not display out. Can you help me ? what have gone wrong ?
Its been a long while since I did this video. But based on last recollection, bing maps was still working.
I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Is there a way that an email can be sent to approvers to approve multiple line items on a list instead of sending separate emails for each line item? I am looking to develop a approval flow for multiple terms in an RFP or Contract. Approvers might be required to approve 10+ line items in 1 RFP or Contract.
Possible. You would have to create a mechanism through which users can select multiple line items (Power Apps) and then run 1 approval process on them.
Very nice. When will this feature become available?
Currently rolled out to all targeted release tenants. GA date not yet announced.
Reza, do you know if there is a problem with viewing this header? I can no longer view it the way you taught in the video, when I try to save, it returns to the default list view.
I dont think so. Still works fine for me. I would recommend posting your issue on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
Hi Reza, it seems if the approval status column is a calculated column type, the status don't work. No prob with a choice column...but need to use calculated column because i Don't wan't my users can change the value of it. Do you try with a calulated column ?
I have not tried with a calculated column.
Approval Status is a System column that comes alive when Content Approval is setup.
Flow has actions to update Approval Status column as shown in video.
@@RezaDorrani Yes, but in this scenario a user can modify the status.
It's a bit more complicated with calculated value. I add this formula to the calculated column if([status]="Pending","Pending") because when i pick the source code from Edge i read "Status, Pending, Read Only" instead of "Pending". Now it's okay but i think i need to change a little thing in the JSON code to make it work
@@anthonyleduc May be :) Im not sure.
@@RezaDorrani I gave up. I deleted the approvals step from the header. I'm not the talented Mr Rezza ;-)
@@anthonyleduc :)
Do u know how to increase field width size of SharePoint list?
I’m using tiles as view where I got column (rich text) which the width is not adjustable, so when I paste a table in it, it looks horrible. Thanks
I don't believe field width size is supported in SharePoint list form Json based customizations.
How to apply Textcolor for the list column description in newitem/Edititem JSON? kindly provide your suggestion
That is not a supported feature with JSON
Thanks Reza for the video! is it possible to use person column on the header ? I try [$ColumnName.title] or [$ColumnName.email] without success.
The person type column values have known issues.
This is amazing. Does anyone know how we can implement this solution with *multiple approvers*, and have the Approval Status change according to the collection of Responses?
Check my playlist on flow approvals
ruclips.net/p/PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe
Hey Reza, may I ask how you were able to display the person column profile picture in the View area? ( Body Config ). Person column profile shows on the list but it doesn't show on the view page.. Thank you.
Body JSON cannot be formatted. The list view shows the profile image since it's a feature of the column. If you head over to column settings in modern view, it will have an option to show profile feature.
@@RezaDorrani Thank you Reza. I have it set as such but it doesn't show in list view. Thought there may be something I missed.
@@noNumber2Sherlock Its a simple column setting. You might have missed something.
I will recommend posting your issue on forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani Thank you Reza. I think I will it happens on both at work's tenant and my own. As always , very grateful for you taking the time.
@@noNumber2Sherlock Hopefully the forums will provide an answer. Check with twitter.com/techan_k as well.
Do you know if there is a way to add the Created by of the request to the form? It's useful to see this when editing the form or sending a comment to the Creator. Then I don't have to close the form to go look at the Created by column.
I don't believe system columns are supported on the form. I would also recommend to check on the forums at techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
@@RezaDorrani Thanks for the reply the forums have been a great help. Here is the answer:
techcommunity.microsoft.com/t5/sharepoint/add-created-by-column-to-list-form/m-p/2634285?emcs_t=S2h8ZW1haWx8c29sdXRpb25fdG9fcXVlc3Rpb258S1M3N0VEVDBVMURSQkd8MjYzNTAyNnxBQ0NFUFRFRF9TT0xVVElPTlN8aEs
Can i also use a formula to just hide a field in the Form view? without a condition?
You can hide fields if they are part of a content type.
Good morning Reza!
Morning
can this be applied to the document library as well?
Yes. Working on a video on it :)
Reza, we have a requirement to have the company logo in header. Is it possible to that?
Yes. You can add an img in the header with your comany logo.
@@RezaDorrani perfect. Any direction you could provide ?
@@vinayayinapurapu check the documentation link in video description. All you need to add is elem img and src link to your company logo.
@@RezaDorrani super. able to configure the logo pal. Thanks a lot. Here is link to my github if anyone interested. github.com/vayin/ListFormatting/blob/main/Header_StaticBackGround_YourCompanyLogo.txt
Well done and thanks for sharing.
What if the HR manager wants to update their approval from “reject” to “approve”? How would someone do this?
You would need to allow them to get back to SharePoint list and restart the approval process.
Is there a tutorial to get the static image of Bing or G. Maps?
ruclips.net/video/bUO9QxKhe6U/видео.html&feature=emb_logo
Is there a way to join two lists and show data without SPD
You will need to use flow for that.
I do not have a video on this use case.
I will recommend you check on the forums at powerusers.microsoft.com
Hi Reza, i am using the same formula but i am getting the error. Invalid condition formula
Ensure that you are using the internal names of the columns.
Yes!
Hope you liked the video
How can I hide a field in sharepoint based on a person column like whenever a person column in equal to login user the field shoud visible otherwise hide
Check my playlist on list formatting. One of the videos has the exact same scenario covered - ruclips.net/p/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
My top tipp for a better handling of JSON in Sharepoint Lists, Use SP Formatter (Browser Extension) and opt. SP Formatter for VSCode. Improves the editing of JSON files by miles.
github.com/pnp/sp-formatter
Thanks for the reference to the SP Formatter Browser extension. Nice tip!!!
=if([$Session type] ==" ", 'false', 'true') the condtional formatting didn't worked for me
Not possible to evaluate here on chat. Please post issue on forums.
Where is the JSON code?
Video description has all the links
is it possible to have a text input and dropdown for each column?
A column can have 1 type. Either a text type or choice type.