Answered

Dataverse "List rows" to "HTML Table" in powerautomate

Like (0) Share

Report

Posted on 29 Nov 2022 08:07:25 by Community Power Pla...

Hi Guys,

I am trying to get list of rows from dataverse in powerautomate and the putting those values in HTML table within automate itself.
The final Outcome is giving me GUID's of all the columns (values).

How can i convert the GUID's back into the same value that is available in dataverse table.

Categories:

Connecting to Data

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on 29 Nov 2022 at 15:06:17

Like (3)

Report

Re: Dataverse "List rows" to "HTML Table" in powerautomate

Hi,
I found a solution for the same.
>Select list row's in powerautomate and run once with all data(zero filter). Go into the successfully ran flow and and expand the list rows.Select raw output and search for specific column/data. Use the column name matching your requirement.

>In HTML table custom column text use dynamic >expressions> item()?['column_name_from_expand_rawdata']

Was this reply helpful? Yes No
Sundeep_Malik 6,482 on 29 Nov 2022 at 08:16:46

Like (0)

Report

Re: Dataverse "List rows" to "HTML Table" in powerautomate

Hey @Anonymous

Not sure the following link would help or not. But I think this what you are looking for...
https://www.ameyholden.com/articles/expand-query-lookups-power-automate

Was this reply helpful? Yes No