Hi Reza I need formula that will pick the colosest date(to today) from 5 sharepoint list date columns for each row. Some of the date columns can be blank . Is this achievable either in formal or json ?
@@10xApe Not sure as I have not tried this scenario. I will recommend posting your query on sharepoint forums in case someone has done something similar
This is exactly what I worked on a lot before learning Power Apps :) Near the end of the video, when you covered linking an approval directly to the form experience and embedding the list on a page, is great to improve the usability! I know it's just clicking the NEW button and then clicking the SAVE button... but for non-technical users, I've noticed they may be a bit overwhelmed at first by the SharePoint List UI. Great video showing how this is all possible within SharePoint! Thank you, Reza!
Very well done. I shared with others at work as we are all migrating to SharePoint online and having to edit and recreate different aspects. Your video was very thorough and easy to follow.
I agree he made it more simpler than ever, now i want to learn to do this way always, but i cant find the icon where he customize the form...i only see preview and send 😭😭😭😭😭😭😭
Hello Reza, thanks a lot ! Based on your training vidéo, I've not created for workflow with "Start and wait for an approval" but "create an approval" and then "wait for approval" and then I've udapted my sharepoint list with the dynamic link to the approval it self, so when the approver receive the workflow notification in Outlook or teams , he has to click on the link to the item in order to see all the informations of the request with json customize forms in sharepoint and just have to click on the link of the workflow in order to approve or reject it. It's very useful when the approval is done during a dedicated meeting : approvers just have to filter on pending request (or create a dedicated view) and open it one by one in order to take a decision ! Then the power automate flow is finishing in order to send an email of décision to the requestor and update items. So one again Thanks a lot for all your amazing trainings
Thanks so much. As always with your presentations - unbelievable how much valuable information you are delivering in a given timeframe. Regarding this video, I‘d like to know how to include a Cascading dropdown directly in the SharePoint-list experience. Thanks in advance for your feedback and looking forward to learning from your vast experience.
Thank You so much! Cascading dropdowns is not an option with JSON formatting. You would need to leverage Power Apps for that. I have done 2 videos on cascading dropdowns. I will recommend checking those.
Amazing!! Power apps can be slow to load, so I love that we can do so much with just a list. (Not that I don't love Power apps, I really do... but I wish they were faster.)
Thank you for all what you do for us, it is really a real pleasure watching your videos. I get the same excitement watching a non technical video for entertainment. 👍👍👍👍
How do you do it? So much useful info packed in just 20 minutes yet it doesn't feel rushed or overcomplicated. Everything I needed to know to get started. Thank you so much!
This is wonderful - so detailed, clearly explained and really helped me understand the power of lists and their associated forms - very grateful - thank you.
Yes, I used the person column and I am figuring out to write a syntax for 2 specific users can see the columns and others cannot, I used OR function but in a wrong way. I need some help from you on this Reza. Also, can provide access using job title? I thank you from bottom of my heart for providing such good content to every individual.Thanks again in taking time and replying to my questions.
hi, sorry but, if ur condition in 5:40 is a value that is not already written (in column 'Approver'), any approval column (with the condition...) won't to show in form... Or I did I mess a step...
HI Reze! Great video, thanks so much! Quick question - I had a date field in the Form passing into List, but when the date is empty, error occurs showing "OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DatetocompleteIU' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'." Do you happen to have a shortcut for a fix? Thanks!
Thanks a lot for your video, I had never created an MS list, but now I was able to create one and customize it too. Was ablout to close the video when you mentioned JSON coding, but then realized it was too easy. If you see my comment; I have one question - I created a form which questions. Have chosen the choice column and added the following in the drop down menu (Not Applicable, 1, 2, 3 and 4), I wanted to know if I could calculate the average fs a text is present..Hoping you see this one soon.
Glad it helped! Json formatting can only format data. It cannot calculate avg across all the items. Look into column totals feature in SharePoint. Check documentation for that.
Jean não sei se você sabe, mas tem como ativar as legendas automáticas em português, primeiro vai na engrenagem e ativa a legenda em inglês, fecha a engrenagem, depois volta na engrenagem clica em legenda novamente e clica em traduzir automaticamente e seleciona o português. Isso me ajuda muito a entender o conteúdo.
Hi! Thank you for the video! 😁 I have a question. I created one customized app and if I go to the list itself and open an item and edit it, it saves successfully; however in my main page of the site I added a section with web content-list. If I open an item from there and try to edit it , it does not work. Do you know what could be the reason?
Solid tutorial as always! Is it possible to make the displayname within the Body Format conditional? For example, all fields within a section are conditional, but if that condition is not met, currently only the displayname appears, which is not the most visually appealing format. I would like the displayname to only appear when the same field conditions are met.
Thank you so much for this info. I already knew how to make sections, But I do have a goal of adding "Action" buttons to the header that would trigger power automate flows. Is this possible?
Thank you Reza for capacity building, this content has extremely enhanced my skills to do some projects. Would you mind sharing the sample JSON formatting for the header that shows the approval status?
Most welcome! I have a playlist on my channel related to json formatting. I have videos in there where header formatting json was shown and the video descriptions of those include the link to the code.
Hi Reza, great video as always. I was wondering if there is a way to see in the Header the Title value for each item if I select multiple items? Thank you
Hello Reza, thanks for the video, so useful, the only thing is , I want using power app (customize form) to create cascading drop down menu, but I want my rows remain editable by clicking on them. can you please advise?
Most welcome! I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Great video Reza! Thanks so much for your assistance! Is there a way to increase or set the field width and height within a form section? I need a full-width field (text type) within a full-width section.
I learned so much. Thank you. Where can I get the header formatting code for the formatting based on Approval Status? I am just learning and can't seem to figure out how you did that. You are a really good teacher!
thank you so much for the videos, learning a lot from this.. I am working on a request form using only SharePoint list and power automate. There is a flaw that I am not able to fix. The issue is the requester is able to edit all columns after they submitted the form (means after they created an item). I want to restrict the requester from editing certain columns (disable edit to only certain columns instead of the whole item) if you happen to have share the solution in any of your videos, really appreciate if you can re-post the link here, thank you..
Most welcome! I do not have a video reference for the scenario mentioned. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Brilliant Overview - Please keep such video's coming as I learned lot from your videos... Can you please check if we have facility to approve multiple items on mail which newly added in a day and so the status gets changed automatically after manager approves
Thanks! When I make a video on a topic, I start researching about its feasibility and I make videos when I get multiple requests on a topic. This topic has had very few requests.
As always, you bring excellent videos for all SharePoint disciples. Where can I recreate the header example with the Bing map and the detailed information (minute 12:32)?
Hi Reza - Love your videos but I've searched and searched and cant find instructions for more advanced conditional formatting. I want to check if one of 4 options (from a list of 7 options) is selected and if so, make another field visible. So essentially,... IF option 1 'OR' option 2 'OR' option 3 'OR' option 4 is selected, show a separate field. It looks like || is used for 'OR' (and && for AND) but I can't put it into the correct syntax to make it work. Any ideas?
This is a very specific scenario. I don’t have a video reference for this and would have to try it out to know the formula. I will recommend checking or posting your query on SharePoint forum techcommunity.microsoft.com/t5/sharepoint/bd-p/SharePoint_General
Awesome video! Helped me a lot! Didn't know it was possible to do all this kinda stuff in Sharepoint. I have a question.. I did everything like you, but it don't appear the map plotted when I open the line to edit, as you did. Could you help me figuring out what action may be missing?
I did this video a long while ago. I have a playlist on list formatting and one of those videos I think I did a deep dive on the maps. It was using bing maps and it requires a bing maps API key.
Hi @RezaDorrani , This was an extremely useful video. I am struggling with one use case and would appreciate your advice please. I want to make the "CHOICE" column as Multiple selection and also capture specific information based on each selection. Example there are 3 choices for me in the choice column - RED, YELLOW, GREEN. My requirement is that when the user selects RED, there are 2 date field and 2 multiline columns shat should become visible and capture values, then if the user also selects YELLOW there should 3 separate set of columns that should become visible and capture values. Same action when the user selects GREEN. If the user unselects any of these choices (RED, YELLOW or GREEN), their related fields should vanish along with their content . How can this be implemented ?
Learned a lot of good info from this video! Appreciate the clear and concise examples from start to finish. One question, is there a way by formula or what not to display content from a column based off what another has? Instead of hiding/showing an entire column but data within that column. For example, I select a start and end date...is it possible to hide content in another column based on if it falls or doesn't fall between those dates?
@@RezaDorrani ah ok. Wasn't sure if there was anything that could be put into the formulas or column validation sections. I'll have to rethink the idea I had, but amazing info as usual.
Hi Reza, a very informative video. Thank you. I was just wondering if it is possible to ad an 'Approve' 'Reject' button in the body rather than the approver having to select from the drop down?
5:27 Hi Reza! Amazing video as always. Is it possible to show a column if the user belongs to a specific SP Group? Trying to find a way to show the fields to all the resolvers on a team. Thanks in advance! :)
Great job! Is there a way to make a field in a section use the full width? As in: Section1 --column1--column2--column3 section2 -----------------column4-----------------
Hi Reza, great video, thx. Is there a similar customization method for document library forms? Basically they are lists as well... THX and best regards from Austria!
Hi Reza, thanks for the very informative content! Regarding customized headers (12'50'') could you pleae share the JSON of the example that you have provided in the video? I am particularly interested in formatting the background depending on a column value. Is it possible to do that based on a calculated column? Or even just display the result of a calculated column in the header? I have searched in the web and it seems it is not (JSON Form formatting: Unable to use the calculated column value in header/footer layout customization · Issue #8788 · SharePoint/sp-dev-docs · GitHub). I would really appreciate a feedback here. Tks in advance
I have a full playlist on JSON customization on my channel. Multiple videos where I have shared code as well. I tend to reuse and update lists and libraries so I would not have the code anymore and hence asking to check the playlist. I don't think calculated column is supported.
Video description has link to a playlist of videos on header formatting. The descriptions of those videos will include links to download the JSON samples.
Reza! This video was extremely helpful, thank you so much for doing it! I had one quick question though - does the formatting that you do (whether it be json or just conditional formatting) show up when using the app? I can get everything to work using desktop, but the changes don't seem to flow over to the apps. Thanks!
@@RezaDorraniI've been trying to use the List app (on an android phone and tablet), and the forms coding doesn't seem to pull over to the apps (but it works fine on the desktop version)
@@RezaDorrani Yes, it looks like there are some differences between Lists and areas with the Sharepoint app. Anyways, your videos are greatly appreciated and thanks for the responses :)
Such a great video! Question for you: I have Power Automate flows and Power Apps forms connected to my existing SharePoint list - will reordering columns in the SharePoint form impact how those work? (it doesn't change the field # assigned to them, does it?) Same question for configuring the form body to have sections.
Hi Reza, thanks for the wonderful tutorial video you shared. :) I tried to follow up your video to practice step by step. Yet I run into the difficulty that the program does not accept the formula you showed in the video, eg, TravelStartDate>TODAY(), =[$Airline]!=" . I verified many times if any typo, but no. I don't know the exact reasons. Can you give me some directions to figure out this problem on formula? Thanks.
@@RezaDorrani believe it or not, just today we had to retire a power apps form that was causing more trouble than it's worth. This does everything it was doing and much more.
Hi Reza, The form customization is now moved completely to Power Apps. I have a few questions. 1. When a form is opened in Power Apps, it allows the addition of more screens. Is it possible to show multiple screens based on the user? Just like how the Dataverse table forms. 2. If a user has any of Office E1, E3, or E5 licenses, can he/she use the list forms customized with Power Apps and workflows from Power Automate? 3. Is the solution developed on the List scalable?
1 - Dataverse Table forms are multi screen? You can add as many screens as you want in app and check logged in user and accordingly navigate. 2 - As long as app and flow use standard connectors then Yes 3 - ALM friendly - No
This is great. Thank you! Is it possible to set the form up so that the values in a choice column are dependent on the choice in a different column? For example, if there’s a “department” column and someone selects “Marketing”, the choice column named “Job Title” will display only the job titles that are within the marketing department? I know this can be done in power apps, but I’m not sure if/how it can be done right within list itself using some of the filtering techniques you’ve demonstrated here.
Reza, thank you for your clear and concise videos. After watching them I feel a little empowered as a beginner in SharePoint. Would you happen to have any tutorials on creating a hover card for a card in a Board view list? I'
Happy to hear that! It’s all about taking the first steps. I do not have a tutorial on hover cards. Check the documentation for SharePoint formatting. They have some good examples there.
Awesome video. I am creating Forms in Microsoft Forms then listing out data in SharePoint. However, I am using lot of "add branching" feature in Microsoft Forms, can I do it in SharePoint list forms as well?? Thanks again!
No branching options with JSON. Although you could show and hide columns based on selections that user makes. Actually you have give me an idea to try out :)
Hello there, great tutorial, helped me a lot! Question though - is is possible to add section's description or some sort of guide to every section? Thank you! :)
@@RezaDorrani thanks for your quick response! I have another issue though - no matter which formula I use to hide the column from the author (created by) it doesn't seem to work: =@me!=[$Author.email]; =if([$Author.email]!=@me,'true','false'); =[$Author.email]!=@me) Is there any way I can do this?
Awesome video Reza!! I noticed that the quick link to emojis may need to reference Windows key and semicolon. Would you be able to share the JSON customized destination header you showed in the video?
@@RezaDorrani Thanks Reza! The JSON formatting i found via the playlist is a little different than the sample in the above video. . .however either way when i tried the header from another one of your videos the header map would not display properly. . .the map just appears as a tiny icon in the upper left corner. . .the JSON seems fine and when you click on it is properly grabbing the precise coordinates and it will take you to google maps. . .any ideas on troubleshooting?
Really great video! Two short questions: 1. Can you also show/hide section titles (so not just a collumn) based on the entry of specific fields? 2. Can you show/hide collumns based on multiple conditions? Meaning show this collumn if collumn "[collumn name A] = "[valueX]" & if "[collumn name B"] = "[ValueY]"
Great video, although none of this seems to be working for me, I've tried hiding columns formula, I don't know if it doesn't work on required fields? Sections kind of works but duplicate the display names in each section...
@@RezaDorrani Thanks for getting back to me!! I've sorted the section part, that works now but still having problems hiding any columns - I was trying to hide a column based on the value of a required field, thought that was the problem but can't get any to work
❤ Love it! I learn more from your videos than any other source. Thank you for sharing your expertise and knowledge.
Most welcome. Thank you for watching and learning from the videos.
@@RezaDorrani q
Hi Reza I need formula that will pick the colosest date(to today) from 5 sharepoint list date columns for each row. Some of the date columns can be blank . Is this achievable either in formal or json ?
@@10xApe Not sure as I have not tried this scenario. I will recommend posting your query on sharepoint forums in case someone has done something similar
@Reza Dorrani thanks for your prompt response. What sharepoint forums do you recommend?
The information from 30 videos about Sharepoint packed into one! Pure TH-cam ambrosia! Thank you!
Wow, thank you so much for the appreciation
I had no idea u could customize a SharePoint form in SharePoint, I've always done it through PowerApps, this is so much simpler. Thank you Reza!
You're very welcome!
Haha same thing goes for me but our genius reza is here always to provide us creative things...
@@RezaDorrani how do I access this on SharePoint online cause the PowerApps route is so confusing and not aligning to my list fields
@@sethuelijah5342 Access what?
Hats off Reza. Btb I got a new job with the magic I did at my office with your sessions.
Awesome 😎
Congratulations
This is exactly what I worked on a lot before learning Power Apps :)
Near the end of the video, when you covered linking an approval directly to the form experience and embedding the list on a page, is great to improve the usability! I know it's just clicking the NEW button and then clicking the SAVE button... but for non-technical users, I've noticed they may be a bit overwhelmed at first by the SharePoint List UI.
Great video showing how this is all possible within SharePoint! Thank you, Reza!
Most welcome!
Thanks!
Thank You
Very well done. I shared with others at work as we are all migrating to SharePoint online and having to edit and recreate different aspects. Your video was very thorough and easy to follow.
Thank You so much! So happy to hear that my work is being shared. Much appreciated.
Reza you are on FIRE!
Appreciate you so much for showing these features. I knew a bunch of them, but you threw in a ton more that I didn't.
Thanks!!
🔥
This is the best explanation I've seen on forms customization. I love that you also add how to get supported documentation for each step. Subscribed!!
Thanks Richard
I agree he made it more simpler than ever, now i want to learn to do this way always, but i cant find the icon where he customize the form...i only see preview and send
😭😭😭😭😭😭😭
Hello Reza, thanks a lot !
Based on your training vidéo, I've not created for workflow with "Start and wait for an approval" but "create an approval" and then "wait for approval" and then I've udapted my sharepoint list with the dynamic link to the approval it self, so when the approver receive the workflow notification in Outlook or teams , he has to click on the link to the item in order to see all the informations of the request with json customize forms in sharepoint and just have to click on the link of the workflow in order to approve or reject it.
It's very useful when the approval is done during a dedicated meeting : approvers just have to filter on pending request (or create a dedicated view) and open it one by one in order to take a decision ! Then the power automate flow is finishing in order to send an email of décision to the requestor and update items.
So one again Thanks a lot for all your amazing trainings
Awesome! Thanks for sharing your scenario. I can visualize how well that works :)
Explained everything in a very simple manner, making it easy for viewers to understand.
Great to hear
Thanks so much. As always with your presentations - unbelievable how much valuable information you are delivering in a given timeframe. Regarding this video, I‘d like to know how to include a Cascading dropdown directly in the SharePoint-list experience. Thanks in advance for your feedback and looking forward to learning from your vast experience.
Thank You so much!
Cascading dropdowns is not an option with JSON formatting. You would need to leverage Power Apps for that. I have done 2 videos on cascading dropdowns. I will recommend checking those.
Love your videos! 20 minutes packed with valuable examples - hilarious. Thank you so much Reza 💚
Glad you like them!
Can't THAK YOU enough. So much to learn from this single video. I followed step by step. Only struggling with custom header but will figure out 😀😀
Most welcome!
Thank you! Very clear, concise, and packed with so much useful info in one place.
You're very welcome!
I learnt a lot. I can now extend SharePoint List with JSON. Thanks Reza
Most welcome
You are the best, Reza. Thank you for all your tutorials - always succinct and hugely informative!
Thank You so much for your kind words
So clear, so organized and so simple. Thank you so much!
Most welcome
This was great! 👏A big thank you!
I've learned several things I didn't expect including the things I did expect.
Glad it was helpful!
Very informative
I am trying to watch your all videos to learn SharePoint, power apps, power automate
Thanks so much and I hope all the videos are worthwhile
Reza you are a diamond! I love your wonderful videos and explanations.
Wow, thank you!
Amazing!! Power apps can be slow to load, so I love that we can do so much with just a list. (Not that I don't love Power apps, I really do... but I wish they were faster.)
Slow load times can be due to actions on app onstart or screen visible etc.
Thank you from Costa Rica, excellent video!!!!
You are most welcome!
Very helpfull. Thx so much. Chapeau 🎩Greetings from germany Christoph 👏 👏 👏 👏 👏
Thank You Christoph 🙏
❤️ 🇩🇪
This is what I am looking for, thank you Sir, you are awesome🤩
You are most welcome
Thank you for all what you do for us, it is really a real pleasure watching your videos. I get the same excitement watching a non technical video for entertainment. 👍👍👍👍
Wow, thank you!
@@RezaDorrani i have only one question about these customisations , do they affect apps created based on lists in power apps??
@@SadekInfos7392 No
How do you do it? So much useful info packed in just 20 minutes yet it doesn't feel rushed or overcomplicated. Everything I needed to know to get started. Thank you so much!
Glad it was helpful!
Love it! Thanks for sharing your knowledge Sir Reza!
My pleasure!
Great work Reza 👍
Thanks
Thank you so much!!!!! best tutorials! Exactly what I need!
Great to hear! Thanks so much for watching
Brilliant session, very useful, thanks for sharing.
My pleasure!
Hi Reza, thanks for sharing your videos have been super usefull!
Most welcome! Thanks for watching Pedro
This changed my life.
Thats a big quote
Definitely love it.♥ Thank you so much for sharing such a great experience and knowledge.
You are so welcome!
Amazing, mate! Thanks a lot!
Most welcome
This is wonderful - so detailed, clearly explained and really helped me understand the power of lists and their associated forms - very grateful - thank you.
Glad it was helpful! Thanks for watching
I learned so much from you!!!! Thanks a lot
You are so welcome!
In video at 5:39, could you explain how to derive the approvers emails and where would system take the reference from ?
Approver is a person column in SharePoint
Yes, I used the person column and I am figuring out to write a syntax for 2 specific users can see the columns and others cannot, I used OR function but in a wrong way. I need some help from you on this Reza. Also, can provide access using job title?
I thank you from bottom of my heart for providing such good content to every individual.Thanks again in taking time and replying to my questions.
Amazingly helpful tutorial! Thank you!!
another keeper, thank you Rezza.
Glad to hear that! Thanks for watching.
Can I get the link to the custom json header in your video (12:24)? Thanks!
So helpful!
I have done separate videos on those. Check list formatting or SharePoint playlist on my channel.
hi, sorry but, if ur condition in 5:40 is a value that is not already written (in column 'Approver'), any approval column (with the condition...) won't to show in form... Or I did I mess a step...
Should work for any column of similar type.
HI Reze! Great video, thanks so much! Quick question - I had a date field in the Form passing into List, but when the date is empty, error occurs showing "OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/DatetocompleteIU' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'." Do you happen to have a shortcut for a fix? Thanks!
I have not come across this issue hence not sure whats the fix for this.
I use some of that myself, but a useful refresher.
👍
It helps a lot, thaaaank yoou 🙌🏻🙌🏻🤗
You're welcome 😊
This is so insightful. Thanks for sharing
Most welcome Nono
Awesome tutorial. Thank you!
Most welcome
Thanks a lot for your video, I had never created an MS list, but now I was able to create one and customize it too. Was ablout to close the video when you mentioned JSON coding, but then realized it was too easy. If you see my comment; I have one question - I created a form which questions. Have chosen the choice column and added the following in the drop down menu (Not Applicable, 1, 2, 3 and 4), I wanted to know if I could calculate the average fs a text is present..Hoping you see this one soon.
Glad it helped!
Json formatting can only format data. It cannot calculate avg across all the items.
Look into column totals feature in SharePoint. Check documentation for that.
Olá sou do Brasil, adoro seus vídeos traz um conteúdo íncrivel mesmo sem ter o inglês avançado consigo estudar com didática parabens pelo contúedo.
De nada! Fico feliz em saber que pude fornecer conteúdo útil para você estudar.
Jean não sei se você sabe, mas tem como ativar as legendas automáticas em português, primeiro vai na engrenagem e ativa a legenda em inglês, fecha a engrenagem, depois volta na engrenagem clica em legenda novamente e clica em traduzir automaticamente e seleciona o português. Isso me ajuda muito a entender o conteúdo.
Hi! Thank you for the video! 😁
I have a question. I created one customized app and if I go to the list itself and open an item and edit it, it saves successfully; however in my main page of the site I added a section with web content-list. If I open an item from there and try to edit it , it does not work. Do you know what could be the reason?
I have not come across this issue and hence not sure what is the cause for your issue.
Solid tutorial as always! Is it possible to make the displayname within the Body Format conditional? For example, all fields within a section are conditional, but if that condition is not met, currently only the displayname appears, which is not the most visually appealing format. I would like the displayname to only appear when the same field conditions are met.
I dont think that is an option
@@RezaDorrani that is also the conclusion I arrived. Appreciate the second opinion.
Thank you so much for this info. I already knew how to make sections, But I do have a goal of adding "Action" buttons to the header that would trigger power automate flows. Is this possible?
Most welcome!
Currently triggering flows from header section is not supported.
You deserve a double like
👍 👍
Thank you Reza for capacity building, this content has extremely enhanced my skills to do some projects. Would you mind sharing the sample JSON formatting for the header that shows the approval status?
Most welcome!
I have a playlist on my channel related to json formatting. I have videos in there where header formatting json was shown and the video descriptions of those include the link to the code.
What a champion, thanks!
Most welcome!
Appreciate you for sharing this valuable knowledge! 👍
Thanks
Hi Reza, great video as always. I was wondering if there is a way to see in the Header the Title value for each item if I select multiple items? Thank you
This does not work with multiple item selections
Hello Reza, thanks for the video, so useful, the only thing is , I want using power app (customize form) to create cascading drop down menu, but I want my rows remain editable by clicking on them. can you please advise?
Most welcome!
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
thanks a million @@RezaDorrani
Great video Reza! Thanks so much for your assistance! Is there a way to increase or set the field width and height within a form section? I need a full-width field (text type) within a full-width section.
You cannot adjust the widths
I learned so much. Thank you. Where can I get the header formatting code for the formatting based on Approval Status? I am just learning and can't seem to figure out how you did that. You are a really good teacher!
I have a playlist on list formatting. Description of those videos has links to the code.
thank you so much for the videos, learning a lot from this..
I am working on a request form using only SharePoint list and power automate. There is a flaw that I am not able to fix.
The issue is the requester is able to edit all columns after they submitted the form (means after they created an item).
I want to restrict the requester from editing certain columns (disable edit to only certain columns instead of the whole item)
if you happen to have share the solution in any of your videos, really appreciate if you can re-post the link here, thank you..
Most welcome!
I do not have a video reference for the scenario mentioned. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Brilliant Overview - Please keep such video's coming as I learned lot from your videos... Can you please check if we have facility to approve multiple items on mail which newly added in a day and so the status gets changed automatically after manager approves
Thanks!
When I make a video on a topic, I start researching about its feasibility and I make videos when I get multiple requests on a topic. This topic has had very few requests.
As always, you bring excellent videos for all SharePoint disciples. Where can I recreate the header example with the Bing map and the detailed information (minute 12:32)?
Thanks!
Check my playlist on sharepoint list formatting. I have shown that in one of the videos.
Excellent!!
Is there any sintax to refer a lookup column in the JSON header?
Documentation has the syntax information. Link is in video description.
Hi Reza - Love your videos but I've searched and searched and cant find instructions for more advanced conditional formatting. I want to check if one of 4 options (from a list of 7 options) is selected and if so, make another field visible.
So essentially,...
IF option 1 'OR' option 2 'OR' option 3 'OR' option 4 is selected, show a separate field.
It looks like || is used for 'OR' (and && for AND) but I can't put it into the correct syntax to make it work. Any ideas?
This is a very specific scenario. I don’t have a video reference for this and would have to try it out to know the formula.
I will recommend checking or posting your query on SharePoint forum techcommunity.microsoft.com/t5/sharepoint/bd-p/SharePoint_General
Awesome video! Helped me a lot! Didn't know it was possible to do all this kinda stuff in Sharepoint.
I have a question.. I did everything like you, but it don't appear the map plotted when I open the line to edit, as you did. Could you help me figuring out what action may be missing?
I did this video a long while ago. I have a playlist on list formatting and one of those videos I think I did a deep dive on the maps. It was using bing maps and it requires a bing maps API key.
Hi @RezaDorrani , This was an extremely useful video. I am struggling with one use case and would appreciate your advice please. I want to make the "CHOICE" column as Multiple selection and also capture specific information based on each selection. Example there are 3 choices for me in the choice column - RED, YELLOW, GREEN. My requirement is that when the user selects RED, there are 2 date field and 2 multiline columns shat should become visible and capture values, then if the user also selects YELLOW there should 3 separate set of columns that should become visible and capture values. Same action when the user selects GREEN. If the user unselects any of these choices (RED, YELLOW or GREEN), their related fields should vanish along with their content . How can this be implemented ?
Hi Richa, this sounds like it may be possible but not something I have tried or have a video reference for. So not sure what the steps would be.
@reza thank you for sharing, Is it possible to show thousands separator when input new item on number column sharepoint list ?
I am not sure about this one.
Learned a lot of good info from this video! Appreciate the clear and concise examples from start to finish.
One question, is there a way by formula or what not to display content from a column based off what another has? Instead of hiding/showing an entire column but data within that column. For example, I select a start and end date...is it possible to hide content in another column based on if it falls or doesn't fall between those dates?
Most welcome.
Hiding column content is not an option with json formatting.
@@RezaDorrani ah ok. Wasn't sure if there was anything that could be put into the formulas or column validation sections. I'll have to rethink the idea I had, but amazing info as usual.
Great video!! Thanks.
Most welcome
Hi Reza, a very informative video. Thank you. I was just wondering if it is possible to ad an 'Approve' 'Reject' button in the body rather than the approver having to select from the drop down?
One cannot customize the body formats
@@RezaDorrani OK, thank you for letting me know - saves lots of searching to find the answer
5:27 Hi Reza! Amazing video as always. Is it possible to show a column if the user belongs to a specific SP Group? Trying to find a way to show the fields to all the resolvers on a team. Thanks in advance! :)
I dont believe there is an option to check if user is in group with JSON
Great job! Is there a way to make a field in a section use the full width?
As in:
Section1
--column1--column2--column3
section2
-----------------column4-----------------
We do not have control over how the columns align in a section.
Your explanation of the question is ONE of the BEST ones I have seen.
Hi Reza, great video, thx. Is there a similar customization method for document library forms? Basically they are lists as well... THX and best regards from Austria!
List form customizations works with both lists and libraries (as far as I know)
Hi Reza, thanks for the very informative content! Regarding customized headers (12'50'') could you pleae share the JSON of the example that you have provided in the video? I am particularly interested in formatting the background depending on a column value. Is it possible to do that based on a calculated column? Or even just display the result of a calculated column in the header? I have searched in the web and it seems it is not (JSON Form formatting: Unable to use the calculated column value in header/footer layout customization · Issue #8788 · SharePoint/sp-dev-docs · GitHub). I would really appreciate a feedback here. Tks in advance
I have a full playlist on JSON customization on my channel. Multiple videos where I have shared code as well. I tend to reuse and update lists and libraries so I would not have the code anymore and hence asking to check the playlist.
I don't think calculated column is supported.
Awesome again Reza. How did you populate and format the header please. Sorry if I missed that bit.
Video description has link to a playlist of videos on header formatting. The descriptions of those videos will include links to download the JSON samples.
@@RezaDorrani Thank you. 🙂
Reza! This video was extremely helpful, thank you so much for doing it! I had one quick question though - does the formatting that you do (whether it be json or just conditional formatting) show up when using the app? I can get everything to work using desktop, but the changes don't seem to flow over to the apps. Thanks!
Which App? SharePoint mobile App does respect it.
@@RezaDorraniI've been trying to use the List app (on an android phone and tablet), and the forms coding doesn't seem to pull over to the apps (but it works fine on the desktop version)
@@btsinkorang I have not tried with lists app. It might very well be a limitation. I know it works with SharePoint mobile app.
@@RezaDorrani Yes, it looks like there are some differences between Lists and areas with the Sharepoint app. Anyways, your videos are greatly appreciated and thanks for the responses :)
@Reza - love this! Question: (1) can we have a different form display with more or less fields, depending upon which user is logged in?
Video shows how to show hide columns based on logged in user.
Great stuff ... I suppose this can't be done in a document library since I don't see that dropdown in the item details at all?
I believe no
Such a great video! Question for you: I have Power Automate flows and Power Apps forms connected to my existing SharePoint list - will reordering columns in the SharePoint form impact how those work? (it doesn't change the field # assigned to them, does it?) Same question for configuring the form body to have sections.
Reordering in SharePoint will have no impact in apps or flows
Hi Reza, thanks for the wonderful tutorial video you shared. :) I tried to follow up your video to practice step by step. Yet I run into the difficulty that the program does not accept the formula you showed in the video, eg, TravelStartDate>TODAY(), =[$Airline]!=" . I verified many times if any typo, but no. I don't know the exact reasons. Can you give me some directions to figure out this problem on formula? Thanks.
Your formula looks fine. I have not come across this issue hence not though hence sure what the resolution would be until I reproduce your issue.
@@RezaDorrani Thank you for the reply. 🙂 Understood.
Great 👍👍👍👍 thank you
Welcome 😊
Really cool, but how did you add the map in the header? I haven't been able to find any documentation about that
I have a playlist on SP form customizations. I must have shown it in a different video.
I remember using the Bing Maps API for it.
Amazing video! Wouldn't mind more of the same please.
More to come!
@@RezaDorrani believe it or not, just today we had to retire a power apps form that was causing more trouble than it's worth. This does everything it was doing and much more.
@@GazaAli Goal of video was to showcase what can be done In-Product! SharePoint forms itself are powerful. Not everything needs to be a Power App.
@@RezaDorrani Amen to that. Is it at all possible to force the form to always display across 2 columns?
@@GazaAli I have mentioned this in video. Answer is no.
Greetings from Tunisia, Reza! Could you please help with fomula to hide/show entire section in SP List instead of single field?
I don’t think there is an option to do that. You can only do per field.
Hi Reza,
The form customization is now moved completely to Power Apps. I have a few questions.
1. When a form is opened in Power Apps, it allows the addition of more screens. Is it possible to show multiple screens based on the user? Just like how the Dataverse table forms.
2. If a user has any of Office E1, E3, or E5 licenses, can he/she use the list forms customized with Power Apps and workflows from Power Automate?
3. Is the solution developed on the List scalable?
1 - Dataverse Table forms are multi screen?
You can add as many screens as you want in app and check logged in user and accordingly navigate.
2 - As long as app and flow use standard connectors then Yes
3 - ALM friendly - No
Thanks @@RezaDorrani.
This is great. Thank you! Is it possible to set the form up so that the values in a choice column are dependent on the choice in a different column?
For example, if there’s a “department” column and someone selects “Marketing”, the choice column named “Job Title” will display only the job titles that are within the marketing department?
I know this can be done in power apps, but I’m not sure if/how it can be done right within list itself using some of the filtering techniques you’ve demonstrated here.
Dependent choice columns cannot be achieved with JSON.
Reza, thank you for your clear and concise videos. After watching them I feel a little empowered as a beginner in SharePoint. Would you happen to have any tutorials on creating a hover card for a card in a Board view list? I'
Happy to hear that! It’s all about taking the first steps.
I do not have a tutorial on hover cards. Check the documentation for SharePoint formatting. They have some good examples there.
@@RezaDorrani thanks. The documentation and a decent text editor allowing me to see the json structure did the trick.
Awesome video. I am creating Forms in Microsoft Forms then listing out data in SharePoint. However, I am using lot of "add branching" feature in Microsoft Forms, can I do it in SharePoint list forms as well?? Thanks again!
No branching options with JSON. Although you could show and hide columns based on selections that user makes. Actually you have give me an idea to try out :)
great material
Thanks
Hello there,
great tutorial, helped me a lot!
Question though - is is possible to add section's description or some sort of guide to every section?
Thank you! :)
Welcome!
Currently, no option for section description
@@RezaDorrani thanks for your quick response! I have another issue though - no matter which formula I use to hide the column from the author (created by) it doesn't seem to work:
=@me!=[$Author.email];
=if([$Author.email]!=@me,'true','false');
=[$Author.email]!=@me)
Is there any way I can do this?
@@pkrysztofiak92 Not sure as I have not come across this issue
This is great Reza! Is there a way to hide the default attachment field in the display mode of the form for a particular group of users?
Cannot show hide columns based on groups with JSON.
You would probably need to take the Power Apps route for it.
Thank you very much for covering this. it is quite handy! is it possible to have the form on separate page or we have to use PowerApps?
Can you elaborate more on separate page
Awesome video Reza!! I noticed that the quick link to emojis may need to reference Windows key and semicolon. Would you be able to share the JSON customized destination header you showed in the video?
Video description has link to my playlist on JSON formatting. The videos in there (description) have links to download JSON header.
@@RezaDorrani Thanks Reza! The JSON formatting i found via the playlist is a little different than the sample in the above video. . .however either way when i tried the header from another one of your videos the header map would not display properly. . .the map just appears as a tiny icon in the upper left corner. . .the JSON seems fine and when you click on it is properly grabbing the precise coordinates and it will take you to google maps. . .any ideas on troubleshooting?
@@TheMOOKIEBLAYLOCK Map needs access key. Its in JSON. You cannot use my key :)
Wow this is so useful thanks
Glad it was helpful!
can we have tables or add something like a title for before the column but not above, but on the left side. or can we change hide names
Currently, Body formatting is not an option
Really great video!
Two short questions:
1. Can you also show/hide section titles (so not just a collumn) based on the entry of specific fields?
2. Can you show/hide collumns based on multiple conditions? Meaning show this collumn if collumn "[collumn name A] = "[valueX]" & if "[collumn name B"] = "[ValueY]"
Basically i tried this: =IF(AND([$category1] == 'X', [$category2] =='Y'), 'true', 'false')
Feedback would be very appreciated!!
1 - Currently, section titles cannot be hidden
2 - check documentation on how to add multiple conditions
Can you do the galary view list that clickable that when clicking on a card, it open a link instead of open the property of the card. Thank you
It can only open card props. Links were allowed previously but were blocked due to security reasons
Great video, although none of this seems to be working for me, I've tried hiding columns formula, I don't know if it doesn't work on required fields? Sections kind of works but duplicate the display names in each section...
Required fields cannot be hidden. User has to fill it.
Duplicate display names is not an issue I have experienced
@@RezaDorrani Thanks for getting back to me!! I've sorted the section part, that works now but still having problems hiding any columns - I was trying to hide a column based on the value of a required field, thought that was the problem but can't get any to work
@@AndyCragg-n4o I have not come across that issue hence not sure. I would recommend posting your issue on SharePoint forums
@@RezaDorrani I found it - you have to know the internal name of the column - mine had changed visually but the internal name hadn't!
Very helpful thank you
You're welcome!