Skip to main content

Notifications

Power Automate - Using Flows
Suggested answer

my html table doesn't send in my email (from a filter array)

Posted on by 2
Hello,
 
Can you help me, my flow doesn't work
 
I have datas look like : 
 
Identifier Name, First Name Date IN OUT Reason EMAIL
1234 Unknown One 10/05/24     Not here managerone@manager.com
1234 Unknown One 17/05/24     Not here managerone@manager.com
12 Unknwon Two 01/06/24     Not here managertwo@manager.com
34 Unknown Three 13/05/23 09:00 15:00 Not respected managerthree@manager.com
34 Unknown Three 26/06/24 09:00   IN but not OUT managerthree@manager.com
56 Unknown Three 15/01/24   19:00 OUT but not IN managerfour@manager.com
 
What i try to put the data in my mails for everyone. 
 
To send a mail works. 
 
 
Select
==> From Value ("Liste rows present into a table")
==> Map MAIL = EMAIL field ("Liste rows present into a table)
 
Compose ==> Union Function from Select
 
 
Apply to each
==> Outputs from the compose
 
==> Filter array
     Value from "Liste rows present into a table"
     Email field from "Liste rows present into a table and I compare with an Output Compose (Union function)
I have no result from the output of Filter Array 
 
The next steps are OK 
 
Can you explain me what I did wrong ? What are my fields for the Filter Array steps ? 
 
 
Thank you very much
 
Greetings from Belgium
 
Lucas
 
(not sure about the categories dropdown list)
 
Categories:
  • Suggested answer
    LR-29112312-0 Profile Picture
    LR-29112312-0 2 on at
    my html table doesn't send in my email (from a filter array)
    Hello,
     
    I found it, I have to use the item function, for example items('Apply_to_each')['EMAIL']
    And in the HTML table, I did almost the same, item()['MyColunmName'] and not make any reference with "List Row..." outside the loop. 
    It takes the filter array items ;-) 
     
    Like this, it sends to all manager his list. 
     
     
  • lbendlin Profile Picture
    lbendlin 7,828 on at
    my html table doesn't send in my email (from a filter array)
    What is your expected result?  Individual emails, or a single email to all recipients?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard

Featured topics

Restore a deleted flow