cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SKidambi2
Frequent Visitor

Auto Pull Data from SharePoint List based on input in Powerapps

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Edwin-Abdalian Solution Supplier
Solution Supplier

Re: Auto Pull Data from SharePoint List based on input in Powerapps

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)

 

View solution in original post

5 REPLIES 5
Edwin-Abdalian Solution Supplier
Solution Supplier

Re: Auto Pull Data from SharePoint List based on input in Powerapps

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

SKidambi2
Frequent Visitor

Re: Auto Pull Data from SharePoint List based on input in Powerapps

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

 

Untitled.png

Highlighted
SKidambi2
Frequent Visitor

Re: Auto Pull Data from SharePoint List based on input in Powerapps


@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

 

Untitled.png



@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

 

Untitled.png

Untitled.pngThis is another error i get when i try to put the forumale which you have given

 

Edwin-Abdalian Solution Supplier
Solution Supplier

Re: Auto Pull Data from SharePoint List based on input in Powerapps

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)

 

View solution in original post

SKidambi2
Frequent Visitor

Re: Auto Pull Data from SharePoint List based on input in Powerapps


@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.


afterchanging the formulae.pngdata.png

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,262)