Hi all,
I'm working on a flow that takes email alarm messages.
here is an example "single message" email:
Thursday, 04/08/2021 at 14:14:24. The Point ANT HVAC4B.DISCH AIR is at NORMAL.
here is how it is set up:
Trigger is a new email, then i get a list of items from the sharepoint, then compare the subject of the email to branch yes is "multiple messages" no is "single message":
now - i have the same problem with multiple or single, so, i'm going to stick to single for this explanation cause it is simpler:
split on the splits the message in two at 'Point', then step1 trims it so it becomes:
ANT HVAC4B.DISCH AIR is at NORMAL.
then the compose action which i neglected to name splits that at is to give:
ANT HVAC4B.DISCH AIR
i then use the get value to compare the Title of the entry, to the output of the compose to see if the entry starts with it:
if it does, then, get the id of that entry and update the item with the step1 compose, if it does not, then create the item with the step1 compose:
in this particular case, it does match, but, as you can see from an earlier run, it had a create instead of an update and this is where things go beyond my intention: it creates a new entry for each existing list item - i just want it to create a new entry once. I think it is because of the "Apply to each 3", but, when i add the id to the "yes" branch it automatically nests it in the apply to each.
here is the output from the item that created 4 entries instead of 1:
output from the email trigger:
"receivedDateTime":"2021-04-08T19:06:46+00:00","hasAttachments":false,"internetMessageId":"<BL0PR12MB25314BB7D5C97684A4D4A2A4A8749@BL0PR12MB2531.namprd12.prod.outlook.com>","subject":"Thursday, 04/08/2021 at 09:40:18. The Point ANT CHW.CW PUMP ALARM is at NORMAL.","bodyPreview":"Thursday, 04/08/2021 at 09:40:18. The Point ANT CHW.CW PUMP ALARM is at NORMAL.","importance":"normal","conversationId":"AAQkAGJlZDM0NDk4LTUxODYtNDI0Ny1iMjM3LTRjZTgzYjA2NTE5NAAQAI2KcB07AjdFtSMmwslPAjI=","isRead":false,"isHtml":false,"body":"Thursday, 04/08/2021 at 09:40:18. The Point ANT CHW.CW PUMP ALARM is at NORMAL.\r\n\r\n\r\n","from":"IPF.SA.HVACFlow@msu.edu","toRecipients":"IPF.SA.HVACFlow@msu.edu"
so it does it 4 times, because there were 4 items in the list when it did the "apply to each 3" action.
not sure what to do differently to get it to iterate through the list (ultimately, there are likely to be hundreds of entries at any given time once this is live) but only create 1 entry, not a new item on every iteration?
i thought about relocating the get items, but, i need that to do the conditional check, so i'm not sure how i'd make that work?
any input would be great
Solved! Go to Solution.
Hi @Seuadr
I'm guessing the real problem is your expression? 1 should evaulate as false and the rest true but all 4 are evaluating as false and therefore creating a new item?
I would suggest you stick a compose in temporarily for the apply to each 3 title and see what string is output (as you cannot see this from the condition history). Then I would compare your select string and the title string with your own eye and try and spot the difference? An extra space or maybe case? You can change the case of both strings to upper or lower (ToLower or ToUpper).
Give that a go and let me know what you find.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
i'll give that a try - i now have 10 items in the list, so the next message that doesn't exist in the list will make 10 entries 😕
@DamoBird365 So i tried putting a compose between the create and updates in the apply to each and it is as i suspected, it is checking each item to see if it matches with the "title" from "get items" and if it doesn't, then it is creating it. I am pretty sure it is because it is inside the apply for each, but, if the condition is no, i do want the item to be added once, so, i'm not sure how to make it check ALL of the list items and only add it once instead of checking each list item?
so, to expand on this - my expression is "starts with" - here is a run with 2 list items.. item 1:
no match, create an item.
item 2:
match, update item.
now here is a run with 3 list items - this is a new item, so no update:
because it checked 3 items, it created 3 items. not sure how to have it check the entire list and only create 1 item?
Hi @Seuadr
I think I get you now. Instead of an apply to each, how about a filter. If the filter contains a match the length will be greater than 0. The condition is therefore based on the length rather than each item of the list.
Does that work for you?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
i'll look in to that after this power platform training. that sounds like something that makes a lot of sense.
if i am following you correctly, i'd put the get items into a filter like the data "filter array" and then have the condition do a match there?
@DamoBird365 finally got back to this - i am structuring my filter was wrong and was hoping that you could give me some input:
so my "value" from is output('Get_items')?['body/value']
the filter uses item()?['Title'] - which is the entry on the list i'm looking to filter
then starts with outputs('Compose') which is the compose action that strips it down to just the first part of the split for comparison (which is what it starts with...)
so, for my test run, my inputs from the sharepoint list are:
data.etag": "\"1\"",
"ItemInternalId": "2520",
"ID": 2520,
"Title": "ANT REF 1330 MEAT POULTRY is in Alarm at PRI3",
"Timestamp": "2021-04-12T12:00:00Z",
"Modified": "2021-04-12T12:12:54Z",
"Created": "2021-04-12T12:12:54Z",
"@odata.etag": "\"1\"",
"ItemInternalId": "2521",
"ID": 2521,
"Title": "ANT REF 1330 MEAT POULTRY is in Alarm at PRI3.",
"Timestamp": "2021-04-12T12:01:44Z",
"Modified": "2021-04-12T12:18:12Z",
"Created": "2021-04-12T12:18:12Z",
and my compose was:
ANT RM 1330.RM TEMP
but my output from the filter was:
[ ]
and since the input to the condition following for length doesn't trigger because (presumably) it has a null?
right, so if it isn't in the list, i need to create the item.
so i need to figure out how to work with that
@DamoBird365 that is what i have - but, for some reason the condition isn't triggering - i presumed it was because the array is returning [ ]
not sure what i am doing wrong?
Hi @Seuadr
Not sure if we are misunderstanding each other here but if you are now using a filter on the results, you don't need to use an apply to each to check them all? The filter will let you know if there is a match or not and so the condition and the yes no branches do not need to be in an apply to each? Why are you creating an apply to each with the body as the source?
Damien
when i add the ID from get_items it automatically nests it in an apply to each - i have to add the id to update item, so, :shrugs:
Hi @Seuadr
You will be using the dynamic content ID from the Get Items, in which case it will automatically assume an apply to each as the result is an array? If the length is greater than 0 your filter array should have the ID e.g. 2520, you can obtain this with the expression first(body('Filter_array')?['Id']), you might get away with body('Filter_array')?['Id'].
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
@DamoBird365 i am getting an error when trying to add the expression:
Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Compose_3' at line '1 and column '5795' cannot reference action 'Filter_array'. Action 'Filter_array' must either be in 'runAfter' path or within a scope action on the 'runAfter' path of action 'Compose_3', or be a Trigger.'.'.
compose_3 was the compose i put in to "see" the output of the expression before putting it in the update item.
i may be misunderstanding, but, compose 3 is under the yes of the conditional check for length, i don't understand how i could have the filter array in the run after path for that? i also can't add the expression directly to the id, nor a dynamic content from the filter array to the id.
i feel like based on your description this should be straight forward and i'm missing something?
oddly enough, i deleted it and re-added it as a new compose and now it is happy? whatever i guess 😄
Episode Fifteen of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft MVP Lewis Baybutt aka Low Code Lewis, alongside the latest news and community blogs. Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show. Action requested: Feel free to provide feedback on how we can make our community more inclusive and diverse. This episode premiers live on our YouTube at 12pm PST on Thursday 1st June 2023. Video series available at Power Platform Community YouTube channel. Upcoming events: European Power Platform conference – Jun. 20-22nd - Dublin Microsoft Power Platform Conference – Oct. 3-5th - Las Vegas Join our Communities: Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community If you’d like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions. Action requested: Feel free to provide feedback on how we can make our community more inclusive and diverse. This episode premiers live on our YouTube at 12pm PST on Thursday 1st June 2023. Video series available at Power Platform Community YouTube channel. Upcoming events: European Power Platform conference – Jun. 20-22nd - Dublin Microsoft Power Platform Conference – Oct. 3-5th - Las Vegas Join our Communities: Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community If you’d like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions.
Welcome to our May 2023 Community Newsletter, where we'll be highlighting the latest news, releases, upcoming events, and the great work of our members inside the Biz Apps communities. If you're new to this LinkedIn group, be sure to subscribe here in the News & Announcements to stay up to date with the latest news from our ever-growing membership network who "changed the way they thought about code". LATEST NEWS "Mondays at Microsoft" LIVE on LinkedIn - 8am PST - Monday 15th May - Grab your Monday morning coffee and come join Principal Program Managers Heather Cook and Karuana Gatimu for the premiere episode of "Mondays at Microsoft"! This show will kick off the launch of the new Microsoft Community LinkedIn channel and cover a whole host of hot topics from across the #PowerPlatform, #ModernWork, #Dynamics365, #AI, and everything in-between. Just click the image below to register and come join the team LIVE on Monday 15th May 2023 at 8am PST. Hope to see you there! Executive Keynote | Microsoft Customer Success Day CVP for Business Applications & Platform, Charles Lamanna, shares the latest #BusinessApplications product enhancements and updates to help customers achieve their business outcomes. S01E13 Power Platform Connections - 12pm PST - Thursday 11th May Episode Thirteen of Power Platform Connections sees Hugo Bernier take a deep dive into the mind of co-host David Warner II, alongside the reviewing the great work of Dennis Goedegebuure, Keith Atherton, Michael Megel, Cat Schneider, and more. Click below to subscribe and get notified, with David and Hugo LIVE in the YouTube chat from 12pm PST. And use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show. UPCOMING EVENTS European Power Platform Conference - early bird ticket sale ends! The European Power Platform Conference early bird ticket sale ends on Friday 12th May 2023! #EPPC23 brings together the Microsoft Power Platform Communities for three days of unrivaled days in-person learning, connections and inspiration, featuring three inspirational keynotes, six expert full-day tutorials, and over eighty-five specialist sessions, with guest speakers including April Dunnam, Dona Sarkar, Ilya Fainberg, Janet Robb, Daniel Laskewitz, Rui Santos, Jens Christian Schrøder, Marco Rocca, and many more. Deep dive into the latest product advancements as you hear from some of the brightest minds in the #PowerApps space. Click here to book your ticket today and save! DynamicMinds Conference - Slovenia - 22-24th May 2023 It's not long now until the DynamicsMinds Conference, which takes place in Slovenia on 22nd - 24th May, 2023 - where brilliant minds meet, mingle & share! This great Power Platform and Dynamics 365 Conference features a whole host of amazing speakers, including the likes of Georg Glantschnig, Dona Sarkar, Tommy Skaue, Monique Hayward, Aleksandar Totovic, Rachel Profitt, Aurélien CLERE, Ana Inés Urrutia de Souza, Luca Pellegrini, Bostjan Golob, Shannon Mullins, Elena Baeva, Ivan Ficko, Guro Faller, Vivian Voss, Andrew Bibby, Tricia Sinclair, Roger Gilchrist, Sara Lagerquist, Steve Mordue, and many more. Click here: DynamicsMinds Conference for more info on what is sure an amazing community conference covering all aspects of Power Platform and beyond. Days of Knowledge Conference in Denmark - 1-2nd June 2023 Check out 'Days of Knowledge', a Directions 4 Partners conference on 1st-2nd June in Odense, Denmark, which focuses on educating employees, sharing knowledge and upgrading Business Central professionals. This fantastic two-day conference offers a combination of training sessions and workshops - all with Business Central and related products as the main topic. There's a great list of industry experts sharing their knowledge, including Iona V., Bert Verbeek, Liza Juhlin, Douglas Romão, Carolina Edvinsson, Kim Dalsgaard Christensen, Inga Sartauskaite, Peik Bech-Andersen, Shannon Mullins, James Crowter, Mona Borksted Nielsen, Renato Fajdiga, Vivian Voss, Sven Noomen, Paulien Buskens, Andri Már Helgason, Kayleen Hannigan, Freddy Kristiansen, Signe Agerbo, Luc van Vugt, and many more. If you want to meet industry experts, gain an advantage in the SMB-market, and acquire new knowledge about Microsoft Dynamics Business Central, click here Days of Knowledge Conference in Denmark to buy your ticket today! COMMUNITY HIGHLIGHTS Check out our top Super and Community Users reaching new levels! These hardworking members are posting, answering questions, kudos, and providing top solutions in their communities. Power Apps: Super Users: @WarrenBelz, @LaurensM @BCBuizer Community Users: @Amik@ @mmollet, @Cr1t Power Automate: Super Users: @Expiscornovus , @grantjenkins, @abm Community Users: @Nived_Nambiar, @ManishSolanki Power Virtual Agents: Super Users: @Pstork1, @Expiscornovus Community Users: @JoseA, @fernandosilva, @angerfire1213 Power Pages: Super Users: @ragavanrajan Community Users: @Fubar, @Madhankumar_L,@gospa LATEST COMMUNITY BLOG ARTICLES Power Apps Community Blog Power Automate Community Blog Power Virtual Agents Community Blog Power Pages Community Blog Check out 'Using the Community' for more helpful tips and information: Power Apps , Power Automate, Power Virtual Agents, Power Pages
Super Users – 2023 Season 1 We are excited to kick off the Power Users Super User Program for 2023 - Season 1. The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts. Super User Season 1 | Contributions July 1, 2022 – December 31, 2022 Super User Season 2 | Contributions January 1, 2023 – June 30, 2023 Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile. Power Apps Power Automate Power Virtual Agents Power Pages Pstork1* Pstork1* Pstork1* OliverRodrigues BCBuizer Expiscornovus* Expiscornovus* ragavanrajan AhmedSalih grantjenkins renatoromao Mira_Ghaly* Mira_Ghaly* Sundeep_Malik* Sundeep_Malik* SudeepGhatakNZ* SudeepGhatakNZ* StretchFredrik* StretchFredrik* 365-Assist* 365-Assist* cha_cha ekarim2020 timl Hardesh15 iAm_ManCat annajhaveri SebS Rhiassuring LaurensM abm TheRobRush Ankesh_49 WiZey lbendlin Nogueira1306 Kaif_Siddique victorcp RobElliott dpoggemann srduval SBax CFernandes Roverandom schwibach Akser CraigStewart PowerRanger MichaelAnnis subsguts David_MA EricRegnier edgonzales zmansuri GeorgiosG ChrisPiasecki ryule AmDev fchopo phipps0218 tom_riha theapurva takolota Akash17 momlo BCLS776 Shuvam-rpa rampprakash ScottShearer Rusk ChristianAbata cchannon Koen5 a33ik Heartholme AaronKnox okeks Matren David_MA Alex_10 Jeff_Thorpe poweractivate Ramole DianaBirkelbach DavidZoon AJ_Z PriyankaGeethik BrianS StalinPonnusamy HamidBee CNT Anonymous_Hippo Anchov KeithAtherton alaabitar Tolu_Victor KRider sperry1625 IPC_ahaas zuurg rubin_boer cwebb365 Dorrinda G1124 Gabibalaban Manan-Malhotra jcfDaniel WarrenBelz Waegemma drrickryp GuidoPreite metsshan If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances. Once they are received the list will be updated.
We are excited to share the ‘Power Platform Communities Front Door’ experience with you! Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well. Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities. Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform. Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.
We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida. Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more. Register today: https://www.powerplatformconf.com/
User | Count |
---|---|
45 | |
33 | |
24 | |
24 | |
11 |
User | Count |
---|---|
82 | |
53 | |
40 | |
25 | |
19 |