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.
Issue: The SDK does not seem to return the expected lookup values. Instead, it returns null value.
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 });
        });
        console.log("rows", rows);
        return;

Using this code to get values from Data-set property.

Has anyone else encountered this problem? Are there any workarounds or specific configurations needed to get lookup values through the PCF SDK in a Canvas App?

Any help or guidance would be greatly appreciated!

Thanks in advance!

Quick Links