1 year ago

#383865

test-img

David Ginsberg

PowerApps Filter a Sharepoint list Gallery by a selected item from a related Sharepoint list Gallery

I have two Sharepoint lists, one called Vendors/Process, the other called Notes.

Vendors/Process is simply one column with a the name of a Vendor, or the name of a Process we follow, such as Springer Publishing, or IP Addresses.

Notes are records with multiple columns, such as Title, Vendor/Process, Status, Notes, etc.

The Vendor/Process column is related to Records. I can select multiple values in the Vendor column in Records. For example, I can select both Springer Publishing, and IP Addresses.

I have my PowerApp set up so I can click on a Vendor/Process title in Gallery1, and Gallery2 will being back all Notes that have been tagged with that Vendor/Process.

For example, if I create a Note and name it Springer IP addresses, I will tag it with both Springer Publishing, and IP Addresses, and this record should show up whether I click Springer Publishing, or IP Address.

I'm running into a delegation warning. I thought by Filtering Gallery2 by Gallery1 selected item, that this would take care of the delegation warning, but it has not. If I click a Vendor/Process, Notes will only show up if they are one of the first 2000 records.

Here is my function for Gallery1:

SortByColumns(Search('Vendor/Process', TextInput2.Text, "Title"), "Title", Ascending)

Function for Gallery2:

Filter('Notes',Gallery4.Selected.Title in 'Vendor/Process'.Value)

I will admit, I am new to PowerApps and I do not have a technical background.

powerapps

powerapps-formula

0 Answers

Your Answer

Accepted video resources