Forum Discussion
Extract .png from person/group column
- Sep 15, 2023
Hi bryanfrumkin47 ,
yes, you don't need that variable.
If you get the email as a property from your forms trigger, then you can just use that.....I used a variable because I did not want my email address shown in the screenshot and wanted to show you where you needed to put your dynamic values.
With a forms trigger the example would look like this:
Hi bryanfrumkin47 ,
simply use the url
/_layouts/15/userphoto.aspx?size=L&username=<useremail>
and a "Send an HTTP Request to SharePoint" Action.
The "body" that is returned from that action is already in the correct format.
This is how it looks if you want to store that photo as a file
But you should be able to directly put that "body" in a "Populate a word template" action.
Best Regards,
Sven
Could you please provide your setup for the variable. I want to make sure I am doing this correctly. Thank you for your help.
- SvenSieverdingSep 15, 2023Bronze ContributorThat variable just contains my email address.... The one I use to log in.
Best Regards,
Sven- bryanfrumkin47Sep 15, 2023Copper ContributorHello, SvenSieverding
The thing is that the email address will be different every time depending on the trigger.
This flow is triggered by a Microsoft Forms. It retrieves the response details and user profile of the responder, and then uses the requestors' email to extract their profile from a SharePoint list.
From this list, I extract their picture from a person/group column which contains the dynamic action for this picture link.
Is this methodology still possible with this approach? Should I extract the email address from the link and set that as the variable, instead of a static same email in the variable?
Thank you so much for your help.- SvenSieverdingSep 15, 2023Bronze Contributor
Hi bryanfrumkin47 ,
yes, you don't need that variable.
If you get the email as a property from your forms trigger, then you can just use that.....I used a variable because I did not want my email address shown in the screenshot and wanted to show you where you needed to put your dynamic values.
With a forms trigger the example would look like this: