Unanswered

toUpper Output Value from Outlook Search For Users

(0) Share

Report

Posted on by bsmith736464

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:

toUpper(triggerBody()['Search_for_users_(V2)']?['Surname'])

and part of my flow is below. Any help would be much appreciated.

Screen Shot 2020-02-21 at 7.28.30 PM.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

fchopo 8,003 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
bsmith736464 59 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Please, could you share the expression in the "Compose 2" action?

Was this reply helpful? Yes No
Verified answer

RobElliott 10,323 Super User 2025 Season 2 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No