Skip to main content

#Datatable0 discussing

I have the most recent version of the Flow Base Packs and the Datatable.  All experience cloud users are assigned a permission set group and the perm sets that are installed with these packages are included in that PSG.  Attached are some debug logs I ran on a user reporting the issue.  As well as some Chrome developer tool results.  I have no idea how to fix this.  The datable is not a fancy setup in the screen flow.  It just displays a list of contacts.  Prior to the screen I have the contacts sorted by 3 fields that are check box fields.  Any help would be appreciated. #Unofficial SF #Datatable #Flow #Automation @Eric Smith

Upgraded Datatable Throwing Error for Some (NOT ALL) Experience Cloud Users

 

Screenshot 2023-09-21 at 8.19.28 PM.png

 

Screenshot 2023-09-21 at 8.21.55 PM.png

 

Screenshot 2023-09-21 at 8.22.04 PM.png

 

Screenshot 2023-09-21 at 8.22.10 PM.png

 

Screenshot 2023-09-21 at 8.47.08 PM.png

 

Screenshot 2023-09-21 at 8.48.27 PM.png

 

Screenshot 2023-09-21 at 8.48.58 PM.png

 

Screenshot 2023-09-21 at 8.49.13 PM.png

 

Screenshot 2023-09-21 at 8.49.44 PM.png

10 answers
  1. Apr 17, 6:28 PM

    @Justin White I'm checking the option called  Open links in the same Tab

    to open in same tab for my Console app, stil it is opening in New Tab. Did you came across this issue by any chance. 

    Appreciate your answer.

0/9000

We're using Datatable (4.1.4) in a flow, and have discovered that inactive picklist values render as blank.  If I activate them, they show up.  If I deactivate them, they disappear.  I couldn't find this behavior documented anywhere -- is it expected, or is there a suggested workaround?  #Datatable

2 answers
  1. Jun 13, 2025, 7:35 AM

    Hi all, I am facing the same issue with the current version of data table (4.3.6).  

     

    I tried creating a formula field that would just take the TEXT from the picklist field, but that doesnt work either. 

     

    Is there any workaround for this?

0/9000

# Solution: Making Row Action Dropdown Menu Extend Outside the Lightning Datatable 

 

## Problem 

 

When creating a custom datatable component using Lightning Web Components (LWC), I noticed that the row action dropdown menu (containing options like Edit, Delete, etc.) was confined within the table boundaries and wouldn't extend outside the table. This negatively impacted the user experience, especially with narrow tables. 

 

In standard Salesforce behavior, these dropdown menus extend outside the table and appear above other elements. However, this behavior wasn't occurring in my custom datatable component. 

 

## Root Cause 

 

The root cause of the issue was the `slds-table_fixed-layout` CSS class used in the datatable component. This class fixes the width of the table and controls the width of cells, but it also applies the `table-layout: fixed` CSS property. This property locks the table layout and prevents content from overflowing, which prevents the dropdown menu from extending outside the table. 

 

## Solution 

 

The solution is very simple: remove or replace the `slds-table_fixed-layout` class. 

 

```html 

<c-custom-datatable 

    key-field="Id" 

    data={itemsData} 

    columns={columns} 

    draft-values={draftValues} 

    onsave={handleSave} 

    onrowaction={handleRowAction} 

    class="slds-table_bordered" <!-- instead of slds-table_fixed-layout --> 

    hide-checkbox-column 

    wrap-text-max-lines="2" 

    wrap-table-header="all"> 

</c-custom-datatable> 

``` 

 

## Result 

 

This simple change allows the dropdown menu to extend outside the table and aligns with standard Salesforce behavior. I hope this solution helps other developers who encounter similar issues. 

 

#LWC  #Datatable  #Dropdown Selection

0/9000

**NEW UPDATE: ISSUE SOLVED - Not Datatable issue **

 

We using Datatable from UnofficialSF (V4.1.6), in my component I let user to select multiple rows.

 

From displayed records in Datatable, when user select records - it not showing checkbox for selected rows as TRUE. From the UI it looks like none selected, but when user click next selected rows are actually available in next screen.

 

This creates few confusion to users if they selected any or not.

 

Does anyone have similar issues? Am I missing something here?

 

Few more info:

  • Passing all selected records to collection variable via Advanced 'Output Selected Rows (Collection)' option.
  • Only letting user to select record from datatable (not edit)
  • Records we displaying in dtatable varies from 20 rows to 600 rows (depends on filter from previous collection variable)
  • #Unofficial SF #Datatable
13 answers
  1. Eric Smith (Retired) Forum Ambassador
    Jan 30, 2025, 6:09 PM

    Assign a collection variable to be used for the pre-selected rows in the datatable configuration.  After the screen, assign the OutputSelectedRows from the datatable to the variable so the new values will be saved before looping back to the datatable screen. 

     

0/9000

Is it possible to sort records by column in the native salesforce flow data table component? This is a requirement of our users, but I am not finding the functionality.

 

I know the Unofficial SF Data Table allows this, but I would prefer to use the native component because the search bar feature works much better in the native data table.

 

#Screen Flow #Datatable #Flow

2 answers
  1. Davis Johnson (SolomonEdwards) Forum Ambassador
    Nov 22, 2023, 8:36 PM

    @Chelsey Latzig,

    This is, unfortunately, not supported in the native datatable. I checked around on the ideaExchange for the idea for this to check support, and saw you hit it with a comment pretty recently!

    https://ideas.salesforce.com/s/idea/a0B8W00000N7HiDUAV/allow-sorting-filtering-and-inline-edits-in-data-table-in-screen-flows

0/9000

When i click on the 'Apply' button the changes are not applied to all the selected rows. 

Is there a way to override the apply button . What am i missing here..Any official doc on how it works. I don't see any reference in salesforce doc

#Salesforce Developer #LWC #Datatable @* Salesforce Developers *

1 answer
  1. Jun 21, 2024, 9:58 AM

    Hi @Albin W

    After clicking "Apply" button, there would one save button at bottom of datatable.

    Which would trigger "onsave" event.

     

    Component Ref. Doc: https://developer.salesforce.com/docs/component-library/bundle/lightning-datatable/example

     

    Example.

    HTML

    <lightning-datatable

    key-field="id"

    data={data}

    columns={columns}

    onsave={handleSave}

    >

    </lightning-datatable>

    In JS,

    handleSave(event){

    // here draftValues is array of updated rows,

    // each row is object having updated column value & id.

    console.log(event.detail.draftValues);

    }

    Please make sure that datatable does not have "suppress-bottom-bar" attribute,

    If present, the footer that displays the Save and Cancel buttons is hidden during inline editing.

0/9000

I have a data table, which contains rows with user selectable row option enabled in flex card omnistudio, How to select all rows in data table by default.

Is there any Option to select all rows in data table by default??

 

Thanks in advance!!!  

 

#Trailhead  #Salesforce Developer  #Automation #Omnistudio #Datatable

3 answers
  1. Jun 15, 2024, 9:14 PM

    @sai kumar pulluri I am having the same issue, can you please let me know if you are able to resolve the issue. Any comments would be helpful, thank you. 

0/9000

Hello,

 

I have a lightning datatable where I have introduced a new custom type "customPicklist" for the column. Now when I declare the LeadSource column as customtype as editable and picklist field shows as editable and works fine. But for the type "text" for other columns, i.e Email it is not editable. I have attached screenshot at the end. Is there an issue in the code or the data table wont work as editable due to use of both standard and custom types ? Any guidance would help. Thanks!

 

myCustomTypeDataTable.js

 

import picklistColumn from './picklistColumn.html';

 

 static customTypes = {

        customPicklist: {

          template: picklistColumn,

          standardCellLayout: true,

          typeAttributes: ['label', 'placeholder', 'options', 'value']

        }

 

picklistColumn.html

<template>

    <lightning-combobox name="picklist" data-inputable="true" label={typeAttributes.label} value={typeAttributes.value} placeholder={typeAttributes.placeholder} options={typeAttributes.options} 

        dropdown-alignment="auto"></lightning-combobox>

</template>

  •  In my main component, I  also have standard types along with the custom type to be used as editable field.

contactList.js 

const COLUMNS = [

    { label: 'First Name', fieldName: FIRSTNAME_FIELD.fieldApiName, type: 'text' },

    { label: 'Last Name', fieldName: LASTNAME_FIELD.fieldApiName, type: 'text' },

    { label: 'Email', fieldName: EMAIL_FIELD.fieldApiName, type: 'text', editable:true, wrapText:true },

    { label: 'LeadSource', fieldName: 'LeadSource', type: 'customPicklist', editable: true, wrapText:true, typeAttributes: {

            placeholder: 'Choose Type', options: [

                { label: 'Web', value: 'Web' },

                { label: 'Other', value: 'Other' },

            ], 

            value: { fieldName: 'LeadSource' } // default value for picklist,

        }

    }

];

contactList.html

 <c-my-custom-type-data-table

           key-field="Id"

           data={contacts.data}

           columns={columns}>

           </c-my-custom-type-data-table>

 

Additional Context

Since I am using the customtypes, I have to use the above tag instead of <lightning-datatable> . If I use the standard lightning datatable, the text type fields becomes editable as expected.

 

Component:

 

Lightning Datatable : Multiple Editable columns doesn't work when both custom types and standard types are present

 

#Salesforce Developer  #Lightning Web Components  #Datatable  #Customer Type

1 answer
0/9000

[▶️]🔴🔥🎬 Use Flow Repeater Component To Collect Information And Create Records | #Salesforce Summer 24 Release Feature

 

Welcome, Trailblazers! With each new Salesforce release comes a wave of innovation, empowering businesses and admins to unlock new capabilities and enhance user experiences. Among the exciting features introduced in the Summer ’24 release is the groundbreaking Flow Repeater Component, designed to revolutionize the way users collect input and build lists of records seamlessly within Salesforce Flow.

 

In this blog post and video, I will delve into the intricacies of this game-changing feature, exploring how it simplifies the process of gathering user input to construct lists of records with unparalleled efficiency. In the video, I will be showing how to use the repeater component to collect user input and then create multiple contacts under the selected account. Also inside repeater component, I will be using conditional rendering to make the use case a little advance.

 

In next couple of days, I will be publishing videos covering some of the important release features/enhancements from Summer 24 Release.

 

🎬 https://www.youtube.com/watch?v=MJ05n2DTR6M

🖋️ https://bit.ly/3JDaQIn

 

[▶️]🔴🔥🎬 Use Flow Repeater Component To Collect Information And Create Records | Summer 24 Release Feature Welcome, Trailblazers! With each new Salesforce release comes a wave of innovation, empower@The Blog Group

 

#Flow #Summer24 #Datatable@* Release Readiness Trailblazers * 

0/9000

Current Time Sheet Printing is >>>> {"id":"26ce6dac-010e-4c5a-a886-a8ae03b9403c","picklistoptions":[{"label":"CEC","value":"CEC"},{"label":"TCP","value":"TCP"},{"label":"Holiday","value":"Holiday"},{"label":"Timeoff","value":"Timeoff"}],"taskpicklistoptions":[{"label":"Development","value":"Development"},{"label":"Testing","value":"Testing"},{"label":"Holiday","value":"Holiday"},{"label":"Certification","value":"Certification"},{"label":"Timeoff","value":"Timeoff"}],"03/01/2024":"9","03/02/2024":0,"03/03/2024":0,"03/04/2024":0,"03/05/2024":0,"03/06/2024":0,"03/07/2024":0,"03/08/2024":0,"03/09/2024":0,"03/10/2024":0,"03/11/2024":0,"03/12/2024":0,"03/13/2024":0,"03/14/2024":0,"03/15/2024":0,"total":9}

 

I have used a custom data type and configured a picklist in my datatable however after selecting the value from the picklist in the datatable where does the selected value stores?? above i sthe current row which is being edited taskpicklistoptions and picklistoptions is showing as a whole array of picklistvalues 

 

#Datatable

1 answer
  1. Mar 5, 2024, 10:04 AM

    Hi @Macha Bharath Kumar,

    Hope you are doing well,

    In a Lightning web component with a data table in Salesforce, when you select a value from a picklist in a data table, the selected value is typically stored in the corresponding field in the underlying data. This field should be part of the data structure that you've defined for your data table.

    the selected value is not explicitly stored in the current data structure. To make this work, you should add a property to your data structure to store the selected picklist value.

    For example, you could add a property like selectedPicklistValue:

     

    {

      "id": "26ce6dac-010e-4c5a-a886-a8ae03b9403c",

      "picklistoptions": [

        {"label": "CEC", "value": "CEC"},

        {"label": "TCP", "value": "TCP"},

        {"label": "Holiday", "value": "Holiday"},

        {"label": "Timeoff", "value": "Timeoff"}

      ],

      "taskpicklistoptions": [

        {"label": "Development", "value": "Development"},

        {"label": "Testing", "value": "Testing"},

        {"label": "Holiday", "value": "Holiday"},

        {"label": "Certification", "value": "Certification"},

        {"label": "Timeoff", "value": "Timeoff"}

      ],

      "03/01/2024": {

        "value": "9",

        "selectedPicklistValue": null

      },

      "03/02/2024": {

        "value": 0,

        "selectedPicklistValue": null

      },

      // ... other date properties ...

      "total": 9

    }

     

    Now, when a user selects a value from the pick list in the data table, you can update the selectedPicklistValue property in the corresponding date entry.

    Hope this content will provide more understandinging to you,

    Thanks!

     

     

0/9000