Unanswered

Create a clean HTML table with multi values columns

(0) Share

Report

Posted on by THEOGABRIEL

Hi,

I've build a power app for managers in our company to request IT equipment, software, systems access for new hires in one place.

The information from the app it populating a SharePoint list.

I am trying to create an automated flow to generate an email to the right group with the relevant information only from the request.

My struggle is that some fields are multi-choice and then when I am trying to create an HTML table it comes with @odata and #Id which makes it a very messy table and hard to read.

How can I create such a table with all the values from different columns in a clean view?

Those are the columns I need to send for the General IT group for example:

IT Equipment (Multi-choice)
IT Software (Multi-choice)
Email dist lists (Single line)
Phone Queues (Single line)

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report

Re: Create a clean HTML table with multi values columns

Hello @THEOGABRIEL

You should loop through all the multi-choice values and store them in a string or array variable, and after that, use that variable when creating the csv table.

Have a look at this sample:

1) Initialize two variables to store the IT Equipment and the Items List:

2) For each SharePoint list item

3) For each IT Equipment value -> Add it to a string variable

4) After storing all the IT Equipment values for the current item, create a result item, with the title and IT equipment columns.

5) Empty the ITEquipmentList value.

6) At the end, create the CSV table using the ItemsList array.

Hope it helps!

Ferran

Was this reply helpful? Yes No
THEOGABRIEL 5 on at

Like (0)

Report

Re: Create a clean HTML table with multi values columns

@fchopo thank you so much!

Was this reply helpful? Yes No