Apply to each - Current Items

(0) Share

Report

Posted on by oappdev

901

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",

 }
]

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":""		
 }
]

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

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

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-litu-msft on at

Like (1)

Report

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.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
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.

{ "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.

Was this reply helpful? Yes No