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.
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.
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.
213
Share
Report
All responses (
Answers (
