You’re offline. This is a read only version of the page.
Announcements
Hey!
I have a Product SP list that has information about the products we use and I also created a user Favorite Products list that contains two columns (user email and favorite product ID). The product ID in the favorites list is taken from the original Product list.
But now I want to create a gallery that uses the Products list, but only the products where the ID contains in the Favorites Poducts list for that user. That is, only the favorite products of that user. How can I do this?
P.S: It is essential that the filter is done on the Products list (and not on the Favorite Products list), as I have other functions that use columns from Products list. So the function must filter the Products list, but only the rows that the ID contains in the Favorite Products list and the email is the same as the email of the user logged into the app.
You should be able to create a sub-gallery for this. I would trap the users' email in the start-up of the app. Then filter your favorites list by that email. Use that list to populate your galllery. Then use Lookup() to bring in the other needed data as a sub-galley. When you create your original gallery, put your cursor in the first cell where you make all the formating for th egallery. Go to the insert tab and insert a Gallery whn you are in that cell. The gallery will be inserted for every item. If you do the lookup it will work for each individual product.
Share
Report
All responses (
Answers (
2,407
