Append columns with checkbox and dollar value to html table

(1) Share

Report

Posted on by Safriguy

Hi all,

I am 90% complete with a flow and am currently stuck on an issue.

Below is my flow:

The steps are as follows:

scheduled flow which runs a query against a PowerBi dataset
- Columns are: Job name, Director, Manager, Date, Client Type, % Billed, Fees
CSV is created from above output
File is created on sharepoint
File content is retrieved
CSV is parsed using Encodian
JSON is parsed
Variable called 'FilteredManager' is created'
Apply to each loops through JSON output and looks for a specific 'Manager'
If manager is found in the 'Manager' column, the row with all the relevant details is added to the FilteredManager array
At the end of the process, all of the rows which belong to the 'Manager' are used to create a HTML table
There is some CSS added to tidy up the design
An email sent with said table

What I am having trouble with is this - I want to append two (2) additional columns to the HTML table that is emailed.

the first column should have a check box (for each row) with the heading 'Close Job?'
the second column should accept a dollar value with the heading 'Increase budget to'

The CSV file is created based on the query from the PowerBI dataset:

This will all them be emailed to the manager, at which time they can see the table which has information specific to them, and then select to either

close the job by checking the checkbox; or
increase the budget by entering a dollar amount

They can then send this on to a different team member.

Any help with this is greatly appreciated!

Categories:

Business Process Flows

All responses (6)

Answers (1)

Safriguy 12 on at

Like (1)

Report

Re: Append columns with checkbox and dollar value to html table

Thanks @Chriddle. All hugely helpful. Appreciate you taking the time to come back to me.
Verified answer

Chriddle 7,791 Super User 2025 Season 1 on at

Like (1)

Report
Re: Append columns with checkbox and dollar value to html table

As already mentioned, HTML inputs in emails do not work well.

But you can add a placeholder in your mail and ask the recipient to insert their data there in the reply.

This shows how to filter your data and create an according HTML table:

Compose with some test data

[ { "Key0": "Value00", "Key1": "Value01", "Key2": "Value02" }, { "Key0": "Value10", "Key1": "Value11", "Key2": "Manager" }, { "Key0": "Value20", "Key1": "Value21", "Key2": "Manager" } ]

Filter array

From

outputs('Compose')

Filter

item()['Key2']

is equal to

Manager

Create HTML table

From

body('Filter_array')

Values

item()?['Key0']
item()?['Key1']
item()?['Key2']
string('[ ]')
string('[ ]')

The resulting email looks loke this:

Just ask the recipients to reply with writing their data between the brackets.

Other Ideas:

Create (and send) an Excel file each

Create one Sharepoint list and send a link to the filtered list.

Use Team's "Adaptive Card"
Safriguy 12 on at

Like (1)

Report
Re: Append columns with checkbox and dollar value to html table

Thanks. I will try that.

My real issue is this:
I want to append two (2) additional columns to the HTML table that is emailed.
the first column should have a check box (for each row) with the heading 'Close Job?'
the second column should accept a dollar value with the heading 'Increase budget to'
Any suggestions or alternative solutions to implement a solution like this?
Chriddle 7,791 Super User 2025 Season 1 on at

Like (1)

Report

Re: Append columns with checkbox and dollar value to html table

Just use the "Filter" action on the JSON from PowerBi and filter for the Manager.

With this create the HTML table.
Safriguy 12 on at

Like (1)

Report

Re: Append columns with checkbox and dollar value to html table

Hi @Chriddle,

Thanks for your reply.

Appreciate this may not be the most efficient way to achieve this, hence the request for assistance.

What would you suggest would be the best approach?
Chriddle 7,791 Super User 2025 Season 1 on at

Like (1)

Report

Re: Append columns with checkbox and dollar value to html table

Do I understand correctly, you first get a JSON from PowerBi, convert it to CSV, then convert it back to JSON again?

Why are you doing this?

Then you loop over all the items instead of simply using a filter action?

To answer your question: as far as I know, the "Create HTML table" action encodes all the HTML in your values, so you have to create the table HTML yourself (e.g. inside a Select).

I assume you want the email recipient to add data to the table and submit that data from the email.

That will be your next hurdle.

While this might work with certain email clients, I don't think this is an appropriate way to handle it.