
Announcements
Hi All,
This Flow intends to format one of 3 separate PDFs. We take the data from the 1st program, copy, paste it onto the designated cell.
The right side of the pasted area performs xlookups to pull in additional info from other sheets.
THEN, I need to use this data to fill out forms.
So far, so good.
But Form A has 11 entry lines, Form B has 8 entry lines, and Form C only has 1 entry line (C).
C is fine - I will create multiple documents and combine them later. (Easier said than done?)
But A and B - how do I ensure that the first 10 items in the list designated to A fill one Form A, and the first 8 entries for B fill one Form B?
(this is an extreme use case. Most of the time there are only a small handful of total entries. It will be uncommon to fill all 11 fields)
I think it has to do with incrementing my variables.....but I am new to this concept. Help is appreciated.
All Excel Columns have corresponding SharePoint fields. However, I only have one field from my pasted 'B/S' field. Ideally, the 2nd row on the list will populate B/S2, and the third item will populate B/S3, etc.