web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need help with setting...
Power Automate
Unanswered

Need help with setting up a onetime manual automate flow and then a reoccurring one to use going forward.

(0) ShareShare
ReportReport
Posted on by 17

Currently I have a flow that is initiated by a form submission that pulls the response data from the form submission and creates a new item in a Share Point list. The form submission allows me to capture the users email automatically however it does not put out the user's name from the directory like it does if I manually export the form results from Forms its self.

I have over 1200 rows that I would like to create a manual flow to run and pull their email from one column and insert their name from the directory in another column.

Once my existing data is updated, I would then like to automate this that this happens when a new list item is created by my form submission so it is done all at once or done automatically. I have tried doing a manual trigger flow , get items and apply to each but I keep getting errors. Any help would be greatly appreciated. 

Categories:
I have the same question (0)
  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    @sakonn have you tried using the Office 365 Users get user profile (v2) action? It can get the given name and the surname of the responder from the responder's email address from the form or the SharePoint list.

     

    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.

  • sakonn Profile Picture
    17 on at

    I have but I am not sure if I have done it correctly, I will attach a screen shot. 

    sakonn_0-1670083090334.png

     

  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    What input are you using for the get user profile (v2)? It needs to be whatever column you have saved the email address into from the form. You can always check it by adding a Compose action.

     

    Rob
    Los Gallardos

     

     

  • sakonn Profile Picture
    17 on at

    sakonn_0-1670083314257.png

     

  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    So add a Compose action underneath the get user profile action and in the inout field select Mail from the get usre profile (v2) section of the dynamic content box. Then run your flow and it will show if you have picked up the address correctly.

     

    Rob
    Los Gallardos

  • sakonn Profile Picture
    17 on at

    I added that and test ran it, it looks like it worked 

     

    sakonn_0-1670084080241.png

     

  • sakonn Profile Picture
    17 on at

    What is the next step to get it to import that to each row in the list now?

  • RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    It's the SharePoint Update item action.

     

    Rob
    Los Gallardos

  • sakonn Profile Picture
    17 on at

    Do I add that as an action under Get User Profile similar to doing the compose? Or do I add it as an action after the get user profile ? Thanks!

  • Verified answer
    RobElliott Profile Picture
    10,323 Super User 2025 Season 2 on at

    Just add it after the Compose action.

     

    Rob
    Los Gallardos

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard