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?
Solved! Go to Solution.
So looking back over the prior thread, in that one we put a formula in the OnSuccess action of the form to determine if we needed to launch, so in that formula:
Launch("URLForOtherApp&ID=" & Text(Form1.LastSubmit.ID))
This will pass the ID to the next app in the URL.
Then in the RMA app, first look at the Param and navigate as needed.
For example, in the OnStart of the RMA app:
If(Value(Param("ID") > 0, Navigate(theRMAFormScreen))
Then in the CC# Default property of the Input Control in the datacard:
Coalesce(Text(Parent.Default), Param("ID"))
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.
@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.
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.
@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.
@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?
@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
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?
@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.
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)?
User | Count |
---|---|
253 | |
122 | |
107 | |
53 | |
50 |