Why can't we convert Text->Name

We can convert Strings to Names though and and Text to String.
Text → String → Name is also possible, so why not skip the middle man?

That’s a good question! I don’t know the official reason why, but if you know what FText and FName are used for it may make sense. Having a simple conversion from FText to FName promotes improper use. FText is used for displaying text and has support for localization. FName is used for referencing things like bone names and object paths. I’m not saying there aren’t situations where you’d want to convert FText to a FName, but it doesn’t seem to be very useful in most cases. In those cases (as you already know) you can convert it to an FString and then to a FName, but there are caveats…

Several warnings are highlighted in the documentation, I will paste two important ones here.

FText → FString is dangerous as it is a potentially lossy conversion for some languages.

FText → FString → FName is dangerous as the conversion is lossy as FName’s are case insensitive.

FName to FText however makes slightly more sense considering there are potentially situations where you’d like to display an object path or bone name etc.

Well, the main reason I ask is because I have a datatable(Case insensitive - Name) and a Text value that hold a name(Case sensitive), so in this case the conversion would be fine.