How to get columns values dynamically from Schema

Avatar

Avatar
Validate 1
Level 1
CSLTGUPTAA
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
CSLTGUPTAA
Level 1

Likes

0 likes

Total Posts

17 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
CSLTGUPTAA
Level 1

27-07-2020

hi  

I am trying to get Column values from Schema to use further in workflow. facing issue on this. 

 

Suppose I have table where I can see lots of products and sub-products associated. So one way is using split I need to get product values first and then using further split(s) i get the sub-products values (w.r.to each product) so huge number of splits, making workflow complex to manage.

Example : Split -> Product = product1, Product = product2 etc, and then further splits for each Sub-Products like (Under Product= product1 -> and Split -> sub-product = sub-product1, sub-product 2 and so on...) , so I am trying to get values of products and subproducts dynamically so that in case if any more products and sub products get addedd in future, my workflow should be able to pull those data without any change in logic.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

167 likes

Total Posts

386 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

167 likes

Total Posts

386 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

09-08-2020

Hi @CSLTGUPTAA 

this could be done on multiple ways depending what is your aim.

You can easily resolve this in JS node with two for loops (one for products and other for sub-product). Loops will iterate and you can do whatever you want with values.

Below is example to create for loop workflow with one parameter (but you can extend it).

For loop as a workflow 

Regards,

Milan

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

176 likes

Total Posts

934 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile

Avatar
Give Back 50
Employee
Sukrity_Wadhwa
Employee

Likes

176 likes

Total Posts

934 posts

Correct reply

35 solutions
Top badges earned
Give Back 50
Validate 1000
Validate 500
Validate 250
Validate 100
View profile
Sukrity_Wadhwa
Employee

18-08-2020

Hi @CSLTGUPTAA,

 

Were you able to solve your problem with the given solution? Please let us know. Thanks!