Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 5NdbIEYdnY2N3nYzLTcrf8
Power Apps - Building Power Apps
Answered

User defined functions not working

Like (0) ShareShare
ReportReport
Posted on 29 Apr 2024 15:51:31 by 1,096 Super User 2025 Season 1

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

 

  • AmínAA Profile Picture
    1,096 Super User 2025 Season 1 on 29 Apr 2024 at 18:22:50
    Re: User defined functions not working

    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!

  • TuongDoan Profile Picture
    550 Super User 2025 Season 1 on 29 Apr 2024 at 18:11:20
    Re: User defined functions not working

    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,096 Super User 2025 Season 1 on 29 Apr 2024 at 17:47:36
    Re: User defined functions not working

    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.

  • Verified answer
    TuongDoan Profile Picture
    550 Super User 2025 Season 1 on 29 Apr 2024 at 17:24:07
    Re: User defined functions not working

    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!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 106 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 73

#3
stampcoin Profile Picture

stampcoin 52

Overall leaderboard
Loading started