You’re offline. This is a read only version of the page.
Hello all,
Back again for more help please.
I thought it will be plain sailing after getting previous help from here which resulted successfully with linking 2 x SharePoint lists (List A and List B) to 6 forms. All of these forms are working perfectly.
My issue right now is this, I’ve added a gallery. The gallery select item only selects the first item i.e. if I select ID 1 the gallery take me to item ID 1. When I select ID 2 to edit, the gallery take me to item ID 1, and so forth with the rest of the items.
The Gallery “on select property has the following code Set(varRecord,ThisItem)
List A has (4) forms and their Item property have the following code, If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@List A]),SharePointIntegration.Selected)
And List B has (2) forms and they have the following code in the Item Property LookUp(List B, ID = SharePointIntegration.Selected.ID)
I have tried different Gallery code like “Gallery1. Selected or LookUp(List A, ID = Gallery1.Selected.ID) but nothing works.
If I use only List A with a Gallery, then the Gallery1 works okay but I need List B to be updated as List A and List B make the whole form up.
Please help or advise me with what I’m trying to do is possible, otherwise I will give up on adding a Gallery for editing forms in Lists A and forms in List B.
Thanking you in advance
Hi @WarrenBelz
thank you so much for your feedback and your help with the issues i have put on this forum. its looks like this problem is not going to get solved. Regrettably, i will move on without a gallery in the apps I'm creating.
Your support is very much appreciated. Thank you!
@Moe69 ,
That code will only return one record as ID is a unique value. I am sorry, but I am getting more unclear the further this goes.
Good morning sir,
The OnSelect code of the Gallery:
Gallery1. Selected or LookUp(List A, ID = Gallery1.Selected.ID)
I tired both of the above codes and still only ID 1 is returned.
The form code:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@List A]),SharePointIntegration.Selected)
Thanking you in advance.
Hi @Moe69 ,
What is the OnSelect code of your gallery and the Item of your Form ?
Hi @WarrenBelz
Thank you for the advise to SharePoint capacity or capabilities.
That's the thing, the Gallery is only selecting the same item what ever record i select, for example,
I have 5 new records in the list A, ID 1, ID 2, ID 3 and so forth,
if i select ID 1, the Gallery selects ID 1, if i select ID 2, the Gallery returns ID 1, if i select ID 3, the Gallery returns ID 1 and so forth.
if this not possible, then i will move on and i will thank you for your time and help sir.
excellent and Thank you,
Hi @Moe69 ,
Sorry, I am lost here - a gallery will only ever select one item and can only contain the records of one list. BTW, having 6 forms and a gallery on an integrated app is maybe inviting problems as they were never designed to do this and your inbuilt SharePoint integration options may not perform as expected.
Hi @WarrenBelz
The Gallery is linked to List A
List A property =
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@List A]),SharePointIntegration.Selected)
As i said previously, List A has 4 forms and List B has 2 forms which complete the whole form.
The issue i have here is the Gallery only selects the first item, even if i select another item record it only goes to the first record. maybe it me not able to explaining correctly
Hi @Moe69
Unusual on an integrated app (this sounds more like a Canvas App). Which list is the gallery based on and what is the Items property ?
Hi @WarrenBelz
Apologies in advance,
I wanted to create a HomeScreen with a Gallery so that the users can select their items in the Gallery that will takes the user direct to that item selected to be updated, and i thought this would be an easy option to have a Gallery on the HomeScreen.
if using a Gallery is not possible, is there something i could use perhaps?
but if you are advising that this is not possible then i will not add a HomeScreen with a Gallery.
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
