Gallery Selection not working

Like (0) Share

Report

Posted on 15 Jul 2021 06:52:16 by MH3

1,057

Hi,

I have an application which has SQL as a DataSource and it records Daily User tasks,

Somehow, there is an error in the application

When I select a Record from the gallery, it's just not displaying in the Detail form and it showing an error:

When I hover on TrackGal.Selected the Selected is underlined in Red and it says,

"Invalid Formula, Expected a value compatible with DataSource.."

it was working before but now it's creating problem in the whole application, I can't edit or view any record...

Help @RandyHayes @eka24

Categories:

Using Apps Using Formulas

Connecting to Data

Mobile App

All responses (4)

Answers (1)

Verified answer

MH3 1,057 on 16 Jul 2021 at 05:04:46

Like (0)

Report
Re: Gallery Selection not working

Hi @Craig_Cowley

I had used this but when in the Detail form,
Items Property (VarRecord) it was not working.

So, I have used this
Gallery Item >> OnSelect
Set(SelectedItemID, ThisItem.TransId);Navigate(DetailScreen)
Where Transid is my Unique identifier in SQL DB.

Then in Detail Form >> Item Property
LookUp('[dbo].[TimeSheet]',TransId=SelectedItemID)

This seems to be working for me now.
Craig_Cowley 302 on 15 Jul 2021 at 15:43:33

Like (1)

Report

Re: Gallery Selection not working

@MH3 I've found another video where I've set my OnSelect to "Set(VarRecord, ThisItem) and then I've set Item of my form to VarRecord.
This seems to now work
MH3 1,057 on 15 Jul 2021 at 07:16:55

Like (0)

Report

Re: Gallery Selection not working

Hi @Craig_Cowley

My Gallery name is also in green but the Selected is in red, and I cant view any record..

I'm experiencing this issue now. what about you?

But I have the same application in tablet view. with same DataSource, it's working fine there. what's the problem?
Craig_Cowley 302 on 15 Jul 2021 at 07:11:15

Like (0)

Report

Re: Gallery Selection not working

I'm new to PowerApps and I'm see the same issue, although my gallery is underlined in green

GalleryIssue.png