Good morning @Drrickryp
That worked great, I just had to modify the code a tad is all.
LookUp(Part_Requests, Req_Num = ThisItem.Req_Number, Requestor)
I set it up the way I would like it to look now.
We can attempt group everything together for filtering, if you're up for it.
I'm going to do my best to figure it out in the meantime.
I would love to check out some of your work when I get a chance and I really appreciate your help on this.
To provide data for your galleries, I envision a list of Customers, a list of Requests and a list of Parts. You would use an edit form to add new customers or modify the information about that customer such as the contact, shipping address, purchase terms etc.
The same would be true for Parts. On that edit form you could have a description of the part, its code number and even a picture of it.
For the Request list you would have a dropdown for the customer To input the information for the Part_Request. Look at the example from the Northwind Products sample database for the Orders_Details table. It's design is similar to your Parts_Request. The upper part shows the details for the particular order, while the Products part shows the selected products for the order. Products are added to the list from the light blue section at the bottom using a Patch() for the items selected in the dropdown and textinput controls to the left of the "+" icon. The totals for quantity and price can even be added to the bottom. If this design works for you, I can help you with it.
@Drrickryp Thanks for the suggestion, but I do actually have the main portion completed already. I'm just having a hard time trying to combine the two lists we spoke about and bring the information back for the approvals/completions/duplicate entries, etc..
It's actually a little more complicated than just starting fresh.. We're doing a lotus notes migration of around 100k records. So, if I can't get this combining issue worked out, I may just have to resort to a single SP list.
Good afternoon @Drrickryp! How are you today?
I believe I finally figured it out using this code.
I appreciate all of your help and I'll mark this completed from your previous post, :).
ClearCollect(colTest, AddColumns( GroupBy( RenameColumns( ColParts, "Req_Num", "Req_Number"), "Req_Number", "RestOfData"), "Requestor",LookUp(ColPartsRequest, Req_Num = Req_Number, Requestor), "DateSubmitted",LookUp(ColPartsRequest, Req_Num = Req_Number, Date_Submitted), "Status",LookUp(ColPartsRequest, Req_Num = Req_Number, Status) ));
No Worries @Drrickryp .
Yes, things are coming together nicely, but I too have been busy.
I'm still working on a few issues with filtering/searching however.
I hope all is well, thanks again!
I've tried using the Filter function in various ways to show all items with no luck.
AddColumns( ColPartsRequest, "Combined",
Filter( ColParts, Req_Num = ColPartsRequest, Req_Num)));
I feel like there's something very simple to accomplish this, but I'm just missing it..
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!