PowerApps Global Variable conflicting on defining as Gallery Item

[leonardbd]

Hello everyone,

I'm having issue in folowoing scenario while defining global variable to Gallery Item.

I have defined a global variable on Screen OnStart event as "VarItemX". It gets the ItemID parameter from a flow Email link that has Deep Linking and define the record ID as VarItemX variable. Such as record number 274. When user access the link from email, it start the app and navigates to the specific Screen (AdminApproveScreen) and load the data (record 274) on that screen. The screen has a Gallery with Item event/property defied as the variable "VarItemX". It works fine

If(
    !IsBlank(Param("ItemID")),
    Set(
        VarItemX,
        LookUp(
            'Exit Clearance V02',
            ID = Value(Param("ItemID"))
        )
    );
    Set(
        VArFormMode,
        FormMode.Edit
    )
)

 NOw I have another screen (called AllRequests) with a Data Table (called Table_AllRequests) where user can select the record from the table and load the specific screen ( AdminApprove) which will load the Item selected in that data table. Following is the Code applied on Button OnSelect event.

Set(VarApprover, User().Email);
If(VarApprover = Table_AllRequests.Selected.Adm2ApproverEmail,
Navigate(
    AdminApprove,
    ScreenTransition.Fade,
    {VarItemX: Table_AllRequests.Selected}
));

But in above formula if I use the Global Variable "VarItemX" as selected record from that data table, it conflicts with the Variable that defined at the Screen OnStart event. And the screen that I am trying to land the user from Email deep link or from this data table is not properly loading the Item in the gallery of that screen from Variable "VarItemX". It load the data If I select from data Table but didn't load the data in the same screen Gallery from the Email Deep link.

I'm not sure how to achieve that. Should I define two different Variable for Data Table selection and Email Deep link and assign the Item with two different variable with IF condition... I'm not sure how to proceed. 

I can upload the screen recording if it sounds a bit complicated. 

Need your expert advice on this issue.

[WarrenBelz · Accepted solution]

Hi @leonardbd ,

This code

Navigate(
    AdminApprove,
    ScreenTransition.Fade,
    {VarItemX: Table_AllRequests.Selected}
);

is not setting a Global Variable - it is a Context Variable belonging on the screen AdminApprove and is a completely different Variable to the Global item. It will also take precedent on the AdminApprove screen. Does that explain your issue ? You need

Navigate(
    AdminApprove,
    ScreenTransition.Fade
);
Set(
   VarItemX,
   Table_AllRequests.Selected
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[leonardbd]

Yahooo... This works. Just to define the variable again , That's Great!!!! 

Thanks Warren 🙂

[leonardbd]

Hi Warren,

Rather repeating the formula as such, how can I achieve defining variable without repeating for for each condition?

Set(VarApprover, User().Email);
If(VarApprover = Table_AllRequests.Selected.Supervisor.Email,
Navigate(
    SupervisorApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
));

If(VarApprover = Table_AllRequests.Selected.Adm2ApproverEmail,
Navigate(
    AdminApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
));

If(VarApprover = Table_AllRequests.Selected.SUP2ApproverEmail,
Navigate(
    SupplyApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
));

If(VarApprover = Table_AllRequests.Selected.Fin2ApproverEmail,
Navigate(
    FinanceApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
));

If(VarApprover = Table_AllRequests.Selected.ICT2ApproverEmail,
Navigate(
    ICTApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
));

If(VarApprover = Table_AllRequests.Selected.Sec2ApproverEmail,
Navigate(
    SecurityApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
));

If(VarApprover = Table_AllRequests.Selected.HR2ApproverEmail,
Navigate(
    HRApprove,
    ScreenTransition.Fade);
    Set(
    VarItemX, Table_AllRequests.Selected
))

[WarrenBelz · Accepted solution]

Hi @leonardbd ,

Something like this should work - you also need another screen in case all the tests fail.

Set(
   VarItemX, 
   Table_AllRequests.Selected
);
With(
   {
      wScreen:
      Switch(
         User().Email,
         VarItemX.Supervisor.Email,
         SupervisorApprove,
         VarItemX.Adm2ApproverEmail,
         AdminApprove,
         VarItemX.Fin2ApproverEmail,
         FinanceApprove,
         VarItemX.ICT2ApproverEmail,
         ICTApprove,
         VarItemX.Sec2ApproverEmail,
         SecurityApprove,
         VarItemX.HR2ApproverEmail,
         HRApprove,
         YourDefaultScreen
      )
   },
   Navigate(
      wScreen,
      ScreenTransition.Fade
   )
);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[leonardbd]

Hi Warren, 

This is gr8! Thanks .

[leonardbd]

Hi Warren,

Another category of approver has introduced is "Delegator". If a user is available in the approver table and his category is "Delegator" then load Delegation screen. Tried on you formula but failed.. Can u have a look?

With(
   {
      wItem:
      If(
         !IsBlank(Param("ItemID")),
         LookUp(
            'Exit Clearance V02',
            ID = Value(Param("ItemID"))
         ),
         Defaults('Exit Clearance V02')
      ),
      wApprover:
      !IsBlank(
      LookUp(
         'ExitCL02-Approvers',
         User().Email = Name.Email
      )),

      wDelegator:
      !IsBlank(
      LookUp(
         'ExitCL02-Approvers',
         User().Email = Name.Email && Category.Value="Delegator"
      ))
   },
   If(
      wItem.Supervisor.Email = User().Email,
      SupervisorApprove,
      wItem.Adm2ApproverEmail = User().Email,
      AdminApprove,
      wItem.SUP2ApproverEmail = User().Email,
      SupplyApprove,
      wItem.Fin2ApproverEmail = User().Email,
      FinanceApprove,
      wItem.ICT2ApproverEmail = User().Email,
      ICTApprove,
      wItem.Sec2ApproverEmail = User().Email,
      SecurityApprove,
      wItem.HR2ApproverEmail = User().Email,
      HRApprove,
      wApprover,
      ApproversLanding,
      wDelegator,
      ExamplePopup,
      RequestorLanding
   )
)

[WarrenBelz · Accepted solution]

Hi @leonardbd ,

That is because Approver will always be true and the bottom logic will never get to Delegator. Put Delegator in front of Approver at the bottom and it should work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[leonardbd]

Hi Warren,

Thanks. It works. Now I have to change a logics that need to update in the same formula.

I want the Supervisor also can land to approverlanding screen like other approvers but the supervisor name should not be in the approver list 'ExitCL02-Approvers'. From the above formula Supervisor can land into the specific screen from Email link, but if they launch the app they are getting requester's Landing. That means in the following formula

...
.......
wApprover:
      !IsBlank(
      LookUp(
         'ExitCL02-Approvers',
         User().Email = Name.Email
      )),

...

it should be lookup in both list with Or statement so that supervisors also can land to ApproversLandin screen from app startup. This is giving error . Dont know where is the wrong.

....
......
wApprover:
      !IsBlank(
      LookUp(
         'ExitCL02-Approvers',
         User().Email = Name.Email Or 'Exit Clearance V02', User().Email = Supervisor.Email
      ))
.....

[WarrenBelz]

Hi @leonardbd ,

What is 'Exit Clearance V02' ?