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 Apps
Answered

PowerApps and SQL

(1) ShareShare
ReportReport
Posted on by 213
Hi All,
 
I am going to create a powerapps that save data in SQL. Let say it is employee overtime meal request.
The form contains some data to be fill up and there is one section that I also need to pull employee info to the form. Eg, Employee ID, Location & Contact Number.
 
Those information Employee ID, Location & Contact Number need to be load once create new document. 
 
The question, how do I load the Employee ID, Location & Contact Number to the form and I also need to load field fromthe table that is going to store the information for employee overtime meal request such as comments, amount and approval.
 
During save, it will save all including employee ID, Location & Contact Number to the employee overtime meal request table.
 
Can anyone help with some idea or Any sample that I can learn form it will be good. 
Categories:
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,960 Moderator on at
    Hi
     
    Once someone submits, you will use their Email, dynamic property of the Form, to use 0365 Users Actions to pull back their Profile, to get the rest of the details you wanted above.
     
    Example
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard