Setting global variable with specific record from data source

[RMC-Pro]

Hello Community,

can someone gives me a hint why this doesn't work - as a result I get a global variable with a record (it means it during conditioning record is found) that has all Fields empty; actually all fields but one that is mentioned in Notify formula - the segment with Notify formula is not needed, it serves for debugging purposes; if in Notify formula I would use some other field, global variable would have that field populated but not others. 

(I use formula with Button OnSelect or with Screen OnVisible;  I use similar formula with App onStart and it works)

If(
    !IsBlank(
        LookUp(
            'Activities Users Settings',
            'User ID' = vG_User.'User ID'
        )
    ),
    Notify(
        "ime je " & LookUp(
            'Activities Users Settings',
            'User ID' = vG_User.'User ID'
        ).'User name'
    )
);
Set(
    vG_User,
    LookUp(
        'Activities Users Settings',
        'User ID' = vG_User.'User ID'
    )
)

and if I have a Label with Text formula vG_User.'User name', it would not change if the name would be changed (in a form on different screen, and returned back to this screen).

What am I missing?

Tnxs 

br

@RMC-Pro

[WarrenBelz]

Hi @RMC-Pro ,

The formula you have produces a record rather than a field value for the IsBlank test - for a start try

If(
   !IsBlank(
      LookUp(
         'Activities Users Settings',
         'User ID' = vG_User.'User ID',
         'User name'
      )
   ),
   Notify(
      "ime je " & LookUp(
         'Activities Users Settings',
         'User ID' = vG_User.'User ID'
      ).'User name'
   )
);
Set(
   vG_User,
   LookUp(
      'Activities Users Settings',
      'User ID' = vG_User.'User ID'
   )
)

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.

[RMC-Pro]

Hello @WarrenBelz ,

thanks for responding.

I know that, (1) I check if record exists (at this stage an for debugging/development purposes only one record is in the entity) - Checked, and (2) then I load the whole record into a global variable - record is loaded, but with empty fields (even though the record in the entity is fully populated). Even stranger or non explainable (for me) is that only global variable field that gets value is the one (or few of them) that is mentioned in Notify segment (Notify segment is completely redundant )*.

* I noticed similar behaviour in GroupBy function (i.e., finding and creating the record/s but not populating the fields).

It is bugging me and it is stopping my work. What am I missing (in my approach)?

Tnxs

br

@RMC-Pro

[WarrenBelz]

Hi @RMC-Pro ,

A bit of debugging - put this on a button

ClearCollect(
   colTest
   LookUp(
      'Activities Users Settings',
      'User ID' = vG_User.'User ID'
   )
)

then a label

CountRows(colTest)

and see if it is zero (0).

If so (and I know this should get the same result), but try

If(
   CountRows(
      Filter(
         'Activities Users Settings',
         'User ID' = vG_User.'User ID',
      )
   )>0,
   Notify(
      "ime je " & LookUp(
         'Activities Users Settings',
         'User ID' = vG_User.'User ID'
      ).'User name'
   )
);
Set(
   vG_User,
   LookUp(
      'Activities Users Settings',
      'User ID' = vG_User.'User ID'
   )
)

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.

[RMC-Pro]

Hello @WarrenBelz ,

any hint is much appreciated.

I tried that before, I currently have it on Button OnSelect and on Screen OnVisible and I receive same results.

To be on the safe side, I tried your suggestion "to the letter" once more, same result; counts 1 record, record is put into the Collection => but all fields but two (record- and user- id - that are generated by system) remain unpopulated.

???

tnxs

br

@RMC-Pro

[WarrenBelz]

@RMC-Pro ,

I probably need some clarity here what exactly is not working. If you do the collection

ClearCollect(
   colTest
   LookUp(
      'Activities Users Settings',
      'User ID' = vG_User.'User ID'
   )
)

then do View > Collections > colTest, what do you see in the collection?

[RMC-Pro]

Hi @WarrenBelz ,

I see searched for record => but all fields but two (record- and user- id - that are generated by system) remain unpopulated.

br

@RMC-Pr

[WarrenBelz]

Hi @RMC-Pro ,

There is only one explanation that I can think of for what you are seeing - you have a record in your data with only the two fields  (and the rest blank) - it make no sense otherwise.

[WarrenBelz]

Hi @RMC-Pro ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

[RMC-Pro]

Hello @WarrenBelz ,

thanks for the shown interest.

I do not know what the problem is (but it is not that data is not in - record is in, fields are populated).

Yesterday I initiated a support request with PA - now I am waiting for the feedback from them.

I will post when find more.

br

@RMC-Pro