Remove Apply to each.

(0) Share

Report

Posted on by DEJ

Hi.

I have a flow which checks a sharepoint folder if it contains xlxs files. If it does, it sends me a email.

BUT. it sends me an email for EACH xlsx file in the folder, and I only want 1 🙂

Can you help

Skærmbillede 2020-09-21 155044.png

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@DEJ

This is my approch - I do not use a condition but instead filter array, using the condition.

Then I initialize a variable of type array and in the Apply to each Append the File content and the FileName to it.

Then outside the loop, I Send an email and pass the Array.

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
DEJ 16 on at

Like (0)

Report
Copy link

Link copied!

Hi Fernandes.

I was not all clear but as you see in my old flow, it sends email if it findes xlsx file but ALSO if it doenst find any file.

but thanks for your quick soloution for me.

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

Like (0)

Report
Copy link

Link copied!

@DEJ

Hey Mate,

I have already shared my solution with you(give it a shot, it will take you 30 minutes at the most to create it). If it works for you or if you think it will help other, 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
DEJ 16 on at

Like (0)

Report
Copy link

Link copied!

Hi..

The text in schema for JSON part is not visible or clear for me ?

Also I cant choose "Filenamewith..." in the append to variable array box

and here I think something is wrong, I want to look in a folder but it wants me to point out a specific file.

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

Like (0)

Report
Copy link

Link copied!

@DEJ For the 'Get File Content' you need to pass the {identifier} the identifier will get the XLSX file from the Folder .

Was this reply helpful? Yes No
DEJ 16 on at

Like (0)

Report
Copy link

Link copied!

Dear Fernandes

AS you see on the screenshots, I am missing few points.

Schema code???
File indentifier for Get file content is not in my list.
Value code for array varible

Was this reply helpful? Yes No
Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@DEJ

To get the JSON schema,

Add a compose action and pass it the Body -Output of the Filter array action.

RUN the Flow, copy the Output of the compose action.

Add the Parse JSON, click on Generate from Sample, and paste the above content.

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