Loading

Getting MonthName in Select Data Operation in MSFlow

Shail S

I have a datetime field in sharepoint list. How can i get the monthname for the date in the select data operation. Is there a formula i can use to achieve this? Please help.

I need to create an html table and show the monthname in the table and draft an email in flow.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan7y ago
Accepted answer
Hi,
Please see, if this helps: https://flow.microsoft.com/en-us/blog/working-with-dates-and-times/
+1
Shail S7y ago
if(empty(item()?['FieldName']),'-',formatDateTime(item()?['FieldName'],'MMMM'))

Was able to get it using the above formula.
0