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

I have the same question (0)

All responses (9)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

Use a Select action to map your fields to different names

Was this reply helpful? Yes No
WheelerS84 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Don't use body as the source. Use "First table Rows".

Was this reply helpful? Yes No
Notsofastmatey 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Notsofastmatey 8 on at

Like (0)

Report

Thanks for replying. Should I be able to pick up the dynamic content from the lightning bolt button? There is none available.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Notsofastmatey 8 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Notsofastmatey 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No