Customize Modern SharePoint List Forms Tutorial

No video

Customize Modern SharePoint List Forms Tutorial | JSON Formatting, Validations

Рет қаралды 160,734

Күн бұрын

This tutorial video is a step-by-step guide on how to customize Modern SharePoint List / Microsoft List Forms using JSON Formatting, Column & List Validations, designing form header & footer using JSON, adding columns in Sections (Form Body) and more.
Video showcases the power within SharePoint itself (In-product) to customize forms, reorder columns, show and hide columns with conditional formulas, add column and list level validation formulas, create sections in form body, add custom headers and footers using JSON form formatting, add a notification approval workflow using power automate, make columns read-only (in form) by conditional formulas checking logged in user role and much more.
#SharePoint #JSON #Forms #sharepointonline #Microsoftlists
🔗 Helpful Links:
Configure the list form
docs.microsoft...
Show or hide columns in a list or library form
learn.microsof...
Creating custom list templates
learn.microsof...
SharePoint List Form Formatting Playlist:
• SharePoint List Format...
PnP Samples: pnp.github.io/...
Table of Contents:
00:00 - Introduction to customizing Modern SharePoint List Forms with JSON
00:37 - Create SharePoint List from Microsoft List Template
02:21 - Reorder Columns in SharePoint Form
02:53 - Show or Hide Columns in SharePoint Form
03:14 - Required field validations (Column must contain information)
03:39 - Conditional Show Hide Columns (Edit Conditional Formula)
05:59 - Configure SharePoint form body to show one or more sections (JSON)
10:04 - Customize SharePoint Form Header using JSON formatting
11:24 - Customize SharePoint Form Footer using JSON formatting
12:10 - SharePoint Form matches Site Themes (Look and feel)
12:24 - SharePoint Form JSON Customization Example
13:00 - SharePoint column validations
14:06 - SharePoint List Validation Settings (Validation formula)
16:47 - SharePoint List Approval Notification Workflow
20:21 - Add SharePoint List to Modern Page (connected web part - List Properties)
21:01 - Add Modern SharePoint List as a Template
21:42 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Пікірлер: 521

@mjmann2402 Жыл бұрын

❤ Love it! I learn more from your videos than any other source. Thank you for sharing your expertise and knowledge.

@RezaDorrani Жыл бұрын

Most welcome. Thank you for watching and learning from the videos.

@dyslexorx0x0 Жыл бұрын

@@RezaDorrani q

@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 Жыл бұрын

@@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 Жыл бұрын

@Reza Dorrani thanks for your prompt response. What sharepoint forums do you recommend?

@tordsonander Жыл бұрын

The information from 30 videos about Sharepoint packed into one! Pure KZfaq ambrosia! Thank you!

@RezaDorrani Жыл бұрын

Wow, thank you so much for the appreciation

@yttanel Жыл бұрын

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 Жыл бұрын

You're very welcome!

@SadekInfos7392 Жыл бұрын

Haha same thing goes for me but our genius reza is here always to provide us creative things...

@yxu95 Жыл бұрын

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 Жыл бұрын

Most welcome!

@evitweetie7115 Жыл бұрын

Love your videos! 20 minutes packed with valuable examples - hilarious. Thank you so much Reza 💚

@RezaDorrani Жыл бұрын

Glad you like them!

@shravanjadhav5082 25 күн бұрын

Explained everything in a very simple manner, making it easy for viewers to understand.

@RezaDorrani 25 күн бұрын

Great to hear

@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 Жыл бұрын

🔥

@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 Жыл бұрын

Thanks Richard

@alhakawaty 6 ай бұрын

So clear, so organized and so simple. Thank you so much!

@RezaDorrani 6 ай бұрын

Most welcome

@nicolasg4640 Жыл бұрын

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 Жыл бұрын

Awesome! Thanks for sharing your scenario. I can visualize how well that works :)

@qudsia2343 9 ай бұрын

Thank you! Very clear, concise, and packed with so much useful info in one place.

@RezaDorrani 9 ай бұрын

You're very welcome!

@Mal501 Жыл бұрын

You are the best, Reza. Thank you for all your tutorials - always succinct and hugely informative!

@RezaDorrani Жыл бұрын

Thank You so much for your kind words

@richardnewton2631 2 ай бұрын

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 2 ай бұрын

Glad it was helpful!

@richardr777 Ай бұрын

Amazing, mate! Thanks a lot!

@RezaDorrani Ай бұрын

Most welcome

@oluwatobipaul6171 Жыл бұрын

I learnt a lot. I can now extend SharePoint List with JSON. Thanks Reza

@RezaDorrani Жыл бұрын

Most welcome

@michaelw.881 10 ай бұрын

Reza you are a diamond! I love your wonderful videos and explanations.

@RezaDorrani 10 ай бұрын

Wow, thank you!

@tohitshekh7209 Жыл бұрын

Very informative I am trying to watch your all videos to learn SharePoint, power apps, power automate

@RezaDorrani Жыл бұрын

Thanks so much and I hope all the videos are worthwhile

@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 Жыл бұрын

Thank You so much! So happy to hear that my work is being shared. Much appreciated.

@christophmeirich5928 Жыл бұрын

Very helpfull. Thx so much. Chapeau 🎩Greetings from germany Christoph 👏 👏 👏 👏 👏

@RezaDorrani Жыл бұрын

Thank You Christoph 🙏 ❤️ 🇩🇪

@fleurwilliamson5920 Жыл бұрын

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 Жыл бұрын

Slow load times can be due to actions on app onstart or screen visible etc.

@SadekInfos7392 Жыл бұрын

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 Жыл бұрын

Wow, thank you!

@SadekInfos7392 Жыл бұрын

@@RezaDorrani i have only one question about these customisations , do they affect apps created based on lists in power apps??

@RezaDorrani Жыл бұрын

@@SadekInfos7392 No

@olenaoleary7218 Жыл бұрын

Thank you so much!!!!! best tutorials! Exactly what I need!

@RezaDorrani Жыл бұрын

Great to hear! Thanks so much for watching

@kashiyamwape943 3 ай бұрын

Very helpful thank you

@RezaDorrani 3 ай бұрын

You're welcome!

@NelsonONadal Жыл бұрын

Love it! Thanks for sharing your knowledge Sir Reza!

@RezaDorrani Жыл бұрын

My pleasure!

@andrewjameson5918 Жыл бұрын

I use some of that myself, but a useful refresher.

@RezaDorrani Жыл бұрын

👍

@MSimmons784 Жыл бұрын

This changed my life.

@RezaDorrani Жыл бұрын

Thats a big quote

@alzaimoor79 Жыл бұрын

Brilliant session, very useful, thanks for sharing.

@RezaDorrani Жыл бұрын

My pleasure!

@nataliusmarani7461 9 ай бұрын

This is what I am looking for, thank you Sir, you are awesome🤩

@RezaDorrani 9 ай бұрын

You are most welcome

@MegaKumar0 Жыл бұрын

Great work Reza 👍

@RezaDorrani Жыл бұрын

Thanks

@Cedricbob 5 ай бұрын

Wow this is so useful thanks

@RezaDorrani 5 ай бұрын

Glad it was helpful!

@olenaoleary7218 Жыл бұрын

I learned so much from you!!!! Thanks a lot

@RezaDorrani Жыл бұрын

You are so welcome!

@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 Жыл бұрын

Glad it was helpful! Thanks for watching

@markdearing8363 6 ай бұрын

Amazingly helpful tutorial! Thank you!!

@pedropina9005 Жыл бұрын

Hi Reza, thanks for sharing your videos have been super usefull!

@RezaDorrani Жыл бұрын

Most welcome! Thanks for watching Pedro

@herwindhodjaja5980 Жыл бұрын

Awesome tutorial. Thank you!

@RezaDorrani Жыл бұрын

Most welcome

@mikanurgalymova1578 Жыл бұрын

It helps a lot, thaaaank yoou 🙌🏻🙌🏻🤗

@RezaDorrani Жыл бұрын

You're welcome 😊

@GreyDob Жыл бұрын

another keeper, thank you Rezza.

@RezaDorrani Жыл бұрын

Glad to hear that! Thanks for watching.

@imranozcanyay901 Жыл бұрын

Definitely love it.♥ Thank you so much for sharing such a great experience and knowledge.

@RezaDorrani Жыл бұрын

You are so welcome!

@srmchinni3 Жыл бұрын

Wonderful

@RezaDorrani Жыл бұрын

Thanks

@sherriangell6429 Жыл бұрын

Thanks!

@RezaDorrani Жыл бұрын

Thank You

@nonoobott8602 Жыл бұрын

This is so insightful. Thanks for sharing

@RezaDorrani Жыл бұрын

Most welcome Nono

@rahulatmapujya4745 6 ай бұрын

Appreciate you for sharing this valuable knowledge! 👍

@RezaDorrani 6 ай бұрын

Thanks

@AMOSODERO 3 ай бұрын

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 3 ай бұрын

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.

@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 Жыл бұрын

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.

@gerlitz1 Жыл бұрын

What a champion, thanks!

@RezaDorrani Жыл бұрын

Most welcome!

@guntis931 10 ай бұрын

Lieliski! Paldies!

@RezaDorrani 10 ай бұрын

Thanks

@jorgeirazolauribe6832 Жыл бұрын

Great video!! Thanks.

@RezaDorrani Жыл бұрын

Most welcome

@toomtoom1212 Жыл бұрын

You deserve a double like

@RezaDorrani Жыл бұрын

👍 👍

@pepper_lab Жыл бұрын

Great 👍👍👍👍 thank you

@RezaDorrani Жыл бұрын

Welcome 😊

@jariwm 6 ай бұрын

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 6 ай бұрын

I have a playlist on list formatting. Description of those videos has links to the code.

@veraenderung Ай бұрын

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 Ай бұрын

Thanks! Check my playlist on sharepoint list formatting. I have shown that in one of the videos.

@raedalfarhan7279 Ай бұрын

Thanks

@RezaDorrani Ай бұрын

Welcome

@DiogoMartinsNascimento Жыл бұрын

Excelent

@RezaDorrani Жыл бұрын

Thanks Diogo

@maheshtorgal Жыл бұрын

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 Жыл бұрын

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.

@nishaarvind9744 7 ай бұрын

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 7 ай бұрын

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.

@thebigeasye77 8 ай бұрын

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 8 ай бұрын

Most welcome. Hiding column content is not an option with json formatting.

@thebigeasye77 8 ай бұрын

@@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.

@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 Жыл бұрын

De nada! Fico feliz em saber que pude fornecer conteúdo útil para você estudar.

@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.

@jaguarpaw6976 4 ай бұрын

God Bless REZA 😁

@RezaDorrani 4 ай бұрын

Thanks

@williamdaniels9728 Жыл бұрын

Thank you sir!

@RezaDorrani Жыл бұрын

You are most welcome!

@GazaAli Жыл бұрын

Amazing video! Wouldn't mind more of the same please.

@RezaDorrani Жыл бұрын

More to come!

@GazaAli Жыл бұрын

@@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 Жыл бұрын

@@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 Жыл бұрын

@@RezaDorrani Amen to that. Is it at all possible to force the form to always display across 2 columns?

@RezaDorrani Жыл бұрын

@@GazaAli I have mentioned this in video. Answer is no.

@tomasz3166 11 ай бұрын

great material

@RezaDorrani 11 ай бұрын

Thanks

@vpereira 10 ай бұрын

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 10 ай бұрын

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.

@pkrysztofiak92 9 ай бұрын

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 9 ай бұрын

Welcome! Currently, no option for section description

@pkrysztofiak92 7 ай бұрын

@@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 7 ай бұрын

@@pkrysztofiak92 Not sure as I have not come across this issue

@user-gg5dt7qg3c 6 ай бұрын

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!

@RezaDorrani 6 ай бұрын

I have not come across this issue hence not sure whats the fix for this.

@cheraideva2 11 ай бұрын

Nice one.

@RezaDorrani 11 ай бұрын

Thanks!

@user-md7rz7hk8l 4 ай бұрын

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 4 ай бұрын

This does not work with multiple item selections

@ourybarry6314 Жыл бұрын

Wow! great job!

@RezaDorrani Жыл бұрын

Thank you!

@notimefortact9877 5 ай бұрын

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 5 ай бұрын

Most welcome! Currently triggering flows from header section is not supported.

@ipuzzle12 6 ай бұрын

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 6 ай бұрын

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

@elliotcornall8416 6 ай бұрын

Great video, thanks for making Reza

@RezaDorrani 6 ай бұрын

Most welcome

@elisama2936 11 ай бұрын

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?

@RezaDorrani 11 ай бұрын

I have not come across this issue and hence not sure what is the cause for your issue.

@TripleJ-at 9 ай бұрын

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 9 ай бұрын

List form customizations works with both lists and libraries (as far as I know)

@garywindsor5127 Жыл бұрын

Awesome again Reza. How did you populate and format the header please. Sorry if I missed that bit.

@RezaDorrani Жыл бұрын

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 Жыл бұрын

@@RezaDorrani Thank you. 🙂

@powerbinareal Жыл бұрын

Incrível!!!! #powerbinareal

@RezaDorrani Жыл бұрын

Thank You

@MrNickBarber 10 ай бұрын

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 10 ай бұрын

I dont think that is an option

@MrNickBarber 10 ай бұрын

@@RezaDorrani that is also the conclusion I arrived. Appreciate the second opinion.

@jobvermeeren2542 9 ай бұрын

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 9 ай бұрын

Basically i tried this: =IF(AND([$category1] == 'X', [$category2] =='Y'), 'true', 'false') Feedback would be very appreciated!!

@RezaDorrani 9 ай бұрын

1 - Currently, section titles cannot be hidden 2 - check documentation on how to add multiple conditions

@laurencarter-bialy6437 3 ай бұрын

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 3 ай бұрын

Reordering in SharePoint will have no impact in apps or flows

@ikas0011 Жыл бұрын

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 Жыл бұрын

Can you elaborate more on separate page

@richagupta1982 9 ай бұрын

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 ?

@RezaDorrani 9 ай бұрын

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.

@DavidPrenticeJr Жыл бұрын

Great content Reza. I'd love to see if it is possible to reply to these types of approval requests with Outlook actionable messages.

@RezaDorrani Жыл бұрын

You could always leverage flow approvals. I have done several videos on it. I have a playlist on my channel for approvals.

@user-nj1ds3bp7p 9 ай бұрын

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 9 ай бұрын

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.

@user-nj1ds3bp7p 9 ай бұрын

@@RezaDorrani thanks. The documentation and a decent text editor allowing me to see the json structure did the trick.

@ambarish360 Жыл бұрын

Thanks a lot rezza, if possible can you create a video on bulk upload to SP list from Excel. There are multiple ways, but I want your own way, the simplest and powerful one. Like after this video how we start effectively reduce the usage of canvas Powerapp.

@RezaDorrani Жыл бұрын

kzfaq.info/get/bejne/q6uKfMKTlq3XXZ8.html

@ambarish360 Жыл бұрын

@@RezaDorrani thanks a lot, I somehow missed this video, keep rocking

@RezaDorrani Жыл бұрын

@@ambarish360 Its one of the most viewed ones :)

@tbakry 11 күн бұрын

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 11 күн бұрын

It works for new items and editing existing items.

@user-bf4nw7cf2u 9 ай бұрын

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 9 ай бұрын

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

@user-bf4nw7cf2u 9 ай бұрын

thanks a million @@RezaDorrani

@alexrangel901 Жыл бұрын

Can I get the link to the custom json header in your video (12:24)? Thanks! So helpful!

@RezaDorrani Жыл бұрын

I have done separate videos on those. Check list formatting or SharePoint playlist on my channel.

@dkfresh6656 Жыл бұрын

Another awesome video. Would this concept work with multilevel approvals/approves?

@RezaDorrani Жыл бұрын

Could work with multilevel approvals as well.

@somjadek 10 ай бұрын

❤ great, can we show/hide fields baseon administrator/user?

@RezaDorrani 10 ай бұрын

Show hide cannot be based on user’s security role

@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 Жыл бұрын

Try with a new list. My only guess is your list view filter criteria may not be matching.

@mce8183 Жыл бұрын

@@RezaDorrani Thank you Reza...I will try that

@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 Жыл бұрын

You cannot adjust the widths

@fernandobetto9684 2 ай бұрын

Very Nice video. Would it be possible to include a subform with the inclusion of expense items per trip? with attachments etc? or just via PowerApp?

@RezaDorrani 2 ай бұрын

That would be a Power App

@TheMKTube Жыл бұрын

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 Жыл бұрын

I dont believe there is an option to check if user is in group with JSON

@MonteBStJohns Жыл бұрын

@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 Жыл бұрын

Video shows how to show hide columns based on logged in user.

@aparnasarkar5688 Жыл бұрын

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 Жыл бұрын

Cannot show hide columns based on groups with JSON. You would probably need to take the Power Apps route for it.

@qvarelli Жыл бұрын

Excelent. Podrias hacer un video de como generar tablas repetitivas en listas de SP.

@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.

@user-cq7vd9qr5d 8 ай бұрын

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 8 ай бұрын

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.

@KATERINEJULIO-ko3lm Жыл бұрын

Hi Renza You Are Amazing. I hope you can help me with something. I need four fields in the same line. ¿Is that possible? ☺

@RezaDorrani Жыл бұрын

Currently, we cannot control the positioning of columns in the body.

@kennethtamang5013 Жыл бұрын

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 Жыл бұрын

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 :)