useCADataverseDataTable

@spartanfx/react v1.1.0

---

@spartanfx/react / codeapps / useCADataverseDataTable

Function: useCADataverseDataTable()

function useCADataverseDataTable<TRecord>(config): UseCADataTableReturn<TRecord>;

Power Apps Code Apps DataTable hook backed by a Dataverse table.

Consumes a generated Dataverse service produced by pac code add-data-source -a dataverse -t <table-logical-name>.

Type Parameters

TRecord

TRecord = any

Parameters

config

IUseCADataverseDataTableConfig<TRecord>

Returns

UseCADataTableReturn<TRecord>

Example

import { AccountsService } from './generated/services/AccountsService';
import type { Accounts } from './generated/models/AccountsModel';
import { useCADataverseDataTable } from '@spartanfx/react/codeapps';

const columns = [
  { fieldName: 'name', detailsListColumn: { name: 'Name', minWidth: 200 } },
  { fieldName: 'accountnumber', detailsListColumn: { name: 'Account #' } },
  { fieldName: 'address1_city', detailsListColumn: { name: 'City' } },
];

const dataTableProps = useCADataverseDataTable<Accounts>({
  service: AccountsService as any,
  columns,
  searchFields: ['name', 'accountnumber'],
  odataFilter: "statecode eq 0",
  rowLimit: 100,
});

return <DataTable {...dataTableProps} />;