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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Hassan_SZ_365 542 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!

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