Skip to main content
Power Automate
    • Robotic process automation
    • Power Automate Desktop
    • Process advisor
    • AI Builder
    • Connectors
    • Templates
  • Pricing
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Register
    • ·
    • Sign In
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Community News
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Connecting To Data
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Share, Chat, Discuss
    • Community Chat & Announcements
    • Power Automate Cookbook
    • Off Topic Discussion
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Watch & Share Videos
    • Webinars and Video Gallery
    • MBAS Gallery 2019
    • MBAS Gallery 2020
    • Give Feedback & Share Ideas
    • Power Automate Ideas
    • Report Issues
    • I Found A Bug
    • Find & Join Local User Groups
    • Power Automate User Groups
    • Read & Share Blogs
    • Power Automate Community Blog
    • Community Blog Topic Suggestions
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Forums
    • Share, Chat, Discuss
    • Power Automate Cookbook
    • Send Payslips after payroll processing

    Send Payslips after payroll processing

    04-09-2020 03:53 AM

    moa
    New Member
    413 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    moa
    moa
    New Member
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Email to a Friend
    • Report Inappropriate Content

    Send Payslips after payroll processing

    ‎04-09-2020 03:53 AM

    A simple idea but very useful in out organization. Saved some money we used to pay for a third party to send payslips to all employees.

     

    All what needs to be done now: Finance team updates an excel sheet in a document library with payroll information, and everyone gets their payslips in PDF

     

    Workflow Steps:

     

    -List rows from the excel file

    -For each row:

             1-Create an item in a SharePoint list (this is an optional step just to keep historical data).

             2-Populate each column to a Microsoft Word template  that is saved on Sharepoint library or OneDrive directory.

             3-Create a file using the output of the step(2) ans save it in a document library or a OneDrive directory.

             4-Convert the file saved in step (3) to PDF.

             5-Send the PDF file by email ( Hint: Recipient address is mentioned in one of the columns initially updated by finance team) 

     

    Note (need to have premium licenses to be able to populate the data to Microsoft Word template and convert to PDF (steps 2 & 4)

    Preview file
    88 KB
    PayslipsAutoGenerate_20200409104940.zip
    Labels:
    • Labels:
    • Button Flows
    Message 1 of 1
    413 Views
    1 Kudo
    Reply
    • All posts
    • Previous Topic
    • Next Topic

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Automate
    • Power Virtual Agents
    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing
    • © 2021 Microsoft
    • Twitter
    • RSS Feed
    • YouTube
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions