Get Full Month from a Variable (to store in a Variable) to then Patch

(0) Share

Report

Posted on by CU10041356-0

Please can someone suggest how to do this in fx.

I am using Canvas Apps not a form.

I have set a variable:

Set(varNowDate, Today());

and i want to set a variable VarNowDelgatedMonth, that uses the Variable varNowDate but display the full Month name. IE. "April" not "Apr"

I want to store the Month as text in a variable VarNowDelgatedMonth.

I would then Patch the VarNowDelgatedMonth to my Sharepoint List.

I could only find an answers from using a combobox, but i just want to use a variable, not a control.

I know that "mmmm" should be part of the formula, but not sure how to structure it to work with variables as above.

Any advice/assistance greatly appreciated.

Categories:

Building Power Apps

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

MS.Ragavendar 6,616 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@CU10041356-0,

Set(

VarNowDelegatedMonth,

Text(varNowDate, "mmmm")

);

Since you mentioned new to power-apps there is an article from @mdevaney about Power apps functions you can check it

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,473 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@CU10041356-0

Set(

varNowDate,

Today()

);

Set(

varNowDelegatedMonth,

Text(

varNowDate,

"mmmm"

)

)

Rob
Los Gallardos
Microsoft Power Platform Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No
Verified answer

Power Platform Guy 134 on at

Like (1)

Report
Copy link

Link copied!

@CU10041356-0,

To get the Month - Below Power Fx can be used.

Text(Today(), "mmmm") - April

Text(Today(), "mmm") - Apr

Text(Today(), "mm") - 04

☑️Accept as Solution to help others 💙 A Like is appreciated ❓Tag @PowerPlatform Guy for any queries

Was this reply helpful? Yes No
CU10041356-0 35 on at

Like (0)

Report
Copy link

Link copied!

Thankyou so much.

That's working exactly as i needed.

Was this reply helpful? Yes No
CU10041356-0 35 on at

Like (0)

Report
Copy link

Link copied!

@MS.Ragavendar

Many thanks for the link - it is much appreciated.

Was this reply helpful? Yes No
MS.Ragavendar 6,616 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@CU10041356-0, glad it worked for you. ✅If helped, please Accept as Solution.

Was this reply helpful? Yes No