Ok Gurus i am totally new to powerapps .
Now i have a list in sharepoint with 4 feilds like ( employee Number, Employee Name ,Location etc.) now when i put the employee number the Name location and other feilds should auto populate from the sharepoint list. Once the information is populated and i submit an email has to go to the employee about confirmation
Can you please share step by step process to do it please as i am totally new to this please.
Solved! Go to Solution.
so your fields on the form should have names like this: DataCardValue1 , DataCardValue2, etc
for now just focus on one field and try to populate Title, which I'm assuming is DataCardValue1, and I'm assuming Gin Number is DataCardValue2; but you need to verify the names in your app.
Set this in the Default property of the DataCardValue1
LookUp(YourSharePointList, 'Gin Number' = DataCardValue2.Text, Title)
There is a similar post here which will help you achieve your goal.
For sending email, and if you are using Office365Outlook, and if you are using SubmitForm() function, set OnSuccess of your form to
Office365Outlook.SendEmailV2(EmployeeEmail, "Subject", "Body")
**This will use the current user's account to send out the email to the employee
Hi I tried it but i am getting an error can you please check . So what i did was my list has all the information in the backend
Now in powerapps i created a new canvas mobile App
Connect to the datasource which is the sharepoint list and change the GIN Number to "Number".
And now from here how can i take it .
Again i just input the GIN Number and from the sharepoint list it should update rest of the feilds thats it
@SKidambi2 wrote:Hi I tried it but i am getting an error can you please check . So what i did was my list has all the information in the backend
Now in powerapps i created a new canvas mobile App
Connect to the datasource which is the sharepoint list and change the GIN Number to "Number".
And now from here how can i take it .
Again i just input the GIN Number and from the sharepoint list it should update rest of the feilds thats it
@SKidambi2 wrote:Hi I tried it but i am getting an error can you please check . So what i did was my list has all the information in the backend
Now in powerapps i created a new canvas mobile App
Connect to the datasource which is the sharepoint list and change the GIN Number to "Number".
And now from here how can i take it .
Again i just input the GIN Number and from the sharepoint list it should update rest of the feilds thats it
This is another error i get when i try to put the forumale which you have given
so your fields on the form should have names like this: DataCardValue1 , DataCardValue2, etc
for now just focus on one field and try to populate Title, which I'm assuming is DataCardValue1, and I'm assuming Gin Number is DataCardValue2; but you need to verify the names in your app.
Set this in the Default property of the DataCardValue1
LookUp(YourSharePointList, 'Gin Number' = DataCardValue2.Text, Title)
@Edwin-Abdalian wrote:so your fields on the form should have names like this: DataCardValue1 , DataCardValue2, etc
for now just focus on one field and try to populate Title, which I'm assuming is DataCardValue1, and I'm assuming Gin Number is DataCardValue2; but you need to verify the names in your app.
Set this in the Default property of the DataCardValue1
LookUp(YourSharePointList, 'Gin Number' = DataCardValue2.Text, Title)
So basically i tried the above formuale but getting the error as below . I have taken the screen shot of the data also shown below.
User | Count |
---|---|
257 | |
106 | |
87 | |
51 | |
43 |