web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send Mail if Field get...
Power Automate
Unanswered

Send Mail if Field get specific Value

(0) ShareShare
ReportReport
Posted on by

Hello,

 

this will be my first "flow" and i struggeling with one point:

 

Task:

I would like to send a email to my, if a date from a field reaches today,

 

I cant find the trigger for this action. I only see the one if a new Element/Entry is created.

Can someone help me?

 

Thansk in advance 

 

Freiheer

Categories:
I have the same question (0)
  • v-micsh-msft Profile Picture
    on at

    Hi @Anonymous,

     

    Would you please share more details about how you would like the Flow to achieve, where is the date field stored?

    If for example, the date field is stored in a SharePoint list, and you would like to send an Email when the date reaches today, then we could just add a condition after the "When a new item is created" trigger, get the date and compare it with UTCNow().

    Besides, please also take a look at the available templates:

    SharePoint

     

    See if it would help in your scenario.

     

    Regards,

    Michael

  • Community Power Platform Member Profile Picture
    on at

    Hello,

     

    thanks for the help and sry for the missing information in the first place. The data field ist in a sharepoint list.

    The List has the Name "Beauftragung" and the field has the name "IA".

     

    But how i add the condition after the when created?

     

    Thanks in advance

  • Steffen Profile Picture
    10 on at

    If you created the list you can add a next step by a value from this list. its a simply yes or no deccision  by your selected value

     

    it should look similar like this: https://stackoverflow.com/questions/41766106/how-do-i-correctly-use-microsoft-flow-conditionals-with-a-yes-no-columnin-a-shar

  • Community Power Platform Member Profile Picture
    on at

    I did it like you explained

    Unbenannt.JPG

    But it doesnt work. 

     

    The value in the Flied "IA" is normaly reached a few days/weeks after the the item is created and without further changes. ist that still the correct start of the flow?

     

     

     

  • Community Power Platform Member Profile Picture
    on at

    I did it like you explained

    Unbenannt.JPG

    But it doesnt work. 

     

    The value in the Flied "IA" is normaly reached a few days/weeks after the the item is created and without further changes. ist that still the correct start of the flow?

     

     

     

  • Steffen Profile Picture
    10 on at

    I have nearly the same in one of my flows. I only create a liste for a onedrive directory. (btw I'm german) but i have the email part on the right part (Wenn nein) and it works ........ why ever

    Maybe its a bug. BTW did we have in Germany not UTC +1  ?

     

     

     

    ... is here an option to upload pictures? so i could make a screenshot of my flow.

  • Community Power Platform Member Profile Picture
    on at

    Hello,

     

    to get more option on replies i have startet this thread in english. But i agree, it would be easier in german. You can upload screenshots here:

    1.JPG

     

    Can you tell me, whats the formula you are using for the Condition? Because i ask there if the field "IA" is equal to UTCNow and it should then YES instead of NO, but i will try your way too.

     

    Thanks iin advance

     

     

  • Steffen Profile Picture
    10 on at

    Unfortunatly i dont have this button "Photos" for me is there only a button "insert/edit image" and i can only pickup a picture from an other server but i can't upload one.

     I export my flow in to a json - File.

     

    You simply use this and put it in a txt-file. after that rename it to ***.json and import it in your flow. Than you can see my complete flow with my settings. As you remember: i look on Monday in a special directory -> list all this files-> create an array for this listet files -> decide if there are files than write the mail if not do nothing->write email and attach all listet files and after that delete all listet files. 

    maybe this helps you a little bit

     

     

     

     

    {"$schema":"https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#","contentVersion":"1.0.0.0","parameters":{"logicAppName":{"type":"String","metadata":{"description":"Name of the logic app."}},"logicAppLocation":{"defaultValue":"[resourceGroup().location]","allowedValues":["eastasia","southeastasia","centralus","eastus","eastus2","westus","northcentralus","southcentralus","northeurope","westeurope","japanwest","japaneast","brazilsouth","australiaeast","australiasoutheast","southindia","centralindia","westindia","canadacentral","canadaeast","westcentralus","westus2","[resourceGroup().location]"],"type":"String","metadata":{"description":"Location of the logic app."}},"onedriveforbusiness_Connection_Name":{"defaultValue":"onedriveforbusiness","type":"String","metadata":{"description":"Name of the connection."}},"outlook_1_Connection_Name":{"defaultValue":"outlook_1","type":"String","metadata":{"description":"Name of the connection."}}},"resources":[{"type":"Microsoft.Logic/workflows","name":"[parameters('logicAppName')]","apiVersion":"2016-06-01","location":"[parameters('logicAppLocation')]","properties":{"state":"Disabled","definition":{"$schema":"https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#","contentVersion":"1.0.0.0","parameters":{"$connections":{"defaultValue":{},"type":"Object"},"$authentication":{"defaultValue":{},"type":"SecureObject"}},"triggers":{"Wiederholung":{"recurrence":{"frequency":"Week","interval":1,"timeZone":"W. Europe Standard Time","schedule":{"weekDays":["Monday"],"hours":["7"]}},"type":"Recurrence"}},"actions":{"Dateien_in_Ordner_auflisten":{"runAfter":{},"metadata":{"01DJ27FAZP43TXHMMXM5F3XNSE55MDYT4W":"/2018/Freigaben/Versand","flowSystemMetadata":{"swaggerOperationId":"ListFolderV2"}},"type":"ApiConnection","inputs":{"host":{"connection":{"name":"@parameters('$connections')['onedriveforbusiness']['connectionId']"}},"method":"get","path":"/datasets/default/foldersV2/@{encodeURIComponent(encodeURIComponent('01DJ27FAZP43TXHMMXM5F3XNSE55MDYT4W'))}","authentication":"@parameters('$authentication')"}},"Variable_initialisieren":{"runAfter":{"Dateien_in_Ordner_auflisten":["Succeeded"]},"type":"InitializeVariable","inputs":{"variables":[{"name":"anhangarray","type":"Array"}]}},"Auf_alle_anwenden_3":{"foreach":"@body('Dateien_in_Ordner_auflisten')?['value']","actions":{"Bedingung":{"actions":{},"runAfter":{},"else":{"actions":{"Auf_alle_anwenden":{"foreach":"@body('Dateien_in_Ordner_auflisten')?['value']","actions":{"Dateiinhalt_abrufen":{"runAfter":{},"metadata":{"flowSystemMetadata":{"swaggerOperationId":"GetFileContent"}},"type":"ApiConnection","inputs":{"host":{"connection":{"name":"@parameters('$connections')['onedriveforbusiness']['connectionId']"}},"method":"get","path":"/datasets/default/files/@{encodeURIComponent(encodeURIComponent(items('Auf_alle_anwenden')?['Id']))}/content","queries":{"inferContentType":true},"authentication":"@parameters('$authentication')"}},"An_Arrayvariable_anfügen":{"runAfter":{"Dateiinhalt_abrufen":["Succeeded"]},"type":"AppendToArrayVariable","inputs":{"name":"anhangarray","value":{"Name":"@items('Auf_alle_anwenden')?['DisplayName']","ContentBytes":"@body('Dateiinhalt_abrufen').$content"}}}},"runAfter":{},"type":"Foreach"},"E-Mail_senden_2":{"runAfter":{"Auf_alle_anwenden":["Succeeded"]},"metadata":{"flowSystemMetadata":{"swaggerOperationId":"SendEmail"}},"type":"ApiConnection","inputs":{"host":{"connection":{"name":"@parameters('$connections')['outlook_1']['connectionId']"}},"method":"post","path":"/Mail","body":{"To":"sag@ichnicht.de","Subject":"Neue Bilder 2018er","Body":"Hier steht der Text","Attachments":"@variables('anhangarray')","IsHtml":true},"authentication":"@parameters('$authentication')"}},"Auf_alle_anwenden_2":{"foreach":"@body('Dateien_in_Ordner_auflisten')?['value']","actions":{"Datei_löschen":{"runAfter":{},"metadata":{"flowSystemMetadata":{"swaggerOperationId":"DeleteFile"}},"type":"ApiConnection","inputs":{"host":{"connection":{"name":"@parameters('$connections')['onedriveforbusiness']['connectionId']"}},"method":"delete","path":"/datasets/default/files/@{encodeURIComponent(encodeURIComponent(items('Auf_alle_anwenden_2')?['Id']))}","authentication":"@parameters('$authentication')"}}},"runAfter":{"E-Mail_senden_2":["Succeeded"]},"type":"Foreach"}}},"expression":"@equals(items('Auf_alle_anwenden_3'), 0)","type":"If"}},"runAfter":{"Variable_initialisieren":["Succeeded"]},"type":"Foreach"}},"outputs":{},"description":"Dieser Flow sucht einen Ordner auf, listet die darin befindlichen Dateien auf und versendet sie. Anschließend löscht er diese Dateien."},"parameters":{"$connections":{"value":{"onedriveforbusiness":{"id":"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'onedriveforbusiness')]","connectionId":"[resourceId('Microsoft.Web/connections', parameters('onedriveforbusiness_Connection_Name'))]","connectionName":"[parameters('onedriveforbusiness_Connection_Name')]"},"outlook_1":{"id":"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'outlook_1')]","connectionId":"[resourceId('Microsoft.Web/connections', parameters('outlook_1_Connection_Name'))]","connectionName":"[parameters('outlook_1_Connection_Name')]"}}}},"runtimeConfiguration":{"collections":{"maximumItemCount":100000}}},"dependsOn":["[resourceId('Microsoft.Web/connections', parameters('onedriveforbusiness_Connection_Name'))]","[resourceId('Microsoft.Web/connections', parameters('outlook_1_Connection_Name'))]"]},{"type":"Microsoft.Web/connections","name":"[parameters('onedriveforbusiness_Connection_Name')]","apiVersion":"2016-06-01","location":"[parameters('logicAppLocation')]","properties":{"api":{"id":"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'onedriveforbusiness')]"},"displayName":"[parameters('onedriveforbusiness_Connection_Name')]"}},{"type":"Microsoft.Web/connections","name":"[parameters('outlook_1_Connection_Name')]","apiVersion":"2016-06-01","location":"[parameters('logicAppLocation')]","properties":{"api":{"id":"[concat('/subscriptions/', subscription().subscriptionId, '/providers/Microsoft.Web/locations/', parameters('logicAppLocation'), '/managedApis/', 'outlook_1')]"},"displayName":"[parameters('outlook_1_Connection_Name')]"}}]}

  • Steffen Profile Picture
    10 on at

    OK jetzt kurz in deutsch:

    schau mal da exisitert eine Vorlage bei den Flows "Pushbenachrichtigung erhalten, wenn Sie eine E-Mail von Ihrem Chef erhalten" Vielleicht kannst Du die anpassen an Deine Bedürfnisse.

    Darin geht es auch darum dass ein bestimmter Wert einer Mail abgefragt wird. Dort wird zwar dann eine Pushnachricht abgesetzt, aber das kannst Du ja entsprechend anpassen.

  • Community Power Platform Member Profile Picture
    on at

    Unfortunaly it was not possible to upload your JSON. I got every time a error with unknown reason.

     

    I will try your "german" option later. Thank you

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard