Answered

How to reset global variable selected from gallery item

(0) Share

Report

Posted on by yichingjc

I have a today's work gallery that display a list of work orders and once the user selects a particular one it will sets global variables that are used throughout the app. I know the global variable changes once the user selects another work order but sometimes it is not the case (1 out of 5 would cache). It will cache to the previous variable. how do i resolve that?

I tried to reset the gallery.selected or all item on the onvisible of the screen but that doesn't work because RESET functions requires a control.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You could reset the variables in the OnVisible of the screen

Was this reply helpful? Yes No
yichingjc 67 on at

Like
a
(0)

Report
Copy link

Link copied!

@BrianS Do I reset it to blank ""?

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Show the formula for the variable in the Gallery.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
yichingjc 67 on at

Like
a
(0)

Report
Copy link

Link copied!

@eka24
Set(workOrder, LookUp('Work Orders', 'Work Order Number'=ThisItem.'Work Order'.'Work Order Number'));
Set(workOrderType, workOrder.'Work Order Type');
Set(workOrderAccount, LookUp(Accounts,'Account Name'=workOrder.'Service Account Name'));
Set(floorPlan, workOrder.Floorplan.Name);
Set(sqFoot, workOrder.Floorplan.'Sq Ft');
Set(workOrderGuid, GUID(ThisItem.'Work Order'.'WO Number'));
Set(jobProfile, workOrder.rr_LinkedJobProfile);
Set(brbGuid,ThisItem.'Bookable Resource Booking');

Was this reply helpful? Yes No
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Any variables that are text can be set to blank like this: Set(varName,""), Numbers can be set to 0, Dates can't be set to a null, but can be set to an obviously erroneous date.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

So to confirm you have 8 variables on a single button inside the Gallery?

If so you can replace that with:

Set(myItems, Gallery1.Selected)

You can then make Use of all the Column names as variables in other screen such as; myItems.OrderNumber

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

yichingjc 67 on at

Like
a
(1)

Report
Copy link

Link copied!

@eka24 I ended up using set(workOrder, Blank()) to clear the global variables. thanks

Was this reply helpful? Yes No