Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

(0) ShareShare
ReportReport
Posted on by

I tried multiple ways to do this and I cannot figure out how to just get the date.

 

1. substring(item()?['publishDate'], 0, 10)

2. formatDateTime(coalesce(item()?['publishDate'], utcNow()), 'MM-dd-yyyy')

3. formatDateTime(item()?['publishDate'], 'MM-dd-yyyy')

 

wherdzik_0-1709308728339.png

PVA Return:

wherdzik_1-1709308833134.png

 

 

  • wherdzik Profile Picture
    on at
    Re: RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

    Yes, you are 100% correct.  Thank you for your solution. 

  • Nived_Nambiar Profile Picture
    17,911 Super User 2025 Season 1 on at
    Re: RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

    Hi @wherdzik 

     

    so RSS2 has updated date format right ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • wherdzik Profile Picture
    on at
    Re: RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

    Ok, I see what is happening. Defiantly my error.  The flow that I changed was Beckers FTE RSS.  The output variable is RSS2 and I am passing it to Message box as RSS which is the wrong variable.  Hmmm...Maybe I should just just create two distinct topics out of this as I don't know how to get to give me a dynamic output distinguishing between RSS and RSS2

     

    wherdzik_0-1709313902149.png

     

  • Nived_Nambiar Profile Picture
    17,911 Super User 2025 Season 1 on at
    Re: RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

    Hi @wherdzik 

     

    When you look at run results, in the variable where you are adding the details to be posted in PVA, does that have date time format having date only or it looks same that as of in PVA ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • wherdzik Profile Picture
    on at
    Re: RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

    Does not seem to be working.

     

    wherdzik_0-1709313252434.png

    formatDateTime(items('Apply_to_each')?['publishDate'], 'yyyy-MM-dd')

     

  • Verified answer
    Nived_Nambiar Profile Picture
    17,911 Super User 2025 Season 1 on at
    Re: RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

    Hi @wherdzik 

     

    3rd option which you shared would work actually, could you try this updated one ?

     

    formatDateTime(items('Apply_to_each')?['publishDate'], 'yyyy-MM-dd')

     

    Let me know if it works or not 

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. 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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1