Create HTML table with lookup and choice

(0) Share

Report

Posted on by Gyllentid

894

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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Gyllentid 894 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Gyllentid 894 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @shavora ,

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

It will convert the strint to an array.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Gyllentid 894 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @shavora ,

Please see the sample:

Best Regards,

Wearsky

Was this reply helpful? Yes No