Syntax Code error

(0) Share

Report

Posted on by Power_appsFR

Hi , i have an error on my code.

I have 2 columns, a "BUDGET" column with a drop-down list, and an "CODE_ARTICLE" column with a drop-down list.

I want to create a condition: if the "BUDGET" column = "Masse_salariale", then I want the "CODE_ARTICLE" column to display only the codes that start with "Masse salariale".

Here is my code :

If(DataCardValue1.Selected.Value = "Masse_salariale"; Filter([@'Trame budget programmes courts'].CODE_ARTICLE; StartsWith(CODE_ARTICLE.Value; "Masse salariale")); Choices([@'Trame budget programmes courts'].CODE_ARTICLE)
)

Where is the syntax mistake pls ?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ANB 7,250 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Power_appsFR , Please try this

If(DataCardValue1.Selected.Value = "Masse_salariale", Filter('Trame budget programmes courts', StartsWith(CODE_ARTICLE.Value, "Masse salariale") ), Choices('Trame budget programmes courts'.CODE_ARTICLE) )

------------------------------------------------------------------------------------------------------------------------------
I hope this helps.
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.
Thanks,
ANB

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Power_appsFR ,

Try this format

If( DataCardValue1.Selected.Value = "Masse_salariale"; ShowColumns( Filter( AddColumns( 'Trame budget programmes courts'; "Value"; CODE_ARTICLE.Value ); StartsWith( Value; "Masse salariale" ) ); "Value" ); Choices([@'Trame budget programmes courts'].CODE_ARTICLE) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Power_appsFR 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren, I've finally found the good code which works . However how can I add other possibilities (e.g : if "budget" = "transport" , so "CODE_ARTICLE" must show only codes which start by "TR" , and then with other options.

If(
DataCardValue1.Selected.Value = "Masse_salariale";
Filter(
Choices('Trame budget programmes courts'.CODE_ARTICLE);
StartsWith(
Value;
"MS"
)
);
Choices([@'Trame budget programmes courts'].CODE_ARTICLE)
)

Was this reply helpful? Yes No
Power_appsFR 10 on at

Like (1)

Report
Copy link

Link copied!

this code works :

If(
DataCardValue1.Selected.Value = "Masse_salariale";
Filter(
Choices('Trame budget programmes courts'.CODE_ARTICLE);
StartsWith(
Value;
"MS"
)
);
Choices([@'Trame budget programmes courts'].CODE_ARTICLE)
)

Was this reply helpful? Yes No
Power_appsFR 10 on at

Like (0)

Report
Copy link

Link copied!

this code works :

If(
DataCardValue1.Selected.Value = "Masse_salariale";
Filter(
Choices('Trame budget programmes courts'.CODE_ARTICLE);
StartsWith(
Value;
"MS"
)
);
Choices([@'Trame budget programmes courts'].CODE_ARTICLE)
)

Was this reply helpful? Yes No
WarrenBelz 154,399 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Power_appsFR ,

You can add the other choices in the top section

With( { _Choice: Switch( DataCardValue1.Selected.Value; "Masse_salariale"; "MS"; "Transport"; "TR" ) }; Filter( Choices('Trame budget programmes courts'.CODE_ARTICLE); IsBlank(_Choice) || StartsWith( Value; _Choice ) ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No