Unanswered

Rename PBI query results and format for html table

(0) Share

Report

Posted on by WheelerS84

Hello Everyone!

I am working on part of cloud flow that queries a PBI dataset and puts those results into an html table and that table into the body of an email. Unfortunately naming conventions of the columns from the PBI dataset are not very user friendly. Any suggestions? I feel like this is an easy fix but I am still getting the hang of cloud flows.

For example:

query column name	what I would like to rename it
[table2name]BusinessName	Entity name
[tabl1Name]ContactNuumber	PoC Number

Thanks!

Categories:

Building flows

All responses (9)

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Use a Select action to map your fields to different names
WheelerS84 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lbendlin

Thanks for responding! I have tried that and when I do I get this same issue whether I pick row/body/first tables row as the "from" there is no field to map to that appears in the pop up menu. Am I missing something very simple? Should I try loading the results into a variable array first? I am pretty stumped here.
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Don't use body as the source. Use "First table Rows".
Notsofastmatey 8 on at

Like
a
(0)

Report
Copy link

Link copied!

This is exactly what I am trying to do as well. However, I'm not sure what values need to go in the steps. This is the output from the Power BI query:

Here's what I'm putting into the Select step:

But that just gives me this output:
Can anyone point me in the right direction?

Many thanks,

Simon
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

In your select statement you are specifying static strings. You need to reference the dynamic JSON parts instead.
Notsofastmatey 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying. Should I be able to pick up the dynamic content from the lightning bolt button? There is none available.
lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Only if you added a Parse JSON step in between. I prefer using the fx option.
Notsofastmatey 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you possibly show me what you mean, or point me at some documentation? I'm really new to this and flailing around in the dark a bit. When I add a Parse JSON step and set it up like this (using the sample payload option), I still don't get any new dynamic outputs to use in later steps.

Could you possibly show me what you mean, or point me at some documentation? I'm really new to this and flailing around in the dark a bit. When I add a Parse JSON step and set it up like this (using the sample payload option), I still don't get any new dynamic outputs to use in later steps.

I'm not sure what to then choose in the Select step. I've tried all sorts of permutations.
Thank you for your help!
Notsofastmatey 8 on at

Like
a
(0)

Report
Copy link

Link copied!

For anyone who finds this thread, I did fix it. I found this YouTube video extremely helpful - it walks you through the steps. https://youtu.be/ByIt2h5m4S0?si=ZkEKEbgIHvxR0Wq5