Customize Modern SharePoint List Forms Tutorial | JSON Formatting, Validations

  Рет қаралды 196,738

Reza Dorrani

Reza Dorrani

Күн бұрын

Пікірлер
@miss_mann2402
@miss_mann2402 2 жыл бұрын
❤ Love it! I learn more from your videos than any other source. Thank you for sharing your expertise and knowledge.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Most welcome. Thank you for watching and learning from the videos.
@dyslexorx0x0
@dyslexorx0x0 2 жыл бұрын
​@@RezaDorrani q
@10xApe
@10xApe Жыл бұрын
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 ?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@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
@10xApe
@10xApe Жыл бұрын
@Reza Dorrani thanks for your prompt response. What sharepoint forums do you recommend?
@tordsonander
@tordsonander Жыл бұрын
The information from 30 videos about Sharepoint packed into one! Pure KZbin ambrosia! Thank you!
@RezaDorrani
@RezaDorrani Жыл бұрын
Wow, thank you so much for the appreciation
@sherriangell6429
@sherriangell6429 2 жыл бұрын
Thanks!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You
@yttanel
@yttanel 2 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You're very welcome!
@SadekInfos7392
@SadekInfos7392 2 жыл бұрын
Haha same thing goes for me but our genius reza is here always to provide us creative things...
@sethuelijah5342
@sethuelijah5342 2 ай бұрын
@@RezaDorrani how do I access this on SharePoint online cause the PowerApps route is so confusing and not aligning to my list fields
@RezaDorrani
@RezaDorrani 2 ай бұрын
@@sethuelijah5342 Access what?
@manublr
@manublr 5 ай бұрын
Hats off Reza. Btb I got a new job with the magic I did at my office with your sessions.
@RezaDorrani
@RezaDorrani 5 ай бұрын
Awesome 😎 Congratulations
@yxu95
@yxu95 2 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Most welcome!
@heth718
@heth718 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You so much! So happy to hear that my work is being shared. Much appreciated.
@thermant8452
@thermant8452 Жыл бұрын
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!!
@RezaDorrani
@RezaDorrani Жыл бұрын
🔥
@RichardNievesNY
@RichardNievesNY Жыл бұрын
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!!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks Richard
@sethuelijah5342
@sethuelijah5342 2 ай бұрын
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 😭😭😭😭😭😭😭
@frankradewagen3488
@frankradewagen3488 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@nicolasg4640
@nicolasg4640 2 жыл бұрын
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
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Awesome! Thanks for sharing your scenario. I can visualize how well that works :)
@alhakawaty
@alhakawaty Жыл бұрын
So clear, so organized and so simple. Thank you so much!
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@shravanjadhav5082
@shravanjadhav5082 6 ай бұрын
Explained everything in a very simple manner, making it easy for viewers to understand.
@RezaDorrani
@RezaDorrani 6 ай бұрын
Great to hear
@evitweetie7115
@evitweetie7115 2 жыл бұрын
Love your videos! 20 minutes packed with valuable examples - hilarious. Thank you so much Reza 💚
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Glad you like them!
@qudsia2343
@qudsia2343 Жыл бұрын
Thank you! Very clear, concise, and packed with so much useful info in one place.
@RezaDorrani
@RezaDorrani Жыл бұрын
You're very welcome!
@SvenSturesson
@SvenSturesson 3 ай бұрын
This was great! 👏A big thank you! I've learned several things I didn't expect including the things I did expect.
@RezaDorrani
@RezaDorrani 3 ай бұрын
Glad it was helpful!
@Tasneem-e2e
@Tasneem-e2e 3 ай бұрын
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 😀😀
@RezaDorrani
@RezaDorrani 3 ай бұрын
Most welcome!
@Mal501
@Mal501 2 жыл бұрын
You are the best, Reza. Thank you for all your tutorials - always succinct and hugely informative!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You so much for your kind words
@tohitshekh7209
@tohitshekh7209 2 жыл бұрын
Very informative I am trying to watch your all videos to learn SharePoint, power apps, power automate
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks so much and I hope all the videos are worthwhile
@michaelw.881
@michaelw.881 Жыл бұрын
Reza you are a diamond! I love your wonderful videos and explanations.
@RezaDorrani
@RezaDorrani Жыл бұрын
Wow, thank you!
@oluwatobipaul6171
@oluwatobipaul6171 2 жыл бұрын
I learnt a lot. I can now extend SharePoint List with JSON. Thanks Reza
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Most welcome
@christophmeirich5928
@christophmeirich5928 2 жыл бұрын
Very helpfull. Thx so much. Chapeau 🎩Greetings from germany Christoph 👏 👏 👏 👏 👏
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thank You Christoph 🙏 ❤️ 🇩🇪
@hectorgil3495
@hectorgil3495 5 ай бұрын
Thank you from Costa Rica, excellent video!!!!
@RezaDorrani
@RezaDorrani 5 ай бұрын
You are most welcome!
@olenaoleary7218
@olenaoleary7218 2 жыл бұрын
Thank you so much!!!!! best tutorials! Exactly what I need!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Great to hear! Thanks so much for watching
@NelsonONadal
@NelsonONadal 2 жыл бұрын
Love it! Thanks for sharing your knowledge Sir Reza!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
My pleasure!
@toast_it
@toast_it Жыл бұрын
This is wonderful - so detailed, clearly explained and really helped me understand the power of lists and their associated forms - very grateful - thank you.
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad it was helpful! Thanks for watching
@SadekInfos7392
@SadekInfos7392 2 жыл бұрын
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. 👍👍👍👍
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Wow, thank you!
@SadekInfos7392
@SadekInfos7392 2 жыл бұрын
@@RezaDorrani i have only one question about these customisations , do they affect apps created based on lists in power apps??
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@SadekInfos7392 No
@pedropina9005
@pedropina9005 Жыл бұрын
Hi Reza, thanks for sharing your videos have been super usefull!
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome! Thanks for watching Pedro
@nataliusmarani7461
@nataliusmarani7461 Жыл бұрын
This is what I am looking for, thank you Sir, you are awesome🤩
@RezaDorrani
@RezaDorrani Жыл бұрын
You are most welcome
@alzaimoor79
@alzaimoor79 2 жыл бұрын
Brilliant session, very useful, thanks for sharing.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
My pleasure!
@MegaKumar0
@MegaKumar0 2 жыл бұрын
Great work Reza 👍
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Thanks
@richardnewton2631
@richardnewton2631 8 ай бұрын
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!
@RezaDorrani
@RezaDorrani 8 ай бұрын
Glad it was helpful!
@richardr777
@richardr777 7 ай бұрын
Amazing, mate! Thanks a lot!
@RezaDorrani
@RezaDorrani 7 ай бұрын
Most welcome
@fleurwilliamson5920
@fleurwilliamson5920 2 жыл бұрын
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.)
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Slow load times can be due to actions on app onstart or screen visible etc.
@MSimmons784
@MSimmons784 Жыл бұрын
This changed my life.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thats a big quote
@GreyDob
@GreyDob Жыл бұрын
another keeper, thank you Rezza.
@RezaDorrani
@RezaDorrani Жыл бұрын
Glad to hear that! Thanks for watching.
@olenaoleary7218
@olenaoleary7218 Жыл бұрын
I learned so much from you!!!! Thanks a lot
@RezaDorrani
@RezaDorrani Жыл бұрын
You are so welcome!
@herwindhodjaja5980
@herwindhodjaja5980 2 жыл бұрын
Awesome tutorial. Thank you!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Most welcome
@markdearing8363
@markdearing8363 Жыл бұрын
Amazingly helpful tutorial! Thank you!!
@andrewjameson5918
@andrewjameson5918 2 жыл бұрын
I use some of that myself, but a useful refresher.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
👍
@nonoobott8602
@nonoobott8602 Жыл бұрын
This is so insightful. Thanks for sharing
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome Nono
@gerlitz1
@gerlitz1 Жыл бұрын
What a champion, thanks!
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome!
@veraenderung
@veraenderung 7 ай бұрын
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)?
@RezaDorrani
@RezaDorrani 7 ай бұрын
Thanks! Check my playlist on sharepoint list formatting. I have shown that in one of the videos.
@imranozcanyay901
@imranozcanyay901 Жыл бұрын
Definitely love it.♥ Thank you so much for sharing such a great experience and knowledge.
@RezaDorrani
@RezaDorrani Жыл бұрын
You are so welcome!
@mikanurgalymova1578
@mikanurgalymova1578 2 жыл бұрын
It helps a lot, thaaaank yoou 🙌🏻🙌🏻🤗
@RezaDorrani
@RezaDorrani 2 жыл бұрын
You're welcome 😊
@rahulatmapujya4745
@rahulatmapujya4745 Жыл бұрын
Appreciate you for sharing this valuable knowledge! 👍
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@jorgeirazolauribe6832
@jorgeirazolauribe6832 2 жыл бұрын
Great video!! Thanks.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Most welcome
@DiogoMartinsNascimento
@DiogoMartinsNascimento Жыл бұрын
Excelent
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks Diogo
@AMOSODERO
@AMOSODERO 9 ай бұрын
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?
@RezaDorrani
@RezaDorrani 9 ай бұрын
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.
@garywindsor5127
@garywindsor5127 2 жыл бұрын
Awesome again Reza. How did you populate and format the header please. Sorry if I missed that bit.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@garywindsor5127
@garywindsor5127 2 жыл бұрын
@@RezaDorrani Thank you. 🙂
@nishaarvind9744
@nishaarvind9744 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@jariwm
@jariwm Жыл бұрын
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!
@RezaDorrani
@RezaDorrani Жыл бұрын
I have a playlist on list formatting. Description of those videos has links to the code.
@terrymontgomery313
@terrymontgomery313 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
You cannot adjust the widths
@toomtoom1212
@toomtoom1212 Жыл бұрын
You deserve a double like
@RezaDorrani
@RezaDorrani Жыл бұрын
👍 👍
@MrHassancehef
@MrHassancehef 13 күн бұрын
very great tutorial, thank you for it! Do you know if it's possible to adjust size of each question in the form? for example at 9:22 for "reason for travel", if I would like to adjust the text zone to the 100% width of the forms, how to do it? many thanks!
@RezaDorrani
@RezaDorrani 13 күн бұрын
We cannot control the widths using json formatting
@MrHassancehef
@MrHassancehef 12 күн бұрын
@@RezaDorrani sad news, thank you !
@thebigeasye77
@thebigeasye77 Жыл бұрын
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
@RezaDorrani Жыл бұрын
Most welcome. Hiding column content is not an option with json formatting.
@thebigeasye77
@thebigeasye77 Жыл бұрын
@@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.
@nickanderson7074
@nickanderson7074 20 күн бұрын
Very helpful is there away to predefine Costs for an equipment form ?
@RezaDorrani
@RezaDorrani 20 күн бұрын
I dont think thats an option with json formatting
@GuillaumeBOISMENU-DAMOUR
@GuillaumeBOISMENU-DAMOUR 10 ай бұрын
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
@RezaDorrani
@RezaDorrani 10 ай бұрын
This does not work with multiple item selections
@ikas0011
@ikas0011 2 жыл бұрын
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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Can you elaborate more on separate page
@tomasz3166
@tomasz3166 Жыл бұрын
great material
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@jeanmartins1609
@jeanmartins1609 Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
De nada! Fico feliz em saber que pude fornecer conteúdo útil para você estudar.
@luanapegoborja8943
@luanapegoborja8943 Жыл бұрын
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.
@Cedricbob
@Cedricbob 11 ай бұрын
Wow this is so useful thanks
@RezaDorrani
@RezaDorrani 11 ай бұрын
Glad it was helpful!
@MrNickBarber
@MrNickBarber Жыл бұрын
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.
@RezaDorrani
@RezaDorrani Жыл бұрын
I dont think that is an option
@MrNickBarber
@MrNickBarber Жыл бұрын
@@RezaDorrani that is also the conclusion I arrived. Appreciate the second opinion.
@pepper_lab
@pepper_lab 2 жыл бұрын
Great 👍👍👍👍 thank you
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Welcome 😊
@GazaAli
@GazaAli 2 жыл бұрын
Amazing video! Wouldn't mind more of the same please.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
More to come!
@GazaAli
@GazaAli 2 жыл бұрын
@@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.
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@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.
@GazaAli
@GazaAli 2 жыл бұрын
@@RezaDorrani Amen to that. Is it at all possible to force the form to always display across 2 columns?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@GazaAli I have mentioned this in video. Answer is no.
@laurencarter-bialy6437
@laurencarter-bialy6437 9 ай бұрын
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.
@RezaDorrani
@RezaDorrani 9 ай бұрын
Reordering in SharePoint will have no impact in apps or flows
@kashiyamwape943
@kashiyamwape943 8 ай бұрын
Very helpful thank you
@RezaDorrani
@RezaDorrani 8 ай бұрын
You're welcome!
@dkfresh6656
@dkfresh6656 2 жыл бұрын
Another awesome video. Would this concept work with multilevel approvals/approves?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Could work with multilevel approvals as well.
@MonteBStJohns
@MonteBStJohns 2 жыл бұрын
@Reza - love this! Question: (1) can we have a different form display with more or less fields, depending upon which user is logged in?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Video shows how to show hide columns based on logged in user.
@djmrky75
@djmrky75 Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
I believe no
@pkrysztofiak92
@pkrysztofiak92 Жыл бұрын
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
@RezaDorrani Жыл бұрын
Welcome! Currently, no option for section description
@pkrysztofiak92
@pkrysztofiak92 Жыл бұрын
@@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?
@RezaDorrani
@RezaDorrani Жыл бұрын
@@pkrysztofiak92 Not sure as I have not come across this issue
@MarkGuercio-f7z
@MarkGuercio-f7z Жыл бұрын
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'
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@MarkGuercio-f7z
@MarkGuercio-f7z Жыл бұрын
@@RezaDorrani thanks. The documentation and a decent text editor allowing me to see the json structure did the trick.
@ourybarry6314
@ourybarry6314 Жыл бұрын
Wow! great job!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank you!
@Mmaheeshttoorggal
@Mmaheeshttoorggal 2 жыл бұрын
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
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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.
@notimefortact9877
@notimefortact9877 11 ай бұрын
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?
@RezaDorrani
@RezaDorrani 11 ай бұрын
Most welcome! Currently triggering flows from header section is not supported.
@tbakry
@tbakry 6 ай бұрын
Thanks for this video. Is there a way to use the form to see your list data, or is it only good for adding new records to the list?
@RezaDorrani
@RezaDorrani 6 ай бұрын
It works for new items and editing existing items.
@kennethtamang5013
@kennethtamang5013 2 жыл бұрын
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!
@RezaDorrani
@RezaDorrani 2 жыл бұрын
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 :)
@filipesouza107
@filipesouza107 2 ай бұрын
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?
@RezaDorrani
@RezaDorrani 2 ай бұрын
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.
@TripleJ-at
@TripleJ-at Жыл бұрын
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!
@RezaDorrani
@RezaDorrani Жыл бұрын
List form customizations works with both lists and libraries (as far as I know)
@cheraideva2
@cheraideva2 Жыл бұрын
Nice one.
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks!
@aparnasarkar5688
@aparnasarkar5688 2 жыл бұрын
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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Cannot show hide columns based on groups with JSON. You would probably need to take the Power Apps route for it.
@btsinkorang
@btsinkorang Жыл бұрын
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!
@RezaDorrani
@RezaDorrani Жыл бұрын
Which App? SharePoint mobile App does respect it.
@btsinkorang
@btsinkorang Жыл бұрын
@@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
@RezaDorrani Жыл бұрын
@@btsinkorang I have not tried with lists app. It might very well be a limitation. I know it works with SharePoint mobile app.
@btsinkorang
@btsinkorang Жыл бұрын
@@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 :)
@vpereira
@vpereira Жыл бұрын
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-----------------
@RezaDorrani
@RezaDorrani Жыл бұрын
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.
@powerbinareal
@powerbinareal Жыл бұрын
Incrível!!!! #powerbinareal
@RezaDorrani
@RezaDorrani Жыл бұрын
Thank You
@srmchinni3
@srmchinni3 Жыл бұрын
Wonderful
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
@elliotcornall8416
@elliotcornall8416 Жыл бұрын
Great video, thanks for making Reza
@RezaDorrani
@RezaDorrani Жыл бұрын
Most welcome
@denysaugusto2892
@denysaugusto2892 2 жыл бұрын
Excellent!! Is there any sintax to refer a lookup column in the JSON header?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
Documentation has the syntax information. Link is in video description.
@TheSusiew
@TheSusiew 2 жыл бұрын
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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
One cannot customize the body formats
@TheSusiew
@TheSusiew 2 жыл бұрын
@@RezaDorrani OK, thank you for letting me know - saves lots of searching to find the answer
@TheMOOKIEBLAYLOCK
@TheMOOKIEBLAYLOCK 2 жыл бұрын
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
@RezaDorrani 2 жыл бұрын
Video description has link to my playlist on JSON formatting. The videos in there (description) have links to download JSON header.
@TheMOOKIEBLAYLOCK
@TheMOOKIEBLAYLOCK 2 жыл бұрын
@@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?
@RezaDorrani
@RezaDorrani 2 жыл бұрын
@@TheMOOKIEBLAYLOCK Map needs access key. Its in JSON. You cannot use my key :)
@ipuzzle12
@ipuzzle12 Жыл бұрын
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..
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@alexrangel901
@alexrangel901 Жыл бұрын
Can I get the link to the custom json header in your video (12:24)? Thanks! So helpful!
@RezaDorrani
@RezaDorrani Жыл бұрын
I have done separate videos on those. Check list formatting or SharePoint playlist on my channel.
@TheMKTube
@TheMKTube 2 жыл бұрын
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! :)
@RezaDorrani
@RezaDorrani 2 жыл бұрын
I dont believe there is an option to check if user is in group with JSON
@mce8183
@mce8183 Жыл бұрын
Hello Reza, first of all thank you so much for creating all these tutorials, it does help me a lot. I have one question for you. I do not see any entries I made to my list. What did i do wrong?
@RezaDorrani
@RezaDorrani Жыл бұрын
Try with a new list. My only guess is your list view filter criteria may not be matching.
@mce8183
@mce8183 Жыл бұрын
@@RezaDorrani Thank you Reza...I will try that
@nevilleattwater4760
@nevilleattwater4760 21 күн бұрын
Hi Reza. Is there a way to hide the sections based on conditional formatting using these techniques? Eg I would only like to show a section and certain controls in that section based on a status field. Love your work by the way.
@RezaDorrani
@RezaDorrani 21 күн бұрын
Should be possible. Check documentation on list formatting.
@jobvermeeren2542
@jobvermeeren2542 Жыл бұрын
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]"
@jobvermeeren2542
@jobvermeeren2542 Жыл бұрын
Basically i tried this: =IF(AND([$category1] == 'X', [$category2] =='Y'), 'true', 'false') Feedback would be very appreciated!!
@RezaDorrani
@RezaDorrani Жыл бұрын
1 - Currently, section titles cannot be hidden 2 - check documentation on how to add multiple conditions
@MahsaGharecheloo
@MahsaGharecheloo Жыл бұрын
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?
@RezaDorrani
@RezaDorrani Жыл бұрын
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
@MahsaGharecheloo
@MahsaGharecheloo Жыл бұрын
thanks a million @@RezaDorrani
@qvarelli
@qvarelli Жыл бұрын
Excelent. Podrias hacer un video de como generar tablas repetitivas en listas de SP.
@RezaDorrani
@RezaDorrani Жыл бұрын
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
@HelenGiffear
@HelenGiffear Жыл бұрын
This is an awesome video! I do have one issue that maybe you could help me with. With our travel, a report must be completed with a PDF report. Is there a way to create a second form that utilizes the previous submission to gather the information and create a formatted PDF?
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks! I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@williamdaniels9728
@williamdaniels9728 Жыл бұрын
Thank you sir!
@RezaDorrani
@RezaDorrani Жыл бұрын
You are most welcome!
@guntis931
@guntis931 Жыл бұрын
Lieliski! Paldies!
@RezaDorrani
@RezaDorrani Жыл бұрын
Thanks
SharePoint Page Design Best Practices
36:53
SharePoint Maven
Рет қаралды 15 М.
Customize SharePoint list forms with Power Apps
17:27
Shane Young
Рет қаралды 33 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
Мясо вегана? 🧐 @Whatthefshow
01:01
История одного вокалиста
Рет қаралды 7 МЛН
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН
Customize SharePoint List Forms using JSON Formatting (1)
17:57
Reza Dorrani
Рет қаралды 212 М.
SharePoint List Dynamic Filtering DONE RIGHT thanks to Chat GPT
22:26
SharePoint Training for 2024 | Create and Customize Communication Sites
22:08
Mastering Custom JSON List Formatting In SharePoint
23:20
Steve Corey - MVP
Рет қаралды 20 М.
Customize SharePoint Forms with JSON
7:32
April Dunnam
Рет қаралды 34 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН