cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Replicate Product Name by Quantity in Excel

Jump to solution

I need the ability to show product line items (Opportunity Products) line by line in excel.

For example, the product is called ABC123 and has quantity 5 selected on SF. I want that to show like this in excel:

 

Product

Another attribute

Another attribute

ABC123

 

 

ABC123

 

 

ABC123

 

 

ABC123

 

 

ABC123

 

 

 

Is this possible? The reason I need this is because each product has a set of attributes and need to be passed on to a third party to add names of personal to it etc.

Labels: (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Replicate Product Name by Quantity in Excel

Jump to solution

@deadyb There is no feature inside of the product to do this for you. In this kind of scenario you would most likely need to look at using logic in excel. You could potentially use a power query like this example(https://www.youtube.com/watch?v=BXTFqL_K6QE). Just keep in mind this would require a refresh of the query after the document is generated.

Reply
Highlighted
Nintex Newbie

Re: Replicate Product Name by Quantity in Excel

Jump to solution
Thanks for this. If I were to use Excel as Middleware could this be achieved each time an excel document is created instead of manual intervention?
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Replicate Product Name by Quantity in Excel

Jump to solution

@deadyb Previously I have had to do a refresh of data for the power query to update after creation. So I do not believe this would work with excel as middleware.

View solution in original post

Reply