Can we use a data extension fields dynamically inside a SMS content in marketing cloud. Any help would be appreciated.
To use Data Extension fields in SMS for personalization, use the AMPscript Lookup function, as you would do in an email: https://ampscript.guide/lookup/
Bare in mind, that the
MOBILE_NUMBER is the subscriber key for SMS subscribers.
Here’s an example of a lookup function for use in SMS:
%%[ set @lookupValue = MOBILE_NUMBER set @fn = Lookup("DataExtensionName","FirstName","MobileNumber", @lookupValue) ]%% First Name: %%=v(@fn)=%%
Here is a question similar to yours: Personalization in Mobile Connect SMS called within Journey Builder