Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

SharePoint List - Expense Request Approval Flow

(0) ShareShare
ReportReport
Posted on by 92

Hello all, again.

 

Im facing an issue with a SharePoint list and an approval Flow.

My SP list has 13 Columns where Users add data for Expense Approval - e.g. Item required/department/cost/terms of payment etc.

A flow is triggered when a new item is created to SP list.

Below are the issues created.

------------ ISSUE #1 ------------

Person in charge for the approvals is notified via 'Start and wait for an approval' action, though, in the details im trying to add the Columns to represent the values, but while im trying to add a particular Column field "Type of Expense Value" there is automatically added an other step to the flow - Apply to each (???????????)

 

APPLY.PNGapproval.PNGFlow.PNG

 

-------------- ISSUE #2 -------------- 

If request is approved and as a final step of the flow, is to send to Accounting department a detailed summary of the request.

I need to find a way to somehow Export or represent entry's items (all the columns and the data) into an e-mail.

 

  • dB4 Profile Picture
    92 on at
    Re: SharePoint List - Expense Request Approval Flow

    Hello @sudharsan1985 

     

    Thanks for your input.

    The problem was that i was using Greek language for Column name and data contents, thats why i want able to do previous mentioned steps.

    Changed language to English and everything is working properly.

  • sudharsan1985 Profile Picture
    1,325 on at
    Re: SharePoint List - Expense Request Approval Flow

    @dB4 

    The action will be added automatically, since it is the multivalue field. You can try adding the 'Send email' action and you can design the body content with the values from the trigger action.

  • dB4 Profile Picture
    92 on at
    Re: SharePoint List - Expense Request Approval Flow

    @sudharsan1985  Hi, and thanks for your reply.

     

    The Apply to each is added automatically, whenever i insert into the Details of approval the column name.

     

    Can you please provide an example for your suggestion for exporting the data?

     

  • sudharsan1985 Profile Picture
    1,325 on at
    Re: SharePoint List - Expense Request Approval Flow

    @dB4 

    The 'Apply to each' action is for the multivalue fields. The field 'Type of Expense Value' must be the multivalue field.

    Instead of exporting the data, you can send an email with all the details designed as a table or any other format or even adaptive card so that they can see the details directly in the email, instead of opening the attachments in the email.

     

    Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
    -Sudharsan K...

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,026 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow