Scan Invoices

[JustinasZ]

Hi

My invoices photo below has 1 certain item with example of 12 quantity, how to split them as single if I'm using Invoice Data collection?
Because on excel it shows 12 pieces, so i cant assignee them for certain users i need to split manually, 


Anyone faced this issued? 

[antoinec]

Hi JustinasZ, I'm not sure that I understand your question properly. Can you clarify what you mean by "split"? An example would help. Thanks

[JustinasZ]

Thanks for answer i mean split from 1 row with 12 quantity to 12 rows with 1 quantity, 

[antoinec]

Understood. Did you try looking into using a Do Until control to replicate rows when adding them to Excel through in your Flow? This post gives more insights into how you could build the result: https://powerusers.microsoft.com/t5/General-Power-Automate/Tips-10-times-do-some-actions-by-Do-until... . You would use the quantity from the document as the loop iteration count, and 1 as the quantity you insert in Excel.

[JustinasZ]

This is bad, because for example i have invoice with 100 items, some of this items have quantity of 10 maybe 20, some has only 1.

[antoinec]

You should be able to iterate based on quantity for each item in your invoice. Something like this should work:

[JustinasZ]

i cant insert variable or move them idk why.

[antoinec]

I think you should be able to insert variable related operations after any existing action by clicking on the "Add an action" or "+" sign when you hover above arrows. You can then drag and drop other items if you'd like that action to come up first.

[JustinasZ]

Cant add them when they action started and if action started i cant collect info from actions before.

[JustinasZ]

[antoinec]

Sorry to hear that, I'm not exactly sure how to help make progress 😕. Would it be possible to try starting from a new flow to see if that works better? At least as a way to validate the approach?

[JustinasZ]

apply to each doesnt work because, i cant see a Data from Invoices because its on another action. Which is not related.

[antoinec]

Can you try initializing the variable outside of all loop blocks? Once that's done, please ensure that you edit settings of your "Apply to each" and "Do until" blocks to enable concurrency control and limit it to 1 degree of parallelism only, else parallelism in execution of the loop contents will not play nicely with variable use.

[JustinasZ]

Nah doesnt work 😕

[antoinec]

Did you use the (number) and not (string) quantity variable in the loop's condition? That might explain such an error.

Edit: if you're using a custom model, you'll need to convert the string to a number using int(variable). https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#i... 

[JustinasZ]

[JustinasZ]

Not quite sure how to do it.