How to get data from table into variable

(0) Share

Report

Posted on by Frans_365CH

231

Database: SQL from AWA

Navigate(Diagnoses_view,ScreenTransition.None,{myVar:'[Access].[tbl_relaties]'.tbl_relatiesId})

Why this is not working?

My goal is to select child records and view them in a new form. Like all contacts from the company. I know there are more ways to do this, but i can't get it working.

Set(myVar,0) is set in the "Onvisible" of the form.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
In my apps with Galleries I use the following to get to the specific Record:

When User clicks Edit I use :

Navigate(Screen_EditUpdate,ScreenTransition.Fade,{EditRecord:ThisItem,type:ThisItem.AssignedTo})

and populate all data in the table for future edits. It basically opens a new page with the table that has all data for the selected item from the gallery:

When User clicks View, I use :
Navigate(Screen_ViewECR,ScreenTransition.Fade,{ViewRecord:ThisItem,type:ThisItem.AssignedTo})

it just populates data in a form:

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Navigate(Diagnoses_view,ScreenTransition.None,{myVar:'[Access].[tbl_relaties]'.tbl_relatiesId})
Which property (of which control) has the expression above?

Set(myVar,0) is set in the "Onvisible" of the form.
One more thing - may be related or not: when you pass a variable to a screen using the Navigate function, that variable is local to that screen. When you create (or set a value of) a variable using the Set function, that variable is global to the entire app. That means that your Diagnoses_view screen has now two variables of the same name, which may be conflicting with each other (I don't know which variable takes priority).

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

As you said there may be different ways to approach what you want - to select child records and view them in a new form.

I`d use a gallery with all records (you can add filters), and onselect I`d transfer selected item data into the table to view, print or even email to others.

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report
Copy link

Link copied!

I want to navigate from the first singel record form

To the galary form en select the child records

Hope this will clear my question.

Thank you very much anyway!

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Frans_365CH 231 on at

Like (0)

Report
Copy link

Link copied!

Problem is, if i set the var on the value 2 all the child records are filtered.

But the value from the table into the variable does not work.

Was this reply helpful? Yes No