Automate PDF Renaming via Power Automate

50.0 USD

50.0 USD peopleperhour Technology & Programming Overseas
5 hour ago

Description

I'm looking for a talented freelancer to create a Power Automate flow for renaming my PDF files stored on OneDrive. The new names should be sourced from a specific column in an Excel sheet.
Key requirements:- Develop a Power Automate flow that correctly identifies each PDF file and matches it with its corresponding row in the Excel sheet- Apply the new naming conventions as specified in the Excel sheet
Ideal candidates will have:- Strong expertise in Power Automate and Excel integration- Proven experience in automating file management processes
If you're efficient, detail-oriented, and can ensure seamless operation of the flow, I'd love to hear from you!

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

We are a Leak Detection and drying company that undertakes works for clients by first attending a property and providing a report then with subsequent costs. We currently pay for a CRM that we only use c.10% of, the pricing tool element so looking to replace this with an excel sheet. We have four price lists that we use for different types of clients so in effect would be four sheets built the same but with different line item costs. We have the template of costs and are looking to produce an excel tool that our team of estimators can use/input relevant line items then a cost/ estimate is produced at the bottom. We have different types of costs ranging from equipment charged out per day, labour, materials and sub contractors with % uplifts to be applied. An example of a line item would be a solution applied to a square meterage of floor, we would need the line item to be able to work out the cost with a pre determined figure with an input being the size needed (or the most efficient way of attaining the right figure for the volume needed). We would need an area that accounts for the rooms we are working in and sizes so it automatically prices depending on the item. Another example would be different costs of labour time, depending on seniority. We would then look to take the estimate and pop it into another document that would be provided to the client. This would be word that would be converted to PDF. As a bare minimum we are looking for the pricing tool on excel. However if you are able to produce a report template we could use also that we can input this data sheet in to, and use for adding pictures and writing for our report too, then that is something we are thinking about also. I have attached an example price list and an example Estimate and report which is our current document that we are looking to replace (where the costing sheet would be copied in to) but it maybe that an excel sheet can do 90% of it excluding maybe the written report bit. I also have a pricing template a sister company uses that is similar to what we want but can share this with relevant responders.
1000.0 GBP Technology & Programming peopleperhour Overseas
3 days ago
OBJECTIVE: Develop a Python script for the Zapier Code Module to dynamically generate and output an HTML template using provided input variables. The script must be robust, handling missing or malformed data gracefully. REQURIEMENTS: Input Variables: - Dynamic variables provided as comma-separated strings: {Meta_Data_Artist_Name} (e.g., "Artist A,Artist B") {Meta_Data_Artist_Image_Url} (e.g., "https://example.com/a.jpg,https://example.com/b.jpg") {Meta_Data_Artist_Thank_You_Msg} (e.g., "|||Thank you for your support|||,|||We appreciate your kindness|||,|||Grateful for you|||") {Meta_Data_Artist_Slug} (e.g., "artist-a,artist-b") - Variables are aligned by index: the first entry corresponds to the first artist, the second to the second artist, and so on. - Duplicate entries may exist where multiple products by the same artist are bought. Duplicate entries should be handled to ignore so that only unique HTML blocks for unique artists within the input strings are ajoined and output. HTML Output: - Generate one HTML block for each unique artist. - Join the HTML blocks into a single output for all artists. - For {Meta_Data_Artist_Thank_You_Msg}, use only the content enclosed by ||| ignoring other commas which might otherwise cause a conflict. Name Parsing: - Parse the artist's name from {Meta_Data_Artist_Name} as follows: - If the name contains more than one word, use only the first word. - If the name is a single word, use that word. - Capitalize the first letter of the word (e.g., "john smith" becomes "John"). Error Handling: - If any error occurs (e.g., malformed input or missing data); - Output a fallback HTML block (attached) - Log a meaningful error message in a separate defined output. - Handle missing inputs or null values gracefully. - Trim whitespace and sanitize special characters in the input strings to avoid unintended behaviour or injection attacks. Zapier Integration: - Ensure output is compatible with Zapier’s requirements (e.g., JSON structure like {"html": "", "error": ""}), and output requirements. - Confirm multi-line output compatibility. - Optimised code to reduce errors, conflicts and ease of debugging. Familiarity with Zapier preferred. Flexibility in solution allowed to meet the desired outcome. Acceptance of follow-up changes or troubleshooting is key.
12.0 GBP Technology & Programming peopleperhour Overseas
1 days ago