web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / User defined functions...
Power Apps
Answered

User defined functions not working

(0) ShareShare
ReportReport
Posted on by 1,228 Moderator

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.

AmnAA_0-1714405786599.png

 

Categories:
  • Verified answer
    TuongDoan Profile Picture
    573 Moderator on at

    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!

  • AmínAA Profile Picture
    1,228 Moderator on at

    AmnAA_0-1714411832403.png

    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.

  • TuongDoan Profile Picture
    573 Moderator on at

    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!

     

  • AmínAA Profile Picture
    1,228 Moderator on at

    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 312

#3
Mohsin Ali Profile Picture

Mohsin Ali 252

Last 30 days Overall leaderboard