Connecting 1 to many relationship data in Share Point

[Kishan2]

Hi,

I want to show 2 data in one gallery. i have 2 SharePoint list vendor information, vendor assignments. and I want to show the vendor's name and their assignment in one gallery.

[BrianS]

You can nest one gallery in another. Daniel Christian produced a video explaining it.

https://www.youtube.com/watch?v=EnBpWBb51hs

[Kishan2]

Hi,
Please I am very new to the power app I have an app vendor management app. In this app
I have two lists in SharePoint 1. Vendor detail 2. Assignment. This 2 list has 1 too many
a relation where I am storing the Assignment Detail of a vendor in the Assignment List. IN the Assignment list
I have column Single line of text it is a title column and in this column Vendor id
will be given so the user can understand by the id no that this Vendor has this assignment
so what I have done I have taken one gallery where I am showing all the detail of the vendor
and in the gallery Next icon I have given a variable Varrecord to store the vendor id
And selected vendor information and this icon will navigate to a screen wherein a form
all the detail of the selected vendor will be shown and a user can edit the vendor data
and delete the vendor. in this form, I have given one button which will navigate to
Assignment Screen there is a gallery that is connected with the assignment it will show
the vendor name and their Assignment. I have given one Combobox and one search bar .in
the combo box I have given functionality to select vendor name .default selected item
property of combo box is LookUp(VendorInformation,'Name (Title)'=varRecord.'Name (Title)')
and in the gallery label call vendor name I have used Concat(cmbAssignmentAS.SelectedItems,' Name (Title)')
to show the selected vendor name .in the gallery item property I have given
SortByColumns(Filter(Assignments,StartsWith('Assignment Name',txtSearchboxAs.Text),Title=Text(cmbAssignmentAS.Selected.ID)||IsBlank(cmbAssignmentAS.Selected.ID)),"AssignmentName",If(Sortdescending1,Descending,Ascending))
Question is that when the combo is blank then I am not able to show the vendor name
how to show all vendors and assignments in this gallery when the combo box is blank

[WarrenBelz]

Hi @Kishan2 ,

If this should be a single select combo box, you should not need to do this (what type of field is 'Name (Title)'

Concat(
   cmbAssignmentAS.SelectedItems,
   ' Name (Title)'
)

 If this should be single select, change it back to that and try this in the gallery Items

SortByColumns(
   Filter(
      Assignments,
      StartsWith(
         'Assignment Name',
         txtSearchboxAs.Text
      ) && 
      Len(cmbAssignmentAS.Selected.ID) = 0 ||
      Title=Text(cmbAssignmentAS.Selected.ID) 
   ),
   "AssignmentName",
   If(
      Sortdescending1,
      Descending,
      Ascending
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Kishan2]

Hi,

Wareen i solve this issue by using this syntax in my gallery item SortByColumns(
Filter(
Assignments,
StartsWith(
'Assignment Name',
txtSearchboxAs.Text
),
Title = Text(cmbAssignmentAS.Selected.ID) || IsBlank(cmbAssignmentAS.Selected.ID)
),
"AssignmentName",
If(
Sortdescending1,
Descending,
Ascending
)
)

but now i am getting a delegation warning in my combobox stating that search part of this formula might not work properly on large data. i have more than 2000 vendors and i want to search the vendor name in combobox .

[WarrenBelz]

Hi @Kishan2 ,

It is this line I suspect

Title = Text(cmbAssignmentAS.Selected.ID)

Make a numeric column instead of putting the ID as Text in the Title column - it all should work then

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Kishan2]

Hi,

I just solve the problem by using the collection in the combo box item in Screen visible property I create a collection 

clear collect(colVendorDetail,Vendor information).And I put the collection in combo box items. search part of Combobox was showing delegation warning because the search function is not delegable with SharePoint so instead of using SharePoint I have created a collection and now the delegation warning is gone.

[WarrenBelz]

@Kishan2 ,

Yes, but a collection will only gather record numbers up to your Delegation Limit (it is a "hidden" Delegation limitation) - all you have done is got rid of the warning. I thought you wanted to make it Delegable.