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