Get excel rows from table, for each row (get email_address, copy row data, email data), until end of table

(0) Share

Report

Posted on by r96359

228

Hello all,

I am trying to:

1. Get excel row data from a table on SharePoint or (OneDrive for Business)

2. For each row: get email_address

3. For each row: copy row data

4. For each row: email the data if the email_address is not null

5. Process each row until end of table

I have created several solutions using conditions, if then, etc but having issues with this one.

Help would be greatly appreciated!!!

Cheers, Gregory

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@r96359 When it comes to Excel, I usually use the 'Filter array' to remove empty values.

My solution -

Formula reference -

Filter array
From - value
Condition - Email isnotequal

Apply to Each -
Body - Output of the 'Filter' action.

Create items-
ID - items('Apply_to_each')['ID']
Review - items('Apply_to_each')['Email']

In Excel 8 values -

In SharePoint 6 values

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
r96359 228 on at

Like (0)

Report

@CFernandes

Thanks a bunch!
I'm trying to add a condition after the array that looks for a column but I am getting errors.
Is it possible to use conditions after the array or do I have to use an advanced filter array to include more than one value?
Before the condition, everything was working fine.
Thanks!

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@r96359 In the condition I see @@nxp.com can validate the condition is correct?

From the error you get 'null' it is expecting a string or an 'object'. Can you check if the Window column does not have empty/null values in your excel file?

Was this reply helpful? Yes No
r96359 228 on at

Like (0)

Report

@CFernandes

Many thanks! That extra @ gets inserted automatically at times. Not sure why.

I'm trying now to use a filter array with multiple variables instead to make this cleaner:

@AND(contains(item()?['EMAIL_ADDRESS_NNN'], '@nnn.com'),contains(item()?['Log'], 'updated'))

I have 4 records total.
2 rows have the word updated in the "Log" column
2 rows do not have the word updated in the "Log" column

I still have all 4 records emailed and am expecting just 2 records.
Any ideas?

Many thanks!

Was this reply helpful? Yes No
r96359 228 on at

Like (0)

Report

@CFernandes

To keep it simple I created one array for the 1st condition and a preceding array for a 2nd condition.
It's working now! Is that going to get me in trouble later?
Thx!

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (1)

Report

@r96359 Filtering using Expressions in Excel has always been a pain. That is the reason we are using , Filter action. I have used then in some of the production Power Automate Solution and they are working fine till date. Unless Microsoft changes anything it should not be a problem.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
r96359 228 on at

Like (0)

Report

@CFernandes Thanks for all your help!

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

@r96359 I am glad that my inputs helped. 🙂

Was this reply helpful? Yes No