cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Re: Show all items in a Combined Collection

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.

 

Thanks Again!

2020-07-16_11h00_05.jpg

Highlighted
Super User III
Super User III

Re: Show all items in a Combined Collection

I'm tied up for about the next 6 hrs but I will check back again later today. 

Highlighted
Helper I
Helper I

Re: Show all items in a Combined Collection

@DrrickrypSounds good.

I'm still trying to figure out how to tie everything together so the records can be selected and populated into text inputs.

Thank You!

Highlighted
Super User III
Super User III

Re: Show all items in a Combined Collection

Hi @Justin_Moz 

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.  Northwind orders.png

 

Highlighted
Helper I
Helper I

Re: Show all items in a Combined Collection

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

Highlighted
Helper I
Helper I

Re: Show all items in a Combined Collection

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)
));

 

 

Highlighted
Super User III
Super User III

Re: Show all items in a Combined Collection

Hi @Justin_Moz 

Sorry, I have been tied up at work for the last few days and into tomorrow.  Keep at it.  I think you are on the right track now.

Highlighted
Helper I
Helper I

Re: Show all items in a Combined Collection

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!

Highlighted
Helper I
Helper I

Re: Show all items in a Combined Collection

@Drrickryp 

I've tried using the Filter function in various ways to show all items with no luck.

ClearCollect( ColCombinedLookUps,
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..

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,896)