useCADataversePlanner

@spartanfx/react v1.2.2

---

@spartanfx/react / codeapps / useCADataversePlanner

Function: useCADataversePlanner()

function useCADataversePlanner(config): ICAPlannerReturn;

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

Configuration

Required

Property	Type	Description
idColumn	string	Logical name of the primary key column on the Dataverse table — usually <entity>id (e.g. cr1a3_taskid). Must match the schema's idField.fieldName value supplied to the Planner.
schema	IPlannerSchema	Schema mapping internal planner fields to data source columns.
service	ICATabularService<CAPlannerRecord, string>	Generated tabular service from pac code add-data-source.

Options

Property	Type	Description
autoRefresh?	boolean	Enable auto-refresh after mutations (default: true).
cacheDuration?	number	Cache TTL for read results in ms (default: 60_000).
choiceColumns?	string[]	SharePoint-only: column names backed by Choice / Lookup / Person columns. The Planner schema is consumer-driven (it doesn't know which columns are Choice columns), so declare them here to enable automatic expansion of string labels to the { "@odata.type", Value, Id } object the SharePoint connector requires on create/update. No default — when omitted, no resolution is performed. Ignored for services that don't expose getReferencedEntity (e.g. Dataverse). See: https://learn.microsoft.com/en-us/power-apps/developer/code-apps/how-to/sharepoint-operations
debounceMs?	number	Debounce delay for refetch on date-range change (default: 300 ms).
debug?	boolean	Enable verbose console logging (default: false).
endDate?	Date	Initial end of the visible range. Default: Dec 31 of current year.
odataFilter?	string	Additional OData $filter to combine with the date-range clause.
retryPolicy?	ICARetryPolicy	Retry policy for transient failures.
rowLimit?	number	Maximum records per fetch (default: 5000).
searchText?	string	Optional search text for client-side filtering.
startDate?	Date	Initial start of the visible range. Default: Jan 1 of current year.

Events & callbacks

Property	Type	Description
onError?	(error) => void	Error callback. Called for every operational failure.
onNotify?	CANotifyFn	Notification callback. If omitted, hook errors surface via error state only.

Full type reference: IUseCADataversePlannerConfig

Returns

ICAPlannerReturn

Example

import { ProjectsService } from './generated/services/ProjectsService';
import { useCADataversePlanner } from '@spartanfx/react/codeapps';

const plannerProps = useCADataversePlanner({
  service: ProjectsService as any,
  idColumn: 'cr1a3_projectid',
  schema: {
    idField:        { fieldName: 'cr1a3_projectid' },
    titleField:     { fieldName: 'cr1a3_title' },
    startDateField: { fieldName: 'cr1a3_startdate' },
    endDateField:   { fieldName: 'cr1a3_enddate' },
    groupField:     { fieldName: 'cr1a3_department' },
  },
  startDate: new Date(2026, 0, 1),
  endDate:   new Date(2026, 11, 31),
});

return <Planner {...plannerProps} viewBy={ViewBy.month} periodCount={PeriodCount.one} />;