Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Check excel for new data and send it as email

(0) ShareShare
ReportReport
Posted on by 13

Hello everybody!

 

i am new to flow and was wondering if the following scenario is possible with flow:

I have a file in SharePoint, this file will be filled with metering data each month by several users. I want flow to check if the data has been already been entered and if yes, send the data/table as email.

One option would be to check if all the fields have been filled and if yes, send it.

Option two would check if the last field has been filled and then send it.

Could anyone point me in the right direction or similar template?

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Check excel for new data and send it as email

    Hi!

    Let's try this expression instead

    @equals(empty(coalesce(item()?['Näit'],'')),false)

    Hope this helps

  • Romels Profile Picture
    Romels 13 on at
    Re: Check excel for new data and send it as email

    The value is: @not(equals(item()?['Näit'], null))

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Check excel for new data and send it as email

    Hi!

    understoood, please go to your Filter Array, click on 'edit in advanced mode' and share the expression shown

    Thanx!

  • Romels Profile Picture
    Romels 13 on at
    Re: Check excel for new data and send it as email

    Hello again.

    Thanks for the obvious hint!

     

    No the Condition block that compares the two outputs returns always "true". It seems that the expression "null" is being still counted in the Filter Array output. Screenshot added.

     

    Flow3.jpg

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Check excel for new data and send it as email

    Hi!

    In order to add the suggested expression to your Compose action block, you need to do it via 'Dynamic content' menu

    https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

    Hope this helps

     

  • Romels Profile Picture
    Romels 13 on at
    Re: Check excel for new data and send it as email

    Thanks for the huge help! 🙂

    Somehow the last compare condition comes out false no matter if the Excel file is filled or not. Something is still missing.

     

    Flow2.jpg

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Check excel for new data and send it as email

    Hi!

    So in your screenshot you show 3 excel rows. And you need all three rows have value set in column B, right?

    If so, I would do the following:

    -remove 'Apply to each' and all its internal logic

    -Add a compose action block just after the 'List rows present on a table', assign it the following expression

    length(body('List_rows_present_in_a_table_2')?['value'])

    -Add a Filter Array, assign "List rows present in a table" output as its input. Configure the 'Filter array' evaluation as your it is your current Condition

    -Add a second compose action block just after Filter Array, assign it the following expression

    length(body('Filter_array'))

    Now add a Condition action block, to compare both Compose, operator equals

    On the true branch send the email

     

    Not on my laptop, didn't have time to test

    Hope this helps

     

  • Romels Profile Picture
    Romels 13 on at
    Re: Check excel for new data and send it as email

    Hello again,

     

    i got started with the flow, but i'm stuck with the condition block. How to set it up so, that an email gets sent only after all fields have been filled?

    flow.pngExcel.png

  • efialttes Profile Picture
    efialttes 14,756 on at
    Re: Check excel for new data and send it as email

    Hi again!


    @Romels wrote:

    First of all, thanks for the swift answer.

    Is it possible to check if all rows have been filled? Or add a final "input completed row" so if that is filled all is considered complete.

    The file doesn't store info from the last month, each month there will be a new file uploaded.


     

    If you know the nr of rows that shall be filled monthly, I guess it is easy to check. I mean, as each month there will be a new file upload and assuming it shall store just rows from current month...

    -Add a 'List rows present in a table' action block

    -use length() to calculate nr of filled rows

    My suggestion is to try implementing it and let us know

    Thanx!

     

  • Romels Profile Picture
    Romels 13 on at
    Re: Check excel for new data and send it as email

    First of all, thanks for the swift answer.

    Is it possible to check if all rows have been filled? Or add a final "input completed row" so if that is filled all is considered complete.

    The file doesn't store info from the last month, each month there will be a new file uploaded.

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard