Powerapps named formula. Error on app startup
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":
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?