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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get executing user in ...
Power Automate
Answered

Get executing user in Flow for user records only

(0) ShareShare
ReportReport
Posted on by 56

Please I use flow to execute sql store procedure on powerapps forms which works fine but how can I execute the records only in relation to that user. For instance two users A&B input their data but when user A execute, only his/her records are send to ths database and not all records as am getting now. thank you

Categories:
  • v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @eka,

     

    From your description, you could consider comparing the information of the user who executed Flow and the user of the input data.

    Only the information of the user input that executes Flow is obtained, and then sent to the database.

    Sorry, I don't know much about apps. It seems that you could carry user information when they enter data. You could get this information and compare it with the user who executed the Flow.

    Please take a try.

     

    Best Regards,

    Barry

  • eka Profile Picture
    56 on at

    Thanks, I tried;

    spPayments.Run(User().Fullname) and spPayments.Run(User().Fullname,0)

    but it is not working

  • eka Profile Picture
    56 on at

    Please here is my flow which works fine if I dont execute based on user;

    spUntitled.png

  • v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @eka,

     

    Looking at the screenshots you provided, I am afraid that your requirements cannot be achieved currently.

    The user who executes the sql store procedure depends on which account the connection configuration of the Excute store procedure action is.

    This cannot be changed during the execution of the Flow. This is required to be configured in advance.

     

    Best Regards,

    Barry

     

  • eka Profile Picture
    56 on at

    Thanks, but what does configuring in advance mean. does it mean I have to do that in sql? if you can clarify that for me and any other help.

     

    thanks in advance

  • v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @eka,

     

    I mean, the user who executes the sql store procedure depends on who is the user of the connection account configured within Excute sql  procedure action. These are pre-configured before Flow is executed and cannot be changed during Flow execution.

     

    Best Regards,

    Barry

  • Verified answer
    GabrielStJohn Profile Picture
    Microsoft Employee on at

    Hello, @eka!

    Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-bacao-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

    Thank you for being an active member of the Flow Community!

    -Gabriel
    Flow Community Manager

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 315 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 267

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard