Apply to each

[mj07]

Hi! How can I prevent apply to each from adding and adding item list in my html table? See screenshot for output and code. Your response is highly appreciated!

[Zacharie_Cortes]

Hi @mj07 ,

If your "value" is a table, you cannot prevent the "apply to each".
I don't understand your screenchots : It is suposed to send an email with only one line. Isn't it ?

[mj07]

Hi! I want my email to be sent like this. Its like one vendor, one email result. I try adding top count and the result is this, but it only come up with one result.

[Zacharie_Cortes]

The thing is, you will get one result for each line in your get items request. 

[mj07]

Yes sir, that's what I want to achieve. Is like i got a lot of vendors so I would like to create a power automate flow that would sent a html table result per vendor.

[mj07]

My sample data, I want each vendor to have there own separate email result embedded in html table sir

[v-jefferni]

Hi @mj07 ,

I created a flow for your reference:

One question: how would you get Emails of vendors? I did not see an Email column within your list.

Best regards,

[mj07]

Hi, thanks for your response will try this out. For the email, there is column supplier email address the one I sent

[v-jefferni]

Hi @mj07 ,

OK, then logic need to be changed a bit:

Best regards,

[mj07]

hello sir, I can encounter an error. My supplier email address is just a text field

[mj07]

Hi! Just an update, it's already working properly. Question again sorry, how can I add the blue circle besides the percentage? I did try the email thing but It didn't work

[v-jefferni]

Hi @mj07 ,

The last step of my previous reply, change the column from Email to OverallPerformance could get the value.

Best regards,

[mj07]

Hi @v-jefferni ,

Same with the compose? I did same syntax I just changed email to overall performance but it did not return a value

[v-jefferni]

Hi @mj07 ,

Sorry, you need to add overall performance in Select 3 of my screenshot as well, so that in Compose can get the value.

Best regards,

[mj07]

Hi @v-jefferni 

Any field that I would be adding, i should add them on select 3 then create separate compose for it?

[v-jefferni]

You can directly use the expression that in the Compose anywhere else. Using Compose just help check if could get the value in run history.

Best regards,

[mj07]

I mean if i add another field, I’ll add them in the select 3 then i’ll create compose for it?

[v-jefferni · Accepted solution]

Add the column in Select 3 is necessary, then use the expression of Compose anywhere you want to use the value.

Best regards,

[mj07]

Hello sir @v-jefferni ,

I'm experiencing the email sent loop, I want to get all overall performance score and put it on one html table then send it all. Unfortunately, it creates table and sent it one by one