DataCardValue1 needs to pull data from another SharePoint source column

[MShelnutt]

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?

[gabibalaban]

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. 

[MShelnutt]

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

[RandyHayes]

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

[MShelnutt]

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

[RandyHayes]

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

[MShelnutt]

@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

[RandyHayes]

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

[MShelnutt]

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

[RandyHayes]

@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)?