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!

All responses (9)

Answers (0)

Notsofastmatey 8 on at

Like (0)

Report

Re: Rename PBI query results and format for html table

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
Notsofastmatey 8 on at

Like (0)

Report

Re: Rename PBI query results and format for html table

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!
lbendlin 8,049 Super User 2025 Season 1 on at

Like (0)

Report

Re: Rename PBI query results and format for html table

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

Like (0)

Report

Re: Rename PBI query results and format for html table

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

Like (0)

Report

Re: Rename PBI query results and format for html table

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

Like (0)

Report

Re: Rename PBI query results and format for html table

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,049 Super User 2025 Season 1 on at

Like (0)

Report

Re: Rename PBI query results and format for html table

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

Like (0)

Report

Re: Rename PBI query results and format for html table

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,049 Super User 2025 Season 1 on at

Like (1)

Report

Re: Rename PBI query results and format for html table

Use a Select action to map your fields to different names