web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows RSS Feed Format date f...

Power Automate - Building Flows

Answered

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

Like (0) Share

Report

Report

Posted on 1 Mar 2024 16:00:59 by wherdzik

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')

PVA Return:

Categories:

Business Process Flows

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (1)

wherdzik on 01 Mar 2024 at 17:32:20

Like (1)

Report

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.

Was this reply helpful? Yes No
Nived_Nambiar 18,014 Super User 2025 Season 2 on 01 Mar 2024 at 17:31:11

Like (0)

Report

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! 🙌

Was this reply helpful? Yes No
wherdzik on 01 Mar 2024 at 17:28:38

Like (0)

Report

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

Was this reply helpful? Yes No
Nived_Nambiar 18,014 Super User 2025 Season 2 on 01 Mar 2024 at 17:18:58

Like (0)

Report

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! 🙌

Was this reply helpful? Yes No
wherdzik on 01 Mar 2024 at 17:14:39

Like (0)

Report

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

Does not seem to be working.

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

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,014 Super User 2025 Season 2 on 01 Mar 2024 at 17:07:41

Like (0)

Report

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! 🙌

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 783 Super User 2025 Season 2

#2

Tomac 515 Moderator

#3

trice602 299 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans