web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Increment Down Form fr...
Power Automate
Unanswered

Increment Down Form from Excel Table

(0) ShareShare
ReportReport
Posted on by 90

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.

 

rnavrot_0-1668205062486.png

 

 

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.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard