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.
@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...
So that kind of takes us back to the original problem (crowd sighs) - you have no connection when creating the RMA back to the original CC.
When you're in your second app, how can we determine the ID of the CC?
Ideally you would do all of this in the same app so that you can just use the ID of the last submitted CC.
I am missing what happens in your message between these two sentences:
...generating the ID#. ? Then the second PowerApp is launched...
What would someone launch another PowerApp for? Wait for it...the back of my mind is calling...this is that bit with the whole 3 buttons thing - ah yes!
Okay, so then why not create the RMA record at the time of submit from the first app and fill in all the relevant information from the CC to the RMA record. Then launch the RMA app passing in the ID of the RMA record in the URL. Then you could just launch into the edit form for that record?
Or, with that same concept, at least pass the ID of the CC to the RMA app and then use it there to populate the CC# field?
Otherwise, I don't see any way to tie back from the RMA to the CC.
@RandyHayes This is what I am wanting to accomplish-
"Or, with that same concept, at least pass the ID of the CC to the RMA app and then use it there to populate the CC# field?"
This reflects back on this post you had.
I believe it was there that you were trying to do the launch off of the button. That is where you would want to pass the ID of the CC to the RMA application as part of the URL.
@RandyHayes Hmm... what would that look like? I dont think I know how to make the URL carry that field information. The field information (ID#) would change, but the URL would not(?)
Can I achieve what I want with Power Automate instead? Maybe that would be easier?
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:
@RandyHayes Update. I found a video on how to connect two data sources to a PowerApp. I connected both the SharePoint lists to this PowerApp. And for my one field (CC#), I want it to auto populate what is listed in the most recent ID column of my Customer Complaint SharePoint list. Currently, I have the Default set to ThisItem.ID (not sure if this is pulling from the correct SharePoint list though), and Items is set to 'Customer Complaints 21'.ID
Any ideas or suggestions?
So are you then combining the two apps into one now?