Right now, I have an app passing the username into SQL. However, I am hoping I can somehow use the logged in users name to pass text that I identify based on their username.
Example: Usernmame Bob Smith - I want Bob Smith to pass, "AgentBobSmith" to SQL.
@GeminiWorks you can use this: Concatenate("Agent",Substitute("Bob Smith"," ",""))
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.
Thank you but I need it to pull in the username of the user first and then change it to the name I need assigned. Does that make sense? Appreciate the help.
I actually went back in and replaced the "agent" with username and that pulled it in. But the substitute command is simply adding BobSmith on to the end of the username. Thoughts?
@GeminiWorks, if you want the word Agent to be part of the string you are passing you should use something like this:
If you don't need the word "Agent", then simply pass Substitute(User().FullName," ","")
There is no code currently other than the datacard pulling in username. What I'm trying to accomplish is to have the username changed to the name I actually want passed into SQL based on the user.
Pulls in actual username.
What I was hoping I could do is, based on the user, I can have a different name passed to match my other databases.
So, if user Bob Smith is logged in, I want it to pass RobertSmith when the form is submitted to SQL.
If user, Joe Thomas is logged in, I want it to pass JosephThomas when the form is submitted to SQL.
I don't mind building all of the variables into the code but I'm not sure this can be done.
So many events that are happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.