Answered

User defined functions not working

(0) Share

Report

Posted on by AmínAA

1,228 Super User 2025 Season 2

I have been trying to get a grasp on how to use user defined functions UDF, however no matter what function I try to create, I always run into the same error. At the end of the formula it says it's wrong, since the formula expected a semicolon instead of a comma, however there is not a single comma in the entire formula. It is important to point out I am using the European notation, as well as I have an updated version of Powerapps, and enabled the New analysis engine and User defined functions features activated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

TuongDoan 573 Moderator on at

Like (2)

Report

You are using Spanish. So, when close those parentheses, you should use ";;" (double semicolon) instead of a single semi-colon.

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Was this reply helpful? Yes No
AmínAA 1,228 Super User 2025 Season 2 on at

Like (0)

Report

While using the double semicolon allows the function to work properly, it presents me with the following problem. Whatever I input after said function, including a new function, won't work properly. So the problem is only half-solved, since most of the times I would need to use various functions.

Was this reply helpful? Yes No
TuongDoan 573 Moderator on at

Like (0)

Report

Var1's data type is number. But you are trying to add text to it 😄

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Was this reply helpful? Yes No
AmínAA 1,228 Super User 2025 Season 2 on at

Like (0)

Report

I found what the problem was, I forgot you can not set vars within the Formulas. I tried creating another identical function to the one before, but with another name and it turns out it works. It seems that PowerApps just gets the errror wrong . . . Anyways, thank you for your help!

Was this reply helpful? Yes No