Unanswered

Modern Table OnSelect function is being triggered incorrectly

(1) Share

Report

Posted on by stanmiller95

I have a modern table with an edit form being visible when a record is selected within the table. Since ThisItem is not available in a table OnSelect property, I am capturing the Record Title by referencing the Table.Selected.Title and then using another variable to display the form which is using the Title to lookup the record.

Set(
 VarSelectedProjectPC,
 'Project PC Table'.Selected.Title
);
Set(
 VarUpdateProjectPC,
 true
)

I have found that any refreshes to the dataset (the same applies to a ClearCollect if I add the dataset to a collection) causes the OnSelect property to trigger. However, it will only trigger the 'Set(VarUpdateProjectPC,true)' because is no particular record being selected - the 'VarSelectedProjectPC' variable remains blank.

I originally had the same function with a classic table but this was crashing my app when scrolling horizontally.

Has anyone encountered this at all and perhaps knows of a workaround?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

TonyDew 49 on at

Like (0)

Report

I can't help you with a solution, but I can confirm your experience.

The OnSelect seem to fire on page load, or when you sort columns, etc. When it misfires, there is no selected info either.

Was this reply helpful? Yes No
stanmiller95 34 on at

Like (0)

Report

Thank you for the confirmation, I'm glad it wasn't just something I was doing. I have replaced the table with a gallery for now but I would like to see this issue resolved - especially because the classic table is broken completely.

Was this reply helpful? Yes No
TonyDew 49 on at

Like (0)

Report
! I have had some success, and my work around was corroborated in a Reddit post comment from someone on the Power Apps Interface Group.

Essentially, check to make sure Selected is no blank or has at least one item in it, roughly like:

If(Not(IsBlank('Your Table'.Selected)),**** DO YOUR THING HERE****)

If it is a "misfire" "your thing" won't run, but if it is a legit click, it will.

https://www.reddit.com/r/PowerApps/comments/1bd8q6h/comment/kupi09o/?utm_source=share&utm_medium=web2x&context=3

Was this reply helpful? Yes No
stanmiller95 34 on at

Like (0)

Report

Ah this is a good suggestion!

My only issue with this is that I have a refresh button and it is entirely plausible that a row is selected when this refresh button is pressed. This would at least eliminate triggering on screen navigation which is some of the way to solving my problem.

Was this reply helpful? Yes No
Verified answer

TonyDew 49 on at

Like (0)

Report
@stanmiller95 wrote:
...it is entirely plausible that a row is selected when this refresh button is pressed.
If(Not(IsBlank('Project PC Table'.Selected)), Set( VarSelectedProjectPC, 'Project PC Table'.Selected.Title ) ); Set( VarUpdateProjectPC, true )

This will only set VarSelectedProjectPC if a Table row is actually selected. It won't re-set VarSelectedProjectPC if the Table glitches.

Was this reply helpful? Yes No
GT-05111229-0 39 on at

Like (0)

Report

I am not sure if its worth posting a new question but i have very similar issue

I set a varTRORecord on a page and then it seems that it gets stuck on that record and jumps to the next screen

I added this on the Onselect for ieScreen1 but it seems it keeps jumping to the Navigate part, without letting me choose another line. It totally slips Screen1

If(Not(IsBlank(TROA1dataTble_1.Selected)),Set(varTRORecord,TROA1dataTble_1.Selected));

Set(varUpdateTRORecord,true);

Navigate(ScrnTRODashboard)

Was this reply helpful? Yes No