Answered

Custom columns in HTML table create unwanted "Apply to each" which ruins the flow

(0) Share

Report

Posted on by JoannaW

I Have a flow which groups Sharepoint list items per email and then will send email. I have managed to group items per email and create HTML table which then is sent. I tried to format the table by using custom columns but when I start doing it "Apply to each" is automatically created which loops the action and user gets numerous email instead of one with grouped items.

Is there any other way I can just delete unwanted columns after creating HTML table?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you able to post a screenshot(s) of your flow to see how it's currently setup and what you are using for the HTML Table?

Was this reply helpful? Yes No
JoannaW 28 on at

Like (0)

Report
Copy link

Link copied!

Sure, here it is.
1. Get items Sharepoint list
2. Then Select - mapping email:
3. Compose - getting unique emails, expression is:
union(body('Select_-_get_emails'),body('Select_-_get_emails'))
4. Filter array&create HTML table. Output is from Compose action.
Value for filter array is: items('Apply_to_each')?['COEsemail']
Body in create HTML table is from Filter array.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

Everything looks fine to me. Not sure why you would get another loop when you go to use custom columns in the Create HTML table unless you're using fields directly from the Get items action instead of the Filter array.

Another option to just have the columns you want in the HTML table is to use a Select after the Filter array (using the Filter array fields as the values). Then use Create HTML table using the Select output (which only has the columns you want).

Was this reply helpful? Yes No
JoannaW 28 on at

Like (0)

Report
Copy link

Link copied!

From filter array I only have "Body" or "Item" available in dynamic content, not the exact fields I need:

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
For the value you can just use the expression below to get each field value:
item()?['NAME_OF_COLUMN']
Example: I wanted to get the Title of the item and the COEs Display Name (assuming your field is called COE) you could use the following:
item()?['Title'] item()?['COE/DisplayName']
To see all the actual field names, you can look at the output of your Filter array.

Was this reply helpful? Yes No
JoannaW 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot @grantjenkins !!

Was this reply helpful? Yes No