Display Values in Dropdown in UiPath Apps

Help Apps
,
1

Hi UiPath Community,
I have data service entity that shown below

A table displays a list of project entries with columns for Id, ParentAccount, ChildAccount, ProjectName, DateType, Created By, Create Time, Updated By, and Update Time. (Captioned by AI)
A table displays a list of project entries with columns for Id, ParentAccount, ChildAccount, ProjectName, DateType, Created By, Create Time, Updated By, and Update Time. (Captioned by AI)1765×416 55.2 KB

here in this entity datetype row is empty that i get from the UiPath Apps
based on that i have created a sample Ui in Apps that shown below
image
image1905×794 74 KB

as see in the screen shot when i click on the parent account or project name dropdown it should dispaly the values , i have added entity but i dont know how to display the values in the dropdown i tried to write the expression but it is throwing error, other than this in the practical scenario if user select either parent or projectname dropdown the child account dropdown will only display the values corresponding to the parentor project dropdown suppose if user select 1 from the parent account, it should only display 908,123 and 345 , after that user enters the date type,that date type should should go and sit in data service(lookup on child account number selected by user) , so in contrast i need to display values in dropdown, based on the selected dropdown i need to display the values in child account and to add datetype in data service based on user inputs, can any one help me how to do this, i am relatively new to UiPath apps and data service
Regards,
Alan

2

A drop down is expecting an Array. So you need to initialize this array in the page load or home page load event

For hard coding the array values - you can use below method

image
image612×253 20 KB

Or if the value is expected from Data Service unique values of a column - use the below expression

EntityName.data.select(function(x) x.ColumnName).Distinct().ToArray

image
image556×288 22.4 KB

Hope this helps.

3

Thanks for the reply , do you know how to populate those data in data service using lookup, for example when user select date type, that date type should go and sit in data service (based on the lookup on child account) i have attached a screen shot of data service below

The image displays a table listing several entries with columns for ID, Parent Account, Child Account, Project Name, DateType, Created By, Create Time, Updated By, and Update Time. (Captioned by AI)
The image displays a table listing several entries with columns for ID, Parent Account, Child Account, Project Name, DateType, Created By, Create Time, Updated By, and Update Time. (Captioned by AI)1900×458 166 KB

4

I didnt get

is your ask is to filter data service based on the selected value?

5

This app i have created

The image displays the UiPath App Studio interface, showing a form in progress for a dummy app with fields for Parent Account Number, Project Name, Child Account Number, Date Type, and a submit button. (Captioned by AI)
The image displays the UiPath App Studio interface, showing a form in progress for a dummy app with fields for Parent Account Number, Project Name, Child Account Number, Date Type, and a submit button. (Captioned by AI)1819×758 123 KB

This is my data service, here you can see datetype is empty this date type we will get from apps from the user
This is a screenshot of a table displaying project account information with columns for Id, ParentAccount, ChildAccount, ProjectName, DateType, Created By, Create Time, Updated By, and Update Time. (Captioned by AI)
This is a screenshot of a table displaying project account information with columns for Id, ParentAccount, ChildAccount, ProjectName, DateType, Created By, Create Time, Updated By, and Update Time. (Captioned by AI)1898×434 166 KB

suppose if the user select the Parent Account Number as 1 , child account as 345 and user enter the date type as “Month” it should come in the data service as in the 5 th row as you can see in the data service screen shot