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

Community site session details

Session Id : mso+ZqQeRQ4xcGCl1VTpuT
Power Automate - Building Flows
Unanswered

New Flow - Sending Birthday Emails

Like (0) ShareShare
ReportReport
Posted on 14 Feb 2023 14:48:25 by 2

Hi All,

 

I'm new to PA and I'm trying to create a flow. My flow has following steps:

 

AK1904_1-1676385768541.png

 

I'm fetching all the rows from Excel and then Splitting (Split (items('Apply_to_each')?['Birthday'],'-') from my dates which are in the format "24-07-2023"

 

AK1904_4-1676386029893.png

 

Then I'm using concat(outputs('Compose')[0],'-',Outputs('Compose')[1]) and  formatDateTime(utcNow(),'dd-MM')

 

AK1904_3-1676386007039.png

 

But when I run this flow I get the below error. The tutorial I saw had the same setup. So maybe I'm missing something here.

 

AK1904_0-1676385693993.png

 

 

I really appreciate your time and guidance on this.

 

I have the same question (0)
  • Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 14 Feb 2023 at 15:37:23
    Re: New Flow - Sending Birthday Emails

    Hi @AK1904,

     

    It looks like your datetime values are in the Serial number format. Can you change it to the ISO format instead?

     

    isoformat.png

     

    In a filter array you could use the below formatting

    @equals(formatdateTime(item()['Birthday'], 'dd-MM'), utcNow('dd-MM'))

     

    isoformat_filterarray.png

  • AK1904 Profile Picture
    2 on 14 Feb 2023 at 15:20:49
    Re: New Flow - Sending Birthday Emails

    Hi @Expiscornovus 

     

    Thanks for your response. My output looks like this.

     

    {"statusCode":200,"headers":{"Cache-Control":"no-store, no-cache","Pragma":"no-cache","Transfer-Encoding":"chunked","Vary":"Accept-Encoding","x-ms-request-id":"a933ba19-8c16-4f98-abf6-68b545cb665e;eda2ca41-20f9-4a58-a226-02cdc3fda96a;e56a9433-9899-458c-b2e6-351696d8553e;da8f64c0-076e-4b5b-8532-afe436835d32","OData-Version":"4.0","Strict-Transport-Security":"max-age=31536000; includeSubDomains","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"false","Date":"Tue, 14 Feb 2023 15:17:39 GMT","Content-Type":"application/json; odata.metadata=minimal; odata.streaming=true","Expires":"-1"},"body":{"@odata.context":"https://excelonline-wcus.azconn-wcus.p.azurewebsites.net/$metadata#drives('b%210CJNgRDshUajU7PbHpzGLQliQNe0a1FEnjhz3vIL21HA7jRWtRq4SYkhnfUy7Qda')/Files('01PVFVX5OQA2OFN4ZTKBCJYCJTXZYY4TBL')/Tables('%7B21AEADD4-46DB-40D0-A47C-173A1F6FA150%7D')/items","value":[{"@odata.etag":"","ItemInternalId":"179da3bc-c0bb-4f21-b0ec-55239a079542","Name":"Alekhya","Birthday":"45081","Anniversary":"N/A","Org Anniversary":"45272","DOB":"45081"},{"@odata.etag":"","ItemInternalId":"aaac2664-5751-44c8-8cf8-90df9f839141","Name":"Amit Dhebe","Birthday":"44971","Anniversary":"45023","Org Anniversary":"44981","DOB":"44971"},{"@odata.etag":"","ItemInternalId":"6431a74d-f0ee-4fce-a532-35f0ef8f17a7","Name":"Ankit Kukreja","Birthday":"45035","Anniversary":"45251","Org Anniversary":"44988","DOB":"45035"},{"@odata.etag":"","ItemInternalId":"f23cea74-7c2d-4e7c-bc4e-47560cba96cf","Name":"Ankit Puniyani","Birthday":"45115","Anniversary":"45210","Org Anniversary":"45063","DOB":"45115"},{"@odata.etag":"","ItemInternalId":"3d36ea8c-050c-4ca1-8c31-c4f0455cd32e","Name":"Anusha","Birthday":"44996","Anniversary":"N/A","Org Anniversary":"45074","DOB":"44996"},{"@odata.etag":"","ItemInternalId":"58aa9f01-b469-437e-a48b-f138f2728346","Name":"Harshika","Birthday":"45232","Anniversary":"N/A","Org Anniversary":"45274","DOB":"45232"},{"@odata.etag":"","ItemInternalId":"99171f74-7440-4dbe-87d3-5ac311011109","Name":"Harshini Vankadari","Birthday":"45110","Anniversary":"45159","Org Anniversary":"44954","DOB":"45110"},{"@odata.etag":"","ItemInternalId":"8ae6287b-fdf5-48f6-89c5-72b6aa47fe34","Name":"Hema","Birthday":"45131","Anniversary":"45059","Org Anniversary":"45280","DOB":"45131"},{"@odata.etag":"","ItemInternalId":"5f89c1b7-c9c1-4852-b4de-433409f73760","Name":"Keerthana Ganji","Birthday":"45009","Anniversary":"N/A","Org Anniversary":"45172","DOB":"45009"},{"@odata.etag":"","ItemInternalId":"eccb0e1e-a14b-4a06-bbbf-9a602bbfe194","Name":"Lavanya","Birthday":"45261","Anniversary":"N/A","Org Anniversary":"45233","DOB":"45261"},{"@odata.etag":"","ItemInternalId":"adc0171f-5c1b-426d-b38a-174772cbda18","Name":"Madhavi","Birthday":"45259","Anniversary":"45038","Org Anniversary":"45191","DOB":"45259"},{"@odata.etag":"","ItemInternalId":"9ceca933-a02f-4433-bcac-bb5c74271e69","Name":"Mohan ","Birthday":"44997","Anniversary":"NA","Org Anniversary":"","DOB":"44997"},{"@odata.etag":"","ItemInternalId":"9adb3366-1c70-4946-9b30-b8754828d5e4","Name":"Nadeem","Birthday":"45271","Anniversary":"45131","Org Anniversary":"44950","DOB":"45271"},{"@odata.etag":"","ItemInternalId":"97422afb-fb7d-40b2-b28a-04bc97669816","Name":"Prajukta Rath","Birthday":"44951","Anniversary":"3rd July","Org Anniversary":"24th May","DOB":"44951"},{"@odata.etag":"","ItemInternalId":"193fa855-8e2f-4f6a-9024-7e9505a2a0ec","Name":"Rohit Kumar","Birthday":"45144","Anniversary":"N/A","Org Anniversary":"45160","DOB":"45144"},{"@odata.etag":"","ItemInternalId":"6ef885a2-5378-4a5f-843a-159f5b9626aa","Name":"Sai Kumar","Birthday":"45225","Anniversary":"N/A","Org Anniversary":"45136","DOB":"45225"},{"@odata.etag":"","ItemInternalId":"e51ad3a7-3aed-40ed-b792-fef64af810f6","Name":"Sathvik","Birthday":"44937","Anniversary":"N/A","Org Anniversary":"45172","DOB":"44937"},{"@odata.etag":"","ItemInternalId":"093e6244-ef27-4b0d-99c0-8526f55118df","Name":"Shailaja Kottiyada","Birthday":"45264","Anniversary":"N/A","Org Anniversary":"10th March","DOB":"45264"},{"@odata.etag":"","ItemInternalId":"9d7f4b51-a136-41af-8d95-76f7411736d7","Name":"Sindhu Kommuri","Birthday":"44946","Anniversary":"N/A","Org Anniversary":"28th May","DOB":"44946"},{"@odata.etag":"","ItemInternalId":"c31af04c-6589-4bec-99ba-473a14c84c8f","Name":"Sravanthi","Birthday":"45194","Anniversary":"NA","Org Anniversary":"19th Aug","DOB":"45194"},{"@odata.etag":"","ItemInternalId":"a0c4030a-3945-49b7-b3c8-7e8fd9aba699","Name":"Veena ","Birthday":"45008","Anniversary":"5th Apr","Org Anniversary":"8th Jul","DOB":"45008"},{"@odata.etag":"","ItemInternalId":"54f22e8d-4c8d-4a44-a0e7-18281aad286a","Name":"Zeba Patel","Birthday":"45209","Anniversary":"N/A","Org Anniversary":"44433","DOB":"45209"}]}}

  • Expiscornovus Profile Picture
    32,205 Most Valuable Professional on 14 Feb 2023 at 15:02:32
    Re: New Flow - Sending Birthday Emails

    Hi @AK1904,

     

    Can you double check the outputs of your Compose action in the failed flow run? The error suggests that it is unable to split on the - because it has not found any instances of the - character. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2