cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nickbrisbane
Frequent Visitor

Expense capture and report automation

Hi Power community

 

I'm creating a combination of flows to automate our expense reporting and at the same time learn Flow.  But im having trouble with the reporting side of things. 

 

What I've setup so far.

 

Flow one

Captures the expense data and captures a picture of the receipt and stores data as an item on a Sharepoint list, the picture as an attachment to the item.

The idea is all users in our division will have their expense data stored here and will contribute using Flow button on their phones.

Note: this Sharepoint list contains a Yes/No column for "Claim is processed" that is No when unprocessed and Yes once processed by Flow 2 below.

 

Flow two

Aim of this flow is to send an email containing a summary excel table (ideal) or HTML table of Sharepoint items specific to the user that generated the Sharepoint item in Flow 1.  It will also attach the "attachments" relating to the sharepoint items summarised in the table.

 

I have been able to do this when its all structured around a single user, apart from the attachment side of things

I'm struggling get it to work with multiple users.

 

So is what im trying to achieve even possible?

 

Any assistance appreciated!!

 

To explain my flow

  1. Recurrence trigger
  2. Lists all the rows in the table
  3. Deletes all the rows in the table (this ensures a clean table to work from)
  4. Get sharepoint items
  5. If item is "No" add it to the excel table
  6. Delay while table populates
  7. Get the excel file
  8. email the excel file
  9. change all the "No's" in the Expenses Exported? Column to  "yes"

 

 

Untitled.jpg

 

1 REPLY 1
Gristy
Resident Rockstar
Resident Rockstar

You will need to build an array of users from the items currently pending.

 

Then re-query the list or query the returned data for each user.

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (4,033)