I have a Power automate converting my emails into an excel file. The email alert gives me my employee in a username format, the power automate just reads the email, captures what it needs too and adds it to a spreadsheet for me to better manipulate. This runs constantly and reliably.
What I am looking for is to replace/substitue User.name with just their name whenever it is added to the file. I have tried the substitute formula but keep getting #SPILL! errors. I feel like I'm going about this the wrong way. Right now I have my main Data sheet where all my data gets added from Power automate, then I have a Name reference sheet that has all the user.names in 1 column and all the correctly spelt names in the other. Is there a way for me to have it reference the Name Reference sheet and update the Data sheet? I am comfortable with learning new formulas and approaches just unsure where to start.
