Popcorn, suggestions are given because the OP’s Rav specifically told him that HE can’t invite the friend for Shabbos, so the only way for the friend to experience a Shabbos was for him to set him up with someone else or for the OP to go against his RAV.
Kol Hakovod to you and your family, but you are not the one that asked for help. So what do YOU suggest the OP do?