Skip to main content

Notifications

Power Automate - Building Flows
Answered

Arithmetic classified by category

(0) ShareShare
ReportReport
Posted on by 288

Hello Community,

 

I have three Sharepoint lists, and I want to do a Scheduled Flow to get the following results.

 

fgonzalez515_0-1628568034967.png

 

I want to get these results.

 

fgonzalez515_1-1628568072767.png

 

Please your help, thanks.

 

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Arithmetic classified by category

    Hi @v-bofeng-msft,

     

    Thank you so much.

  • Verified answer
    Re: Arithmetic classified by category

    Hi @fgonzalez515 :

    Please try:

    vbofengmsft_1-1628649202896.png

     

    The Result:

    vbofengmsft_0-1628649125493.png

    Best Regards,

    Bof

     

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Arithmetic classified by category

    Hi @v-bofeng-msft,

     

    Thanks, it worked perfect for me, the Create Table Html.

     

    The last question, I want to see where I can apply the FormatNumber for the "Total Price" and "Balance" results?

    Convert to currency or pesos format.

    fgonzalez515_0-1628647884048.png

     

    Thanks.

  • Re: Arithmetic classified by category

    Hi @fgonzalez515 :

    Please try:

    vbofengmsft_0-1628646492036.png

    The Result:

    vbofengmsft_1-1628646525515.png

    Best Regards,

    Bof

     

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: Arithmetic classified by category

    Hi @v-bofeng-msft,

     

    It worked perfect for me.

    I want to see where I can apply the FormatNumber for the "Total Price" and "Balance" results?

    Do you know how I can apply two Create Table Html to the results of "EPResult" and "ContractsObraResult"?

     

    Thanks.

     

  • Re: Arithmetic classified by category

    Hi @fgonzalez515 :

    Because ID is a reserved field of the SharePoint list, I use TheID instead of all the IDs in your example.

    vbofengmsft_0-1628573288592.png

    vbofengmsft_1-1628573436101.png

    vbofengmsft_2-1628573665341.png

    The Result:

    vbofengmsft_3-1628576794189.png

    vbofengmsft_4-1628576802286.png

    My Flow:

    vbofengmsft_5-1628576833960.png

    vbofengmsft_6-1628576871163.png

    vbofengmsft_7-1628577125558.png

    vbofengmsft_8-1628577242028.png

    vbofengmsft_9-1628577292614.png

    vbofengmsft_11-1628577370271.png

    vbofengmsft_12-1628577400221.png

    vbofengmsft_13-1628577420463.png

    Best Regards,

    Bof

     

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard