cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oappdev
Advocate V
Advocate V

Apply to each - Current Items

Hello Power Automate Community,

 

I have the flow working, but can't seem to figure out how to Autofill the rest of the PDF Form.  OUTPUTS is showing the selected data. Just struggling with this project, but learning at the same time.

 

[
  {

    "First NameRow1": "MARY",
    "Last NameRow1": "ABBRUZZESE",
    
  },
  {
    
	"First NameRow1": "FRANK",
    "Last NameRow1": "ADKINS",
    
  },
  {
    
	"First NameRow1": "PIERRE",
    "Last NameRow1": "BAUSSAN",

  }
]

 

1.PNG2.PNG3.PNGApplytoeach.PNG

 

 

Here is the JSON I'm using for the Form.

 

Set variable.PNG

Parse JSON.PNG

 

The Parse JSON I'm using.

 

[
    {
        "Provider NameRow1":"",       
		"National Provider Identifier NPIRow1":"",
		"Date of Service MMDDYYYY One date per rosterRow1":"",
		"Medicare IDRow1":"",
		"Date of Birth MMDDYYYYRow1":"",
		"Patient Signature or Signature on fileRow1":"",
		"Last NameRow1":"",
		"First NameRow1":"",
		"MIRow1":"",
		"Sex MFRow1":"",
		"Address No StreetRow1":"",
		"CityRow1":"",
		"StateRow1":"",
		"ZipRow1":""		
    }
]

 

 

 

ApplyToEach1.PNG

 

What I'm I missing to have AutoFill the rest of the form? 

Capture1.PNG

 

Once this is solved, the project would be completed.😳

 

As always thank you so much Power Automate Community. very much appreciated.

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @oappdev,

 

The Fill a PDF form action only supports fill a single form in the PDF, not support multiple forms append into it at the same time. The Apply to each populates the current data into a brand new PDF form every time, so it's not feasible for you to populate three sets of data into three PDF forms at the moment.

 

As a workaround, you could Create three Fill a PDF form actions, and create three PDF files, then use the Merge documents to PDF action, combine the three PDF files to a whole one.

https://support.encodian.com/hc/en-gb/articles/360011886173-Merge-documents-to-PDF 

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you so much @v-litu-msft Sorry, maybe i describe the issue in the wrong way my apology. I will use  your workaround if i have to take that route in the future. 

 

What I'm trying to accomplish is to have a single form fill. So this the JSON that i want to use to fill in the Single Form.

 

I know the 3 screenshot was confusing. The 3 OUTPUTS was to fill the single form. What will be the best approach to accomplish this.

 

 

Form.PNG

{
	"Provider NameRow1": "",
	"National Provider Identifier NPIRow1": "",
	"Date of Service MMDDYYYY One date per rosterRow1": "",
	"Medicare IDRow1": "",
	"Date of Birth MMDDYYYYRow1": "",
	"Patient Signature or Signature on fileRow1": "",
	"Last NameRow1": "",
	"First NameRow1": "",
	"MIRow1": "",
	"Sex MFRow1": "",
	"Address No StreetRow1": "",
	"CityRow1": "",
	"StateRow1": "",
	"ZipRow1": "",
    "Medicare IDRow1": "",
	"Date of Birth MMDDYYYYRow1": "",
	"Patient Signature or Signature on fileRow1": "",
	"Last NameRow1": "",
	"First NameRow1": "",
	"MIRow1": "",
	"Sex MFRow1": "",
	"Address No StreetRow1": "",
	"CityRow1": "",
	"StateRow1": "",
	"ZipRow1": "",
	"Medicare IDRow1_3": "",
	"Date of Birth MMDDYYYYRow1_3": "",
	"Patient Signature or Signature on fileRow1_3": "",
	"Last NameRow1_3": "",
	"First NameRow1_3": "",
	"MIRow1_3": "",
	"Sex MFRow1_3": "",
	"Address No StreetRow1_3": "",
	"CityRow1_3": "",
	"StateRow1_3": "",
	"ZipRow1_3": "",
	"Medicare IDRow1_4": "",
	"Date of Birth MMDDYYYYRow1_4": "",
	"Patient Signature or Signature on fileRow1_4": "",
	"Last NameRow1_4": "",
	"First NameRow1_4": "",
	"MIRow1_4": "",
	"Sex MFRow1_4": "",
	"Address No StreetRow1_4": "",
	"CityRow1_4": "",
	"StateRow1_4": "",
	"ZipRow1_4": "",
	"Medicare IDRow1_5": "",
	"Date of Birth MMDDYYYYRow1_5": "",
	"Patient Signature or Signature on fileRow1_5": "",
	"Last NameRow1_5": "",
	"First NameRow1_5": "",
	"MIRow1_5": "",
	"Sex MFRow1_5": "",
	"Address No StreetRow1_5": "",
	"CityRow1_5": "",
	"StateRow1_5": "",
	"ZipRow1_5": ""
}

 

As always, thank you in advance.

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,111)