cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

How to Write an Expression to Get items from filter

Hi there, 

 

I'm using data from a Sharepoint List and have created a specific filter to be used for the HTML Table.

All the values in the HTML table are filtered and show up correctly on the email. The issue is the formulas that I'm using to send this email to the person identified in the Sharepoint List. By using the formula outputs('Get_items')?['body/value'][0]['EmailRecipient']?['Email'] it only sends the filtered table to one person regardless of the remaining date on the sharepoint list column Email Recipient. Please bear in mind that I can't use "Apply to each" action, as this will send repetitive emails. 

Therefore, how can I write an expression to get items from the previous filter (step: Filter using each product)?

 

 

 

power automate.jpg

 

HTML table - deleted the items on the image for data protection reasons

HTML table.png

8 REPLIES 8
abowen
Resolver I
Resolver I

Could you not use an 'Apply to each' to iterate through the array of emails? Each 'Send email' action would contain a different email address using the 'Current Item' content as the To field, no?

Hi @abowen 

I've tried the Apply to each action to send the email, but it won't send one unique email to each user identified in the column Email Recipient in the Sharepoint List, so it sends unecessary duplicate emails to the same user.

Maybe there is a way to work around this issue?

What must be unique about the email? Just names/email addresses? If so, you can make the emails unique by inserting the "Current Item" dynamic content to the Apply to each, which represents each successive item in the iteration. 

 

I might be misunderstanding you... Your "Body" dynamic content (input for the Apply to each) contains the email addresses you need to use, yeah? Just want to be sure. 

Apologies if I wasn't clear on the query above. 

So, one person should receive one email with the table filtered by Product Type and deadline.

For example, If you're the owner of specific tasks for Products A, B and C, you should receive 3 separate emails because the table (HTML) in each email should only have the relavant information for Product A (email 1), Product B (email 2) and Product C (email 3). 

Somehow, when I use "Apply to each" action and then "Send an email (V2)", some users receive the same emails duplicates and others, don't and I want to avoid that.

Apply to each 2.png 

One thing to add: by using "Apply to each" action, if the HTML table has 2 lines, it sends the same email twice, 3 lines, 3 same emails and so on...

I may be out of my depth here. I haven't worked with HTML tables yet, but my current intuition is that you should try to find the "Current Item" dynamic content and then scan through that for whatever content you need to be in the email (body or to-address) based on what row of the table you're currently at. It might help if you shared what your "Body" input for the Apply to each looks like raw. 

The issue isn't the HTML table, as the information there is filtered correctly in every email.

The issue comes when I want to add other fields/expressions using the data from the Sharepoint List.

By using the Apply to each 2, the email content is correct, it just sends duplicate emails to all the users.

Is there a way to fix that?

I didn't mean to imply the HTML table was incorrectly formatted. I mean that when you open the Dynamic content dialog in Automate inside the Apply to each, you should be able to find a Current item option, that looks like the following screenshot. That should allow you to write expressions to find the data you're looking for and send emails to the correct people with the correct content. 

abowen_0-1687445389972.png

 

Unless you suspect that your Apply to each is running too many times for some reason, then I would attempt to solve this issue using the Current item tool. 

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Top Solution Authors
Users online (5,163)