VB Apps: How to display data from data service and how to apply update entity record?

Help Apps
,
1

Hi Together,

despite having seen the documentation, I can’t figure out the VB formulas to do the following ( Is there a documentation on Uipath Apps VB expressions? If yes, where to refer? - Help / Apps - UiPath Community Forum):

How to use the look up formula to get the entity record id?
image

How to display data from an entity by looking up the data (default text)?
image

thank you for your help!

2

@PeCour

Please check this

cheers

3

@PeCour ,

I have covered this into below video. Please have a look

Thanks,
Arvind

1 Like
4

Hi @Arvind_Kumar1,
thank you! But how to do it without edit grid in a normal textfield?
Could you please help me with that?

This I created using the query builder:

  • I want to fetch data of an entity.
  • I filter Mail = CurrentUser.Email

And then I added that with the aim to get the data from column1:

  • .data.first.COLUMN1
  • I also tried fetchone and .column1

But the data is not displayed in default text.

Fetch(of ENTITY)(createFilterGroup(New QueryFilter(){addFilter(“Mail”, “=”, CurrentUser.Email)}, Nothing, 0), Nothing, Nothing, Nothing, New ExpansionFieldOption(){addExpansionFieldOption(“CreatedBy”, New String(){“Id”,“Name”}), addExpansionFieldOption(“UpdatedBy”, New String(){“Id”,“Name”})}).data.first.COLUMN1

5

@PeCour ,

you can create an app variable called entity type and then what you do set the value of App variable on page load by using set value. In Query builder you can change the filter and once done then make fetch function as FetchOne.

Above you can do once on page load or any other event where you think value got updated or changed.

Once this is done. you can use app variable across the apps on any page.

in the Default value of text you can do something like Var_AppVariable.FieldName.

Thanks,
Arvind

1 Like
6

@Arvind_Kumar1 ok thank you that works!

But that is quite a workaround and was better with the old Apps version.
Because that means one additional click for the user for every app.

7

@PeCour ,

This is not work around, This is the way VB Fx works. Rigth now VB fx only support async approach.

They do not have any direct sync call of function. This might get added into future.

Thanks,
Arvind

2 Likes
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.