Conditionally Hide Show Fields On A SharePoint List Form

Поділитися
Вставка
  • Опубліковано 4 гру 2024

КОМЕНТАРІ • 74

  • @LuiIacobellis
    @LuiIacobellis  4 місяці тому

    🔔GO FROM SHAREPOINT LIST AMATEUR TO EXPERT IN 90 MINUTES🔔 bit.ly/3zMRRK1

  • @shirleypaul174
    @shirleypaul174 2 роки тому +3

    Thank you Lui. This is very detailed!

    • @LuiIacobellis
      @LuiIacobellis  2 роки тому +1

      You're very welcome Shirley and thanks for watching

  • @nikkisiopes
    @nikkisiopes Рік тому +1

    The formula worked great with my choice column on the form. However, I had to change that column to a look up column.. Does the formula change slightly? I still need the show/hide function. Any suggestions please?!

  • @stevencustred1188
    @stevencustred1188 9 місяців тому +1

    Worked great...sort of. Hide and show work fine. However, if Field1 condition has Field2 to display, once you tab out of Field1 it auto tabs to Field3 AND displays Field2. Now the User has to back-tab to complete the data in Field2. How do you show Field2 AND not auto-skip to the Field3?

  • @yvonnemairose6100
    @yvonnemairose6100 4 місяці тому +1

    Wonderful video. If my Sharepoint list has sections formatted in the body. And I want to hide all fields in that section. How would I go about hiding the title of that section also?
    Thanks!

  • @bekingproductions
    @bekingproductions 6 місяців тому +2

    Thanks for the video! As far as you know, is there any way to hide specific fields to people who are granted the "view only" option (permission granted via power automate flow)? I have a SP List regarding facility management tickets and I would like to hide some fields to requester (prices, agreements) but still show some others (status, description, etc..)..

    • @LuiIacobellis
      @LuiIacobellis  6 місяців тому

      Unfortunately you cannot hide fields based on a user's permissions. You would need to use Power apps to accomplish something like that.

  • @Krzypham_17
    @Krzypham_17 2 місяці тому

    Hi Lui, how about the conditional hide show must be filled up before saving the item?

  • @edwinvandongen8883
    @edwinvandongen8883 Рік тому +2

    Is it possible to make a field mandatory if a condition is met? So for example, if VIP = true, make visible VIP Reason, AND also make VIP Reason mandatory.

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      Hi there, to the best of my knowledge it's not possible to do this using conditional formulas on the SP list form. You can do this with list validation and I have a tutorial that demonstrates how to do this here: ua-cam.com/video/K9Dg2sDKGuA/v-deo.html

  • @nikdeshnehare3171
    @nikdeshnehare3171 2 місяці тому

    Any alternate solution how can we reference multiple values in condition to hide or show columns.

  • @isBessem
    @isBessem 2 місяці тому

    Is it possible to hide/show entire section?

  • @PoojaGidwani-dy3yv
    @PoojaGidwani-dy3yv 5 місяців тому

    Hi, How can i use similar formula for number column. If Late > 0, show reason for late column

  • @susannesenger8705
    @susannesenger8705 Місяць тому

    Very good!

  • @gaelledept4072
    @gaelledept4072 5 днів тому

    And what if we want to hide a column and depending on another field show it again? Is that a limitation?

  • @ajieapen
    @ajieapen 2 роки тому +1

    Can nested if conditions be used too?

    • @LuiIacobellis
      @LuiIacobellis  2 роки тому

      Hi Aji, yes you can use nested IF statements as well. See this article for more info: learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-show-hide - Hope this helps and thanks for watching!

    • @jillmcghee446
      @jillmcghee446 2 роки тому +1

      @@LuiIacobellis I am hoping to do similar - in my example it would be USA or other option...is this possible..The site leads me to believe not...

    • @tomrwills
      @tomrwills 2 роки тому

      @@jillmcghee446 I'm trying to figure out the same. If they choose 2 out of 4 choices, I want to show a field.

  • @luiscastillotantachuco2585
    @luiscastillotantachuco2585 9 місяців тому

    Hello Lui, I am looking for a query to show fields based on a multiple selection, for example I have an options field, where I select A, it shows me the fields, but also that when I select B, it also shows them. I have A,B,C,D in the options and I only want it to show when I select A or B

    • @LuiIacobellis
      @LuiIacobellis  8 місяців тому

      Hi there unfortunately I can't assist with individual requests via chat. Id suggest posting your specific use case over on the Microsoft Tech Community or alternatively try using an generative AI app such as Chat gpt or Copilot.

  • @kill3r94
    @kill3r94 2 роки тому +1

    How can you edit or remove conditional formatting? I was testing a formula but it's not working. Can't figure out how to edit or remove it since the column has been removed from my edit column list.

    • @LuiIacobellis
      @LuiIacobellis  2 роки тому +1

      Hi Spencer, the field should show up in the Edit column list even though its hidden. I've noticed that SharePoint is a bit buggy at times where it won't display the column in the edit column list however. How I've overcome this is to click into the new item form, and then click into the edit form and configure layout. Click save and close it and the column should reappear. Hope this helps and thanks for watching!

  • @heathersteel4793
    @heathersteel4793 Рік тому +1

    Is it possible to show a field if more than one option is selected in another field? For instance, we want to show a field (vendor number) if one of two options under our request type field is selected.

    • @leonardobrans2502
      @leonardobrans2502 Рік тому

      Same here. Is it possible to use " IF OR"?

    • @LuiIacobellis
      @LuiIacobellis  11 місяців тому

      Yes, it is possible to use multiple conditions here.

  • @glaringmind-rq8xu
    @glaringmind-rq8xu Рік тому

    Hi, is there a way to enter a conditional formula based on logged in user's email to show/hide the column in the list. Thank you!

    • @LuiIacobellis
      @LuiIacobellis  Рік тому +1

      Not that I am aware of. This would be best accomplished through a custom form in Power Apps. Hope this helps!

  • @777Scottman
    @777Scottman Рік тому

    Hi Lui, thanks for this video. It's something I've long wanted to achieve.
    However, the edit form icon is missing from all of my lists' New forms.
    Any idea what's wrong?

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      You're very welcome. I've not experienced this issue but I did come across this post on StackExchange: sharepoint.stackexchange.com/questions/297841/edit-form-option-is-missing - Maybe this might assist you.

  • @PaulDungee
    @PaulDungee Рік тому

    Is it possible to use multiple conditions here?

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      Yes, you can indeed use multiple conditions!

  • @cesarcortes105
    @cesarcortes105 Рік тому

    Is it possible to combine 2 "if" formulas to displayed a field depending on the answer of 2 different fields?

    • @lungandfoot
      @lungandfoot Рік тому +1

      Yes. You can use nested IF statements. Simply copy the IF statement and paste it in place of either the 'true' or 'false' term.
      Example: IF([$Status]=='Open', true, IF([$City]=='New York', true, false))
      In plain language, this statement says: "If status is not open, do not show this field ... unless the city is New York."

    • @LuiIacobellis
      @LuiIacobellis  11 місяців тому

      Thanks for the response!

  • @laarninaces9619
    @laarninaces9619 Рік тому

    Thanks for the detailed video - how do you write NOT EQUAL TO in the formula?

  • @travishan4721
    @travishan4721 Рік тому

    is it possible to add more than one values to check

  • @matepal4463
    @matepal4463 2 роки тому

    Hi Lui, for some reason my formula is not working regardless of various field types I tried. I have a list with many columns and settings. When I tried a new list with a few columns only it worked. Is there anything I potentially screwed up in the large list which blocks conditions to work? Thx

    • @LuiIacobellis
      @LuiIacobellis  2 роки тому

      Hi there, I have also experienced similar issues. I would recommend clearing your Browser history, cookies and cache memory and then trying again. Sometimes the browser stores info that will cause SharePoint to throw errors. Hope this helps and thanks for watching!

    • @danbaker2453
      @danbaker2453 11 місяців тому

      Did you ever get this to work? I am running into the exact same problem. I tried clearing the browser with no luck.

  • @bisonfan715
    @bisonfan715 Місяць тому

    I couldnt get this to work for the life of me. The form just doesnt do anything. Is there a way to book a consult call with you to troubleshoot?

  • @Ep1c3634
    @Ep1c3634 Рік тому

    hi luigi i've tried the conditional formula however it's not working and this issue may caused because i've italian version of sherepoint...any ideas? thank you in advance and sorry for my bad english

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      Hi there, to the best of my knowledge it shouldn't matter what language your SharePoint environment is configured too when working with formulas. Hope this helps

  • @grantwylie76
    @grantwylie76 10 місяців тому

    I'm trying to make Attachments section show on condition and even though not on that exclusion list, doesn't seem to work. Any suggestions?

    • @LuiIacobellis
      @LuiIacobellis  10 місяців тому

      I've never tried to conditionally hide-show an attachment field. I'd suggest posting this over on the Microsoft Tech Community.

  • @vivekveera6844
    @vivekveera6844 Рік тому

    is it possible to check if value is blank another field to be hide?

    • @LuiIacobellis
      @LuiIacobellis  11 місяців тому

      You will need to use list validation for this: ua-cam.com/video/K9Dg2sDKGuA/v-deo.html

  • @LuiIacobellis
    @LuiIacobellis  2 роки тому

    CHECK OUT MY HOW TO USE SHAREPOINT PLAYLIST - 40+ TUTORIALS: ua-cam.com/play/PLmE7KGV9-I4uibXaJ7ZqTXbbS4tukRJPh.html

  • @tessicacornelius1400
    @tessicacornelius1400 Рік тому

    I need the "blank" rows to be hid in the default view. When I sort my date column ascending, all the blanks come to the top. So I have to keep scrolling till I reach the first item. I'd like this to be the default view.

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      Hi Tessica Cornelius , I would suggest posting this question over on the Microsoft Tech Community as you will likely be able to get a fast and more detailed response. You can access it at this link: techcommunity.microsoft.com/ - Hope this helps and thanks for watching!

  • @LuiIacobellis
    @LuiIacobellis  Рік тому

    GET THE FORMULAS REFERENCED IN THIS TUTORIAL:
    bit.ly/46Ls1B9

  • @lalis2126
    @lalis2126 Рік тому

    This did not work for me. I used lower case letters and tried refreshing the site, but now the field just does not show on my new item window. Do you know if MIcrosoft changed the permissions?

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      To the best of my knowledge, nothing has changed as it pertains to conditionally hiding & showing fields. I would suggest posting this question over on the Microsoft Tech Community as you will likely be able to get a fast and more detailed response. You can access it at this link: techcommunity.microsoft.com/ - Hope this helps and thanks for watching!

  • @leomatute6871
    @leomatute6871 Рік тому

    Nice video. I tried this, but with a != operator and == and I keep getting an error saying "enter a valid condition". I tried it with several columns and no luck. I tried it in an incognito window as well and nothing. Not sure where i went wrong

    • @LuiIacobellis
      @LuiIacobellis  Рік тому +1

      You can use the "! =" however there are some restrictions on what columns can be used when hiding and showing fields. Here is an article which some info on this point. I'd also suggest posting your comment over on the Microsoft Tech Community with the formulas as someone can help correct the error Hope this helps and thanks for watching sharepoint.stackexchange.com/questions/304962/not-equal-to-for-show-or-hide-columns-in-a-list-or-library-form

  • @sabmayu6063
    @sabmayu6063 3 місяці тому

    Not working for me. Keeps showing "Enter a valid condition". Is this a bug?

  • @yanzkieg1225
    @yanzkieg1225 2 роки тому

    is there a way to use that if the name of the formula contains spaces?

    • @Ezixax
      @Ezixax 2 роки тому

      Same question

    • @TheFlamingDragon100
      @TheFlamingDragon100 2 роки тому +1

      I just removed the spaces in the formula and it worked for me

    • @LuiIacobellis
      @LuiIacobellis  2 роки тому

      Yes, as pointed out above, in order for this to work when your reference column has a space, you will need to remove the space in the formula. Hope this helps! Thanks for watching!

  • @Anon0326
    @Anon0326 Рік тому

    How do I show or hide a column in the form depending on who is the user? I have four levels of approval.

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      Hi Tamim, this would likely require that you build a custom form using Microsoft Power Apps. With this approach you can use more logic and conditions . Hope this helps!

  • @karthikkini8691
    @karthikkini8691 9 місяців тому

    Hellow, I am using the same formula, but after applying it just gets hidden and not showing even if I choose the specified option

    • @LuiIacobellis
      @LuiIacobellis  8 місяців тому

      Unfortunately I can't assist with troubleshoot individual issues via chat. Thanks

    • @TheNinakuda
      @TheNinakuda 28 днів тому

      I get the same issue

  • @leadegalzain9371
    @leadegalzain9371 Рік тому

    how do i hide a column if it's completely empty and show it if not?

    • @LuiIacobellis
      @LuiIacobellis  11 місяців тому

      You will need to use list validation to do this: ua-cam.com/video/K9Dg2sDKGuA/v-deo.html

  • @WorkAccount-v5i
    @WorkAccount-v5i Рік тому

    What could be wrong with this one, it will say that to enter a valid condition
    =if([$What went well behaviors] == 'Direct', 'true', 'false')

    • @LuiIacobellis
      @LuiIacobellis  Рік тому

      Unfortunately I cannot troubleshoot formulas, I'd suggest posting this on the Microsoft Tech Community