You’re offline. This is a read only version of the page.
59
I am searching for user via their Last Name and then once I get that output, I am looking to just make the Surname all upper case so that I can cross reference it against another field but it does not seems to changing that data field. I am using the expression:
@bsmith736464 the following flow based on your worked for me, pulling the email address from the spreadsheet and putting that into the Search and then using 2 compose controls converting the surname to upper case:
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
@fchopo - thank you so much for your help but unfortunately it is still not working.
I have tried it a couple of ways but from what I can surmise from the output, it looks like "Compose 2" box is only pulling data from the original excel file that is already uppercase instead of the "Search for Users" output that I need it to.
Hello @bsmith736464
I think you should use this expression in the compose value: toUpper(items('Apply_to_each_5')?['Surname']) using the ouput from the search users (v2) action. I have done something similar, and it works:
Hope it helps!
Ferran
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
