cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ni
Level: Powered On

Condition with outlook and excel for each loop

Hello,

 

For the shipment agenda we would like to create events based on Excel rows. These Excel rows needs to be compared with excisting event items, to prevent duplicates in the calendar. We have tested the flow (whitout errors) but no event is created in Outlook calendar. My idea was to compare the values in the excel with the events, but it seems like the recurrend step doesn't work and is needed to prevent multiple duplicates. I tried to add an email check on both ends of the condition, but no mail was recieved. Last screen is of excel rows that needs to be created as events. The PowerApps key gets automatically added by Power Automate to the excel table. Does anyone knows what's going wrong?

Stroom1.JPGStroom2.JPG

ExcelVracht.png

3 REPLIES 3
Highlighted
Community Support Team
Community Support Team

Re: Condition with outlook and excel for each loop

 

Hi @Ni ,

 

As far as I know, Get rows action has been removed, and now we can only use List rows present in a table action to get all the rows.

 

If you want to avoid duplicate events being created, you can use the following method to configure Flow.

28.PNG29.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ni
Level: Powered On

Re: Condition with outlook and excel for each loop

Hi @v-bacao-msft,

 

Thanks for your quick response.

 

We've reconstructed the flow you sent, but now it looks like the outcome of the condition is always yes.

 

Our flow is as follows.

 

I have already tried to fill in 'Filter_array', should this work differently in the background.

 

Do you have a clue why the condition always results in a "yes". Scr1.pngScr2.png

Community Support Team
Community Support Team

Re: Condition with outlook and excel for each loop

 

Hi @Ni ,

 

The result of the Condition is true because the Body of the Filter array is an empty array.

 

So the result of the length() function is 0, which seems to be the expected result.

 

The result of the Filter array indicates that there are no eligible records in the table.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (8,220)