Syntax error

Like (0) Share

Report

Posted on 19 Apr 2023 08:52:46 by Flejoyeux

I am tryng to queue multiple commands in a screen to

- create a collection

- set a function to replace accentuated characters

I found this formula via Bing new conversation search tool (mind comma are replaced by semicolumn beacause french devpt interface)

Trouble is PowerApps keeps telling that it doesn't recognize StrText and so Substitute as an invalid argument

Is there something more to do to make PowerApps accepting the variable StrText ?

Set(MyFunctions; {RemoveFrenchAccents: Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(StrText;"é"; "e");"è"; "e");"ê"; "e");"ë"; "e");"à"; "a");"â"; "a");"ô"; "o");"ù";"u");"û"; "u");"î"; "i");"ç"; "c")});

Categories:

General Questions

All responses (7)

Answers (1)

Flejoyeux 69 on 20 Apr 2023 at 15:50:25

Like (1)

Report

Re: Syntax error

Another problem Fixed : in a French development Environment, Commands are to be separated by a double semicolumn ";;" !
Flejoyeux 69 on 19 Apr 2023 at 13:41:00

Like (0)

Report

Re: Syntax error

Hi
The idea is to use the function with any string
Declaring the Variable on the OnStart properties works
RobHajj98 496 on 19 Apr 2023 at 13:11:28

Like (0)

Report
Re: Syntax error

Hey @Flejoyeux ,
Set(MyFunctions, {RemoveFrenchAccents: Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute( "vidéo","é", "e"),"è", "e"),"ê", "e"),"ë", "e"),"à", "a"),"â", "a"),"ô", "o"),"ù","u"),"û", "u"),"î", "i"),"ç", "c")})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on 19 Apr 2023 at 12:45:11

Like (1)

Report

Re: Syntax error

Hi @Flejoyeux ,
Apologies, please use below formula in OnStart property of App -
Set(StrText ; "")
You can also use text input control name instead of using a variable - TextInput1.Text in place of variable.
Flejoyeux 69 on 19 Apr 2023 at 11:51:41

Like (0)

Report

Re: Syntax error

Hi
I plan to use the function to relace all accents from strings coming for a Text Field and a Text Column in order to be able to filter, for example "Video" if it is either entered as "vidéo", "Video", 'video" or "Vidéo" in either of the text field (search box) or the records

Your solution seems to work for the Function declaration but there still an error in the OnVisible parameter of the Screen part wich is generated by the semicolumn at the end of the formula settings

is the syntax to queue command different in a French environnement ?

Set(MyFunctions; {RemoveFrenchAccents: Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(Substitute(StrText;"é"; "e");"è"; "e");"ê"; "e");"ë"; "e");"à"; "a");"â"; "a");"ô"; "o");"ù";"u");"û"; "u");"î"; "i");"ç"; "c")});
ClearCollect(BoiteaOutils;Documents)
NandiniBhagya20 4,667 Super User 2024 Season 1 on 19 Apr 2023 at 11:19:12

Like (0)

Report

Re: Syntax error

Hi @Flejoyeux ,
Can you please let me what value you are setting in "StrText" variable and where are you adding the formula to set value to "StrText" variable.
You can set StrText OnStart to blank - Set(StrText,"") and try running OnStart function.
Flejoyeux 69 on 19 Apr 2023 at 09:08:44

Like (0)

Report

Re: Syntax error

A screen capture of the error displayed
I seems that the StrTexte name is not automatically recognized as a local variable as it should