Answered

DataCardValue1 needs to pull data from another SharePoint source column

(0) Share

Report

Posted on by MShelnutt

381

I have a PowerApp form (called RMA) that has a field (called CC#) that I need to automatically pull a number from a different SharePoint list (Customer Complaint) than the data source for the form (RMA List). The data is an automatic number generated for every entry in the SharePoint list (Customer Complaints), so the first entry is 1, the second is 2, etc..

How can I do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @MShelnutt ,
First of all create a connection inside your form to the second list and set the DataCardValue1 Default property to extract the desired number using LookUp() function. I guess there is a logic behind how number to be extracted. Please give us more details.

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban @RandyHayes Forgive the lengthy response, but I think it will help. I have a PowerApp that is used to log a Customer Complaint into a SharePoint list. There is one field in the form that depending on which choice the user chooses, determines what happens when they click "Submit". One option is the form submits and then resets- done. The other will submit the form and then launch a different PowerApp form that logs into a different SharePoint list. The first SharePoint list automatically generates an ID# that is essentially a counter for each entry made. I would like the second PowerApp form to automatically pull that ID# from the first entry and log it into the second SharePoint list providing a linking reference.

Hope this helps.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MShelnutt

What is the connection/relationship between the RMA CC# and this Atlanta Customer Complaints?

You can certainly get the last ID number from the list, but I am confused as to what would connect the item you are editing to that particular list.

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes All RMA reports come from a Customer Complaint, but not all Customer Complaints will result in a RMA. If someone is looking at the data in the Customer Complaint SharePoint list, if the entry has Yes for the Warranty column, they will know there is a corresponding RMA. I want it so if someone goes to the RMA SharePoint list, they will see what Customer Complaint it is tied to. FYI- CC# means Customer Complaint #.
Hope this helps.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MShelnutt
Sort of kind of following, but still a little lost...

Here's some of my confusion:

- you mention Customer Complaint and Customer Complaints - are these two different lists, or a typo?

- the Atlanta Customer Complaints list you showed has two columns - are there more?

- You mention the RMA list...

Let me explain what I know (based on the bit of confusion I have above):

- You have a Form called RMA and its datasource is RMA

- There is a Warranty column in Customer Complaint. If it is Yes, then there is an RMA entry in the RMA list.

Here is where I kind of go off of the rails...

What ties the RMA to the Customer Complaint? Is there a column in RMA or Customer Complaint that would serve to do this?

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes I apologize, yes it was a typo. Here is what the columns look like in the Customer Complaint List-
And here is the columns for the RMA list-

Does this help?

-Michael

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MShelnutt

Immensely!! Thanks.

So, the RMA list has a CC# column in it and it is numeric. Is that column populate with the ID of the record in the Customer Complaint list?

Is that what relates the RMA back to the CC List?

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Yes, exactly. I added that column for that reason. Now I need to know how to get the PowerApp to pull it then write it.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@MShelnutt

Okay...we've found the connection (crowd cheering).

But I am confused by your last statement "how to get the PowerApp to pull it then write it." Can you explain that?

I assumed that when you first create the RMA record that you are populating that CC# column with the ID of the CClist record...is that not the case (I hope not as that would lose our connection - crowd moans)?

Was this reply helpful? Yes No
MShelnutt 381 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes The first PowerApp writes to the Customer Complaint SharePoint list, at such time, SharePoint is auto generating the ID#. Then the second PowerApp is launched and has a field for CC#, which is the ID# of the first SharePoint list. I want that second PowerApp to retrieve the ID# of the first SharePoint list using the CC# field of the second PowerApp form, and then when the user submits that second PowerApp, it will write all that form information (including the CC# aka ID#) into the second SharePoint list.

Waiting for the crowd's reaction...

Was this reply helpful? Yes No