Power Platform Community Forum Thread Details

Thank you for your reply.

I want to create a component to export the data of the datatable component via PowerApps component framework .

Here is my custom code. But I don't know how to export a file in getOutputs method.

Could you give me some sample code?

import { IInputs, IOutputs } from "./generated/ManifestTypes";

export class ExportExcelComponent implements ComponentFramework.StandardControl<IInputs, IOutputs> {
	// PCF framework context, "Input Properties" containing the parameters, control metadata and interface functions.
	private _context: ComponentFramework.Context<IInputs>;

	// PCF framework delegate which will be assigned to this object which would be called whenever any update happens. 
	private _notifyOutputChanged: () => void;

	// Control's container
	private controlContainer: HTMLDivElement;

	// button element created as part of this control
	private exportButton: HTMLButtonElement;

	// label element created as part of this control
	private errorLabelElement: HTMLLabelElement;
	/**
	 * Empty constructor.
	 */
	constructor() {

	}

	/**
	 * Used to initialize the control instance. Controls can kick off remote server calls and other initialization actions here.
	 * Data-set values are not initialized here, use updateView.
	 * @param context The entire property bag available to control via Context Object; It contains values as set up by the customizer mapped to property names defined in the manifest, as well as utility functions.
	 * @param notifyOutputChanged A callback method to alert the framework that the control has new outputs ready to be retrieved asynchronously.
	 * @param state A piece of data that persists in one session for a single user. Can be set at any point in a controls life cycle by calling 'setControlState' in the Mode interface.
	 * @param container If a control is marked control-type='standard', it will receive an empty div element within which it can render its content.
	 */
	public init(context: ComponentFramework.Context<IInputs>, notifyOutputChanged: () => void, state: ComponentFramework.Dictionary, container: HTMLDivElement) {
		// Add control initialization code
		this._context = context;
		this._notifyOutputChanged = notifyOutputChanged;
		this.controlContainer = document.createElement("div");

		//Create an upload button to call the forms recognizer api
		this.exportButton = document.createElement("button");

		// Get the localized string from localized string 
		this.exportButton.innerHTML = context.resources.getString("PCF_FormsRecognizerControl_Recognize_ButtonLabel");
		this.exportButton.addEventListener("click", this.onExportButtonClick.bind(this));

		// Create an error label element
		this.errorLabelElement = document.createElement("label");
		this.errorLabelElement.setAttribute("id", "lblError");

		// Adding the label and button created to the container DIV.
		this.controlContainer.appendChild(this.exportButton);
		this.controlContainer.appendChild(this.errorLabelElement);
		container.appendChild(this.controlContainer);
	}

	/**
	* This button event handler will allow the user to pick the file from the device
	* Export the results searched by end-user to excel file
	* @param event click event
	*/
	private onExportButtonClick(event: Event): void {
			$.ajax({
				method: "POST",
				url: "https://formsrecognizerpcf.cognitiveservices.azure.com/formrecognizer/v1.0-preview/custom/train",
				data: "",
				beforeSend: function(xhr) {
					xhr.setRequestHeader("Ocp-Apim-Subscription-Key", "dc2e05751ac1505b");
					xhr.setRequestHeader("Content-Type", "application/json");
				}
			});		
	}
	/**
	 * Called when any value in the property bag has changed. This includes field values, data-sets, global values such as container height and width, offline status, control metadata values such as label, visible, etc.
	 * @param context The entire property bag available to control via Context Object; It contains values as set up by the customizer mapped to names defined in the manifest, as well as utility functions
	 */
	public updateView(context: ComponentFramework.Context<IInputs>): void {
	// Add code to update control view
}

	/** 
	 * It is called by the framework prior to a control receiving new data. 
	 * @returns an object based on nomenclature defined in manifest, expecting object[s] for property marked as “bound” or “output”
	 */
	public getOutputs(): IOutputs {
	return {};
}

	/** 
	 * Called when the control is to be removed from the DOM tree. Controls should use this call for cleanup.
	 * i.e. cancelling any pending remote calls, removing listeners, etc.
	 */
	public destroy(): void {
	// Add code to cleanup control if necessary
}
}