Power Platform Community Forum Thread Details

Hi all,

Using FetchXML, I am able to retrieve data about a particular record from various tables. The output of the FetchXML query will be a single record, with various columns. What I'm trying to do is find a way to render this data within a Power App Gallery, however, without necessarily knowing *what* the columns will be.

Essentially, my goal is to do the following:

Invoke a Power Automate flow from Power Apps, with relevant identifying information passed along.
Retrieve a record from a Dataverse table, which will contain a FetchXML query definition as well as the name of the Dataverse table that the query is being executed against, and then execute that query using the "List Rows" Dataverse call. (note - if for whatever reason the table can't be dynamic, I can probably make this work by just setting the table to a fixed value).
Return that record back to the Power App.
Somehow transform that record from a single row into a set of rows, using a Pivot operation. Essentially, create a new table with two columns, Key and Value, where Key would be the name of the original table's column, and Value would be the value in that column from the original table.

That last step is the one that I am struggling with. I've looked into options within Power Automate, as well as within Power Apps, and I can't find any convenient way to do this. Any assistance would be appreciated. Thanks!

Categories:

Building flows