Power Platform Community Forum Thread Details

hi Everyone

thanks advance for your help. I try to do following using Power Automate Web App (my company only allow us to use this version)

I have 2 excel files

Source Excel file A: has list of 100 IDs that I need to copy and paste into the destination Excel File B one by one
Destination File B: it is a form with an ID cell. Once an ID is paste into that cell, the rest of the form will refresh and give the right answer based on the formula

I want to create a flow/flows that help me to do following:

Copy one ID value from File A
paste value into ID cell in File B
refresh all formula in file B
Save the excel file under certain configuration i.e. combine value in Cell A1 & A2 as file name
convert that worksheet into PDF
Password Protect the PDF file.
then loop to the next ID till one PDF is created for each ID

I have tried to look up solution on line, but none of them work. so wondering if someone can shed some light on this.

thanks

Categories: