I'm trying to personalize an SMS in a journey but the SMS isn't sending. If I leave out the code, it works. To set up the code, I'm using data from the Entry Source "Test_B2C_Contracts_Renewals". If it's possible, once the code works, I would use a different entry source "B2C_Customers", but the 2 data extensions are linked through Attribute Group (So I'm not sure if it will still work).
The code I put in the message field of the SMS so far (that I found here on stackexchange and adapted to our needs):
%%[ SET @idSubscriber = MOBILE_NUMBER SET @rows = LookupRows("Test_B2C_Contracts_Renewals","BankAccountNumber","OfferAmount","CodeVCS","GSM1",@idSubscriber) SET @RowCount = RowCount(@rows) IF (Rowcount(@rows) > 0) THEN SET @ILRow = row(@rows,1) SET @BankAccountNumber = Field(@ILRow,"BankAccountNumber") SET @OfferAmount = Field(@ILRow,"OfferAmount") SET @CodeVCS = Field(@ILRow,"CodeVCS") ENDIF ]%% BankAccountNumber: %%=Field(@ILRow,"BankAccountNumber")=%%, Amount %%=Field(@ILRow,"OfferAmount")=%%, communication %%=Field(@ILRow,"CodeVCS")=%%. Info on our website.