Using a global variable with a form

Like (0) Share

Report

Posted on 16 Feb 2021 10:04:32 by CU01081947-0

716

Hello Power Apps Community,

Can you help please? I'm dreadful with variables, and need some assistance. This may get confusing.

In a nutshell I want to pass a record in a gallery to a form, but... I already pass a record from another gallery into that form.

Here's the long explanation.

I have a screen Screen Search Employee which has a gallery galEmployee.

For the OnSelect property of galEmployee I have the below formula.

Set(

gblEmployee,

ThisItem

);

Navigate('Screen Edit Employee');

ViewForm(frmEditEmployee)

So this passes the record of the selected Employee record in the Employee gallery galEmployee by using the global variable gblEmployee to the screen Screen Edit Employee, which holds a form called frmEditEmployee.

This is working perfectly. So I click an Employee record in the Employee gallery and on the other screen then details of that employee show on the form.

My request

I have another screen Screen Edit Company that has a form, which shows a Company record.

The Company table is the parent of the Employee table.

So 1 Company record can have many Employee records.

On this screen Screen Edit Company beneath the Company form I show all the related Employee records in a gallery galCompanyEmployee.

When a user clicks on a specific Employee record in the gallery, I pass them again to the Screen Edit Employee which holds the form called frmEditEmployee. So, the same as above.

I use this formula in the OnSelect property of a record in the gallery galCompanyEmployee:

Navigate('Screen Edit Employee');

ViewForm(frmEditEmployee);

But, when I'm landing on the form frmEditEmployee it is not showing the record I selected in the gallery galCompanyEmployee.

This, I think, is because I'm not passing/referencing a variable.

How can I call the global variable I already have gblEmployee? Or am I misunderstanding how global variables work.

Thanks very much,

Garry

Categories:

Using Apps Using Formulas

General Questions

All responses (4)

Answers (1)

CU01081947-0 716 on 16 Feb 2021 at 17:03:16

Like (2)

Report

Re: Using a global variable with a form

Hello @VijayTailor,
This worked perfectly. I didn't release I had to set the variable on both galleries. I've learnt something today!
Thanks very much,
Garry
Verified answer

Vijay Tailor 2,961 on 16 Feb 2021 at 13:23:56

Like (1)

Report

Re: Using a global variable with a form

Hi @GarryPope ,

Yes, You can set the Same variable in Both galleries, but if Gallary has the same source then you can use the Same form but both data sources are different then you need to use different from based on condition.

Like - Source 1 - ID,Name column
and Source 2- also have the Same Column then you can use the Same form.

but if Source 1 - Have ID,Name column

and Source 2 - have ID, Name,Other FIeld then you need to use different form.
CU01081947-0 716 on 16 Feb 2021 at 12:28:46

Like (0)

Report

Re: Using a global variable with a form

Hello @VijayTailor
Thanks so much for the swift reply. So I can set the same variable in both my galleries and pass them to a single form?

Thanks very much,
Garry
Vijay Tailor 2,961 on 16 Feb 2021 at 10:42:43

Like (1)

Report

Re: Using a global variable with a form

Hi @GarryPope ,

You can use the variable you declared already.

set this variable into the Items Property if you are using the Same source where your variable updated.
See the reference below - (Note - you can use global variable anywhere in the App.

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay