web

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

News and Announcements icon

Power Platform CommunityForums Power Automate How to extract Year an...

Power Automate

Unanswered

How to extract Year and Month values from Date field in share point list

(0) Share

Report

Report

Posted on by Ghada Mehrez

257

Now I have a flow that syncs any new office outlook events to a SharePoint list

In the list, I have the Month and Year columns(Single text type) I would like to make them get the Year and Month values from the start date column.

I inserted Apply to each step >> Compose for Year Expression>> Compose for Moth expression as below but I got error when I run the flow.

formatDateTime(triggerOutputs()?['body/start'],'MMMM')

formatDateTime(triggerOutputs()?['body/start'],'yyyy')

2021-04-08 12_54_07-Inbox - ghada.mehrez@flsmidth.com - Outlook.png 2021-04-08 12_53_15-Inbox - ghada.mehrez@flsmidth.com - Outlook.png

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @gme-eg ,

the error tells you that the

triggerOutputs()?['body/start']

is empty (= null). It's either empty or you're not using the proper dynamic content.

Was this reply helpful? Yes No
Mari Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @gme-eg

Based on the screenshots and the explanation you shared, the Date value comes from the Get events (V4) action, so your expression should not use triggerOutputs(). Instead, you could use this in the Compose:

formatDateTime(items('Apply_to_each')?['start'],'MMMM')

Was this reply helpful? Yes No

Join the conversation