I want to run an =if type function based on the subject so that the new line updates the correct column i.e. server x failed or succeeded or if server y failed or succeeded. Anything helps thank you!
Sorry but I don't quite understand what you need. Could you please explain further so that I can try to help you?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
I get notifications from a monitoring service about several servers and the subject line is Server X is failed (or succeeded). I want to have a spreadsheet update every-time I get a notification and have it update the corresponding column. Server A failed so its updates the server A column or server B failed so it updates the server B column I currently have a flow that sends flagged emails to a teams channel and I update the spreadsheet manually currently
If I understand correctly you'll want to use a conditional branch (Subject is equal to ___ if the subject lines are constant or Subject Contains ____ If they can be slightly different) that determines what gets updated. Otherwise use expressions =IF(CONTAINS([Subject],'server x')...) or =IF(EQUALS([Subject],'server x')...).
Hope that helps 🙂
Thank you, I was not aware that you could nest triggers like that, is the language the same as excel? if so I will need to use a wildcard statement =IF(CONTAINS([Subject],'*server x*'))
I have it both ways, hopefully it will be a few days before the flow is tested
The language is close to excel but not quite. Using the Contains function is the equivalent of equals with wildcards in excel. Where a similar excel statement would use operators and wildcards =If([Obj1]="*[Obj2]*",...) M simplifies to If(Contains([Obj1],[Obj2]),...). I ran into the same thing when getting started in the PowerApps platform for being much more familiar with excel. I find the expression builder very helpful, as it will lay out suggested syntax as you call the function:
Hi @Anonymous ,
Have you had an opportunity to apply @Grayden 's recommendations to adapt your Flow?
Please take a try.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.