Answered

Exctract month name from date field in powerapps

(1) Share

Report

Posted on by Ghada Mehrez

257

Please I have a month field which I need it to trigger date field and filled automatically, I used this formula but it is not working, any suggestion how to solve this:

Spoiler (Highlight to read)

= VALUE( MONTH_DataCard3( [Date_DataCard1] ))

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (10)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @gme-eg

To extract the month name from a date type field, you can use the expression as:

If the date is shown on a edit form having the control Date_DataCard1, then use the expression:
Text(Date_DataCard1.SelectedDate,"mmmm")

If you want to retrieve directly from the datasource you can use the expression as:
Text(ThisItem.DateColumnName,"mmmm") -> If inside a gallery or edit form.

Text(LookUp(DataSourceName, Col1 = "Value1").DateColumnName,"mmmm") -> If you want to extract it from the record directly.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report
Copy link

Link copied!

@yashag2255 Thanks a lot I tried but it is not working could you advise what is missing here:

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hey @gme-eg

The issue here is that you are trying to reference the datacard instead of the date picker control. Follow the below steps:

1) Select the date picker inside the datacard and note down the name of control, which is something like: DataCardValue12

2) Pass this control inside the formula

Text(DataCardValue12.SelectedDate,"mmmm")

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report
Copy link

Link copied!

@yashag2255 thanks a lot that's exactly what I need but the formula is not working please see below.

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

Like (2)

Report
Copy link

Link copied!

Try this:

Text(DateTimeValue(Parent.Default), "[$-en-US]mmmm")

You can also substitute your data source for Parent.Default

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report
Copy link

Link copied!

unfortunately this is not working, thanks

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

Like (0)

Report
Copy link

Link copied!

I think I see the problem now. You're trying to take a date selected on a page that hasn't been committed and then use that value to drive the behavior of another field to display the month, is that correct?

I tried to replicate your config as best I can. Date1 is a datetime dropdown I can populate. Date2 is going to display the month name.

in Date2 I set:
DefaultDate to <datevalue on date1>.selecteddate (for you I think this is datacardvalue7.selecteddate)
then I set format to "mmmm"

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi @gme-eg

You are seeing this error because Combobox expects its DefaultSelectedItems to be an array but in this case you are passing a text. This error can be removed using:

[Text(DataCardValue7.SelectedDate,"mmmm")]

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report
Copy link

Link copied!

@yashag2255 thanks a lot it works pretty good

Was this reply helpful? Yes No
PrachiM 23 on at

Like (0)

Report
Copy link

Link copied!
Please try the code:
Text(DateValue(<DateControl>),"mmmm")
This will first convert to Date Format, then extract only month from the Date.

Was this reply helpful? Yes No