Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1qsA6jg01ecg8ed0yA0g00
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,101 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,101 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,101 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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 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…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 459 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 193

#3
stampcoin Profile Picture

stampcoin 166

Overall leaderboard
Loading started