web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / search and replace fun...
Power Apps
Unanswered

search and replace function semicolon error (CTRL+H)

(0) ShareShare
ReportReport
Posted on by 39

Hello


i've got an apps made with powerapps who search in a table to get some info and add some. Until now i was working with a test_table. Since my apps is really simple and i've got who contains all data that i need, i wanted to update the name of the column/table that i was using.

 

To do so I used the search & replace function (ctrl + h) and i got problem with it.

What did I do :


1) I oppen my powerapps app

 

2) i press ctrl+H

 

3) i put in the "search" field "MAC" (the name of one my column in test_table)

 

4) i put in the "replace" field "Adresse_mac" (the name of the corresponding column in new_table )

 

5) the formula of one of my text input is

"                                                               LookUp(
"                                                                  test_stock; N°PC=Input_num_inventaire.Text ;MAC
"                                                                           )
Where test_stock is a column name in the test_table, N°PC a column name in the test_table, Input_num_inventaire a text input in my app, Max a column name in the test_table


6) i push the replace button and ask YES when they said they will replace something like 20 occurences

 

7) I think that i will got this

"                                           LookUp(
"                                                test_stock; N°PC=Input_num_inventaire.Text ;Adresse_mac
"                                                   )
8,) But i got this

"                                  LookUp(
"                                  test_stock;; N°PC=Input_num_inventaire.Text ;;Adresse_mac
"                                   )
9) I got doubled semicolon in all of my function where MAC was present and replaced

My app don't have much formula, so i can change this by hand. But if i had a bigger app, i would have problems.

So, did i do something wrong ? Or it is a bug ?

 

Thanks in advance & sorry for my bad english.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard