web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Approval Workflow for Invoices in SharePoint

(0) ShareShare
ReportReport
Posted on by 2

Good morning,

 

After frequently visiting this forum, I decided it was time to join. This is my first post, so please bear with me.

 

To provide some context, I have a workflow that involves an Excel Online file table. This table contains a series of file paths where we store our invoices. Each file path is processed within an "Apply to each" loop. This is followed by a "Get files (properties only)" step. If the output from this action is not empty (i.e., the length of the outputs is not equal to zero), it indicates the folder contains files (not all folders will have files at all times). In this case, "Get file content" is executed to check for files in the folder, and results are appended to an array variable (to account for multiple files per folder path). Finally, the files are gathered and attached for approval.

 

The approval process itself works as intended. For instance, if there are three folders—out of a total of 24—that each contain one file, the system will create three separate approvals. However, the issue arises with the file attachment process in approvals. Instead of attaching files from each folder to their respective approvals, the system creates three approvals: one with a single file attached, another with two files attached from separate folders, and a third with all files from each folder. The expected behavior is to create a separate approval for each folder that contains files, with all files in a given folder attached to its specific approval.

 

Thanks in advance!

 

Pics Posted Below. 

I have the same question (0)
  • Husky114060 Profile Picture
    2 on at
    Re: Approval Workflow for Invoices in SharePoint

    Husky114060_0-1712599260714.pngHusky114060_1-1712599287462.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 655 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 371 Moderator

#3
chiaraalina Profile Picture

chiaraalina 276

Last 30 days Overall leaderboard