Hello, I'm having trouble using the Search for users (V2) action in Power Automate to lookup a user's email based on their name as a string. My flow stores a list of users from an Excel document as an array, and appends to the array for each name. Then I use an apply to each for all names in the array to search for users, but I can't get the search for users to return anything from my inputs. My search for users uses this formula: @{variables('PIN Employee Names')} as the search term, and I've attached a picture of the inputs/outputs from my flow runs. Any help would be greatly appreciated, thank you!
