Set variable with using concat

(0) Share

Report

Posted on by victornaeyaert

Hello, I want to make a new variable with using a concat function. The following is my code

And this is my sharepoint list

Everything after "Dienst" is a boolean.

Why is my code wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

SpongYe 5,715 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @victornaeyaert

Ik zie Nederlands 🙂

Concat is not used properly.

Concat(Table, Formula, separator) needs a table in the first parameter.

I would assume you need Concatenate instead of Concat.

Please check the Syntax documentation.

Wat voor foutmelding geeft the ForAll? (The ForAll is Underline double red).

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
realwillwright 772 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @victornaeyaert

In addition, the correct use should be

Set( varButtonText, $"Knoppen voor: {Concat(Filter('Onboarding_proces_employees', 1=1), IT, ",")}" )

-------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
victornaeyaert 27 on at

Like (0)

Report
Copy link

Link copied!

De syntax error geeft het volgende: The function 'Concat' has some invalid arguments. Invalid number of arguments: received 3, expected 2.
De bedoeling van de script is dat de variabele in de tekst komt van een knop en dat het dynamisch is. Bijvoorbeeld in de tabel wordt IT en Diensthoofd als true aangezien ( kolommen zijn booleans) dat er 2 knoppen zichtbaar worden en dat de tekst van de kolomnaam wordt weergegevn op de twee knoppen.

Was this reply helpful? Yes No
victornaeyaert 27 on at

Like (0)

Report
Copy link

Link copied!

This doesn't work correctly. I get the following.

Was this reply helpful? Yes No
realwillwright 772 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you put your filters in correctly to replace the 1=1?

Was this reply helpful? Yes No