Answered

Remove a letter if a column contains specific selection

(0) Share

Report

Posted on by JimmyW

2,567

I have created a powerapp where i use the scan QR code function. Now the text string i get from the QR scanning contains the letter "S" in the start. I want to remove this "S" But i only want to remove the "S" if my column named "Vendor" = Apple

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

to remove the "S", you can use Right(QR.Text,Len(QR.Text) - 1)
Do you want to patch and fix the data? or you have a Gallery which you display the QRtext?
if you want to patch then just filter the items to "Vendor" = Apple, and if you have a gallery, set the text to If(thisItem.Vendor = Apple, Right(QR.Text,Len(QR.Text) - 1))
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@Edwin-Abdalian Thank you for answering Edwin.

Im not getting this to work.
Im not sure if it's because my Vendor column actually filters another list and displays items from that list to be selected.
I get a invalid argument at the = sign.
If(VendorData =
If(VendorData.SelectedText.Value =

Nothing really works as it says = is invalid
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!
@Edwin-Abdalian

If(VendorData.Selected.Result = "Apple", Right(BarcodeScanner2.Text,Len(BarcodeScanner2.Text) - 1))
What happens is that it will never display the input from the scanner in text it will display the name of the BarcodeScanner button.

What i need to display is the data from the QR scanner and remove the S only if VendorData is Apple if it's not Apple show all data from the QR scanner
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!
@Edwin-Abdalian

If(VendorData.Selected.Result = "Apple", Right(varSerialNumber, Len(varSerialNumber) - 1))
This works correct.
The only issue i have is it wont display anything if i select another vendor now, then the field will be blank because it will only be visible if Apple is selected.
Verified answer

Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!
you haven't specified anything for the ELSE section of your if statement
If(VendorData.Selected.Result = "Apple", Right(varSerialNumber, Len(varSerialNumber) - 1), Else)
What do you display if VendorData.Selected.Result = "Apple" is not true?

If(VendorData.Selected.Result = "Apple", Right(varSerialNumber, Len(varSerialNumber) - 1), varSerialNumber)
--------------------------------------------------------------------
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@Edwin-Abdalian Thank you, i dont know why i missed that really hehe