Power Platform Community Forum Thread Details

Hello everyone,

I'm currently working on a Canvas App and encountering an issue with the PCF (PowerApps Component Framework) SDK. Specifically, I'm having trouble getting the SDK to return lookup values when using data-set properties.

Here are the details:

Context: I'm developing a Canvas App where I'm trying to leverage PCF to interact with lookup fields in a dataset. The values are being retrieved in Studio Mode but not in Play Mode.

Issue: The SDK does not seem to return the expected lookup values. Instead, it returns null value in the Play Mode.

Attempts to Resolve: I've double-checked the dataset schema and ensured that the lookup fields are correctly defined. I've also reviewed the official documentation but haven't found a solution to this specific issue.

const rows: Array<JSONObject> = new Array<JSONObject>();

const records = this._context.parameters.items.records

const sortedRecordsIds = this._context.parameters.items.sortedRecordIds;

sortedRecordsIds.forEach(ids => {

let gridDataSource: Record<string, any> = {} as Record<string, object>;

gridDataSource.primaryId = ids;

this._context.parameters.items.columns.forEach(c => {

const rec = records[ids].getValue(c.name);

const rec1 = records[ids].getFormattedValue(c.name);

gridDataSource = { ...gridDataSource, [c.name]: rec, [`${c.name}-f`]: rec1 };

})

rows.push({ ...gridDataSource });