Creating custom function in app.formulas?

(0) Share

Report

Posted on by Koczek

Hi,

Is it possible somehow to create custom functions in app.formulas?

I tried to create one, even tried the one suggested by the help (FindMonth(d:Text):Number=Month(DateParse(d));) but PowerApps always tells that 'FindMonth' is an unknow or unsupported function.

Thanks

Adam

Categories:

Building Power Apps

PowerApps-namedfo...

I have the same question (0)

All responses (3)

Answers (0)

Hassan_SZ_365 542 on at

Like (0)

Report
Hi @Koczek ,
For transforming text to a date and extracting the month, you would use DateValue to convert text to a date, and then Month to get the month number. For example, if you have a text input named TextInput1, you could use the following on a button's OnSelect property to set a context variable:

UpdateContext({varResult: Month(DateValue(TextInput1.Text))})

This sets the context variable varResult to the month number derived from the date string in TextInput1.
Best Regards,
Hassan Raza

Was this reply helpful? Yes No
Koczek 20 on at

Like (1)

Report

Hi @Hassan_SZ_365 ,

Thanks, but the question was not about extracting Month, it was a general question if it is possible somehow to create a custom function in the App's formulas property, like you can create named formulas.
I thought it is possible as the help suggest.

Was this reply helpful? Yes No
vya 4 on at

Like (0)

Report

Hi!, there is a workaround but you need to enable the experimental feature User Defined Functions
You can see it here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Named-formula-with-arguments/m-p/2798498

Regards, Juan Antonio

Was this reply helpful? Yes No