Gallery Selection not working

(0) Share

Report

Posted on by MH3

1,059

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:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Craig_Cowley 311 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm new to PowerApps and I'm see the same issue, although my gallery is underlined in green
MH3 1,059 on at

Like
a
(0)

Report
Copy link

Link copied!

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 311 on at

Like
a
(1)

Report
Copy link

Link copied!

@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
Verified answer

MH3 1,059 on at

Like
a
(0)

Report
Copy link

Link copied!
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.