Powerapps named formula. Error on app startup

Eduardo Izzo 0 Reputation points
2024-06-14T08:42:16.0366667+00:00

Hi everybody and thanks in advance for your support.

I'm developing a powerapp application and I'm using named formula.

this is my formula code:

galleryFontSize=If(App.ActiveScreen.Size=1;8;12);;
buttonFontSize=If(App.ActiveScreen.Size=1;4;14);;
ctx_daysUntilExpiration=LookUp(skill_setting;Titolo="skill validity days";value);;

// Prende il nome del manager dalla collection Office
fn_getManager(fn_mail:Text):Text = LookUp(officeUsers;Mail=fn_mail;manager);;

// Applica la formula per calcolare il punteggio
fn_skillPoint(rate:Number;counter:Number;relevance:Number):Number = (rate*counter*relevance);;

// Calcola il punteggio totale per un utente in valore assoluto (somma di tutti gli skillPoint)
fn_userPoint(up_email:Text):Number =
Sum(
    Filter(
        AddColumns(
            SP_skill_usersSkill;
            Relevance;
            LookUp(
                SP_skillSkills;
                ID = SP_skill_usersSkill[@skill].Id;
                Relevance
            );
            'Skill Counter';
            LookUp(
                SP_skillSkills;
                ID = SP_skill_usersSkill[@skill].Id;
                'Search Counter'
            )
        );
        email.Value = up_email
    );
    fn_skillPoint(
        rate;
        'Skill Counter';
        Relevance
    )
);;
// Calcola il punteggio totale per un utente in valore assoluto data una lista di skill (somma di tutti gli skillPoint)
// strSkills è la lista di skill da considerare separati da "," ("Java","Windows","Python")
fn_userSkillPoint(up_email:Text;strSkills:Text):Number =
Sum(
    Filter(
        AddColumns(
            SP_skill_usersSkill;
            Relevance;
            LookUp(
                SP_skillSkills;
                ID = SP_skill_usersSkill[@skill].Id;
                Relevance
            );
            'Skill Counter';
            LookUp(
                SP_skillSkills;
                ID = SP_skill_usersSkill[@skill].Id;
                'Search Counter'
            )
        );
        email.Value = up_email;
        'skill'.Value in strSkills
    );
    fn_skillPoint(
        rate;
        'Skill Counter';
        Relevance
    )
);;

// Calcola il valore massimo di punti raggiungibile
fn_skillsTotalPoint():Number =
Sum(
    SP_skillSkills;
    fn_skillPoint(
        5;
        'Search Counter';
        Relevance
    )
);;
// Calcola il valore massimo di punti raggiungibile data una lista di Skill.
// strSkills è la lista di skill da considerare separati da "," ("Java","Windows","Python")
fn_skillsPoint(strSkills:Text):Number =
Sum(
    Filter(
    SP_skillSkills;
    Titolo in strSkills); 
    fn_skillPoint(
        5;
        'Search Counter';
        Relevance
    )
);;

// converte il livello di conoscenza linguistico in valore numerico
fn_cefr2number(strLevel:Text):Number =
Switch(
    strLevel;
    "A1"; 1;
    "A2"; 2;
    "B1"; 3;
    "B2"; 4;
    "C1"; 5;
    "C2"; 6
);;

fn_SetLangMsg(colName:Text):Text =
Concat(
    'CM.languagesLevels';
    Concatenate(
        "<br><b>";
        ThisRecord.Titolo;
        "</b>:";
        "<br>";
        Switch(
            colName;
            "reading"; ThisRecord.reading;
            "writing"; ThisRecord.writing;
            "speaking"; ThisRecord.speaking;
            "listening"; ThisRecord.listening;
            "default"
        );
        "<br>"
    )
);;

Each time I open the editor, and also sometimes during developing, I get errors from "app verification":

User's image

To correct the error it is just enough to edit the formula and just apply a fake modification everywhere.
then i get also another error in the code where I call the named formula: "fn_userPoint". Also in this case it is just enough to re-write the name of the formula to solve the issue.

It just annoys me during development but I'm worried about when the app will be released. Could I run into problems while using the app?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,680 questions
0 comments No comments
{count} votes