“Getting Data” issue from first search, repeated requests ok

[HB_UK_PL]

Hi, I’ve got a strange issue with a form.

I’m scanning a QR code and searching the result to find an item in a SharePoint list. On another screen a gallery finds the item, shows some details about the list item. All of that works every time. On the same screen there is a form linked to show the gallery selected item and set to edit, which enables the user to update the list item.

The strange thing is, the form takes two attempts to work! First scan (I’ve also set up a manual test to rule out the QR code part), the screen is displayed and the gallery shows the item, but the form just says getting data, it doesn’t show any data. Go back, scan again and it works for that same item.

Any ideas? I’ve removed the form, the screen, reset up and the same thing happens.

Thanks.

[Drrickryp]

@HB_UK_PL 

What is the Item property of the form?

[Drrickryp]

@HB_UK_PL 

What is the Item property of the form?

[HB_UK_PL]

'Make-Up_Selected_Record_Gal'.Selected

Thanks 

[Drrickryp]

@HB_UK_PL 

Try

Lookup(Production_Data, ID=Makeup_Selected_Record_Gal.ID) as item for the form if Makeup_Selected_Record_Gal is the name of the gallery. Otherwise use the name of the gallery instead of Makeup_Selected_Record_Gal 

[HB_UK_PL]

Thanks for the suggestion.

I was getting errors with the formula, so researched your idea, and came up with :

LookUp(Production_Data,ID='Make-Up_Selected_Record_Gal'.Selected.ID)

But it still takes two goes to get the data in the form to show..

To further prove the idea, from a text box on the same screen I put the following, which works every time to show the selected item in the gallery:

LookUp(Production_Data,ID='Make-Up_Selected_Record_Gal'.Selected.ID,'Serial Number')

[Drrickryp]

@HB_UK_PL 

Is 'Make-Up_Selected_Record_Gal' a variable or the actual name of the gallery? Is the Items property of that gallery a collection or the actual SharePoint list?

[HB_UK_PL]

That’s the name of the gallery, and it’s a SharePoint list.

thank you.

[HB_UK_PL · Accepted solution]

I cracked this one myself in the end. I think there must be a bug of some sort as using the gallery selected option is hit and miss.

In the end got the ID of the record from the QR search button, then passed that to the second screen and used that for the form. Seems a lot more reliable. Hopefully the more simple method of selected record will be improved.