Create HTML table with lookup and choice

(0) Share

Report

Posted on by Gyllentid

892

Datasource: Dataverse

I'm getting ID and numbers in the HTML Table:

Skärmavbild 2022-01-21 kl. 14.12.39.png

Flow is:

Skärmavbild 2022-01-21 kl. 14.13.01.png

Skärmavbild 2022-01-21 kl. 14.13.07.png

I don't have windows to use FetchXML Builder to expand queries. And not sure it will be possible to get. Otherwise I could have fetched the data in the List row action.

I have looked at some guides for how to initialize array and append array but I don't understand how to apply it here or if it applies.

Wondering what I can do, or if it's a lost mission?

Attendance is a choice field, RelateCandidate and Course are both lookups to other tables.

All responses (5)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

Re: Create HTML table with lookup and choice

Hi @shavora ,

Please see the sample:

Best Regards,

Wearsky
Gyllentid 892 on at

Like (0)

Report

Re: Create HTML table with lookup and choice

That sounds interesting, can you help me how the logic is? I am able to use the Parse JSON function in the flow. And what do I do after? @v-xiaochen-msft
v-xiaochen-msft on at

Like (0)

Report

Re: Create HTML table with lookup and choice

Hi @shavora ,

You could use a json() function outside your string.

It will convert the strint to an array.

Best Regards,

Wearsky
Gyllentid 892 on at

Like (0)

Report

Re: Create HTML table with lookup and choice

But choice column remains.

I have tried today to make the table data into a string and replace 1000000 to Present. I used Compose to make it into a string. Then another compose to do the replace. All that worked, but now it's all a string and can't be used for an array for the Create an HTML table.
Gyllentid 892 on at

Like (0)

Report

Re: Create HTML table with lookup and choice

So, I managed to get help with the Expand Query and can fetch the data for the lookup columns.
If someone is trying to understand how to write queries here is what worked for me: