#Flow – How To iterate through collections of elements (#Excel, #Sharepoint, and more…)

Hello!

A very common scenario when we work with Microsoft Flow is to work with collections of elements. These may be rows in Excel, Sharepoint lists, or other collections. Usually, in these scenarios, we tried to do is to work individually with each one of the items in the collection.

If we use an Excel as an example, we can see that we have the action “Get Rows”. This action opens an Excel file, reads a table and returns a pointer with the collection of rows in the Table. The next thing we have to do is select an action of type “Apply to Each” which will allow us to iterate through the elements of the collection.

In the next picture, we can see a couple of steps in a Flow definition. Start with open an Excel file, then select the output from the previous step named “Value”. “Value” represents each of the rows in Excel the table opened in the previous step.

clipboard07

The next thing is to work with every “value”. For example, insert the contents of the Excel table into a Sharepoint list.

Note: Here we miss functionality as the of AutoMapper (link), which in the case of entities in the .net saves us a lot of work.

 

clipboard05

We can think of a different scenario, where we need to conduct any assessment for each row in Excel, for example, single recording rows that match a value “Monday” for the day at Excel column in Sharepoint.

clipboard09

And, if an IF not enough also you can test your monitor resolution with a fantastic graphic SWITCH!

clipboard11

Greetings @ Toronto

El Bruno

References

39 comments

  1. Pingback: #Flow – “Guardar como” e integración con botones reales: Flic y Bttn – El Bruno
  2. Pingback: #Flow – “Save as ” and interaction with physical buttons: #Flic and #Bttn – El Bruno
  3. Pingback: #Flow – Ahora con soporte para #ComputerVision #CognitiveServices – El Bruno
  4. Pingback: #Flow – New action definition to use #ComputerVision operations. #CognitiveServices – El Bruno
  5. Pingback: #Flow – Buttons Widgets para iOS y Android – El Bruno
  6. Pingback: #Flow – Buttons Widgets in iOS and Android – El Bruno
  7. Pingback: #Flow – Gestionando excepciones o errores en un Flow – El Bruno
  8. Pingback: #Flow – Manage errors, exceptions, timeouts and more on a Flow definition – El Bruno
  9. Pingback: #Flow – Manejo simple de variables en Microsoft Flow – El Bruno
  10. Pingback: #Flow – Working with variables in #MicrosoftFlow – El Bruno
  11. Pingback: #Flow – Opciones avanzadas en HTTP Action con #MicrosoftFlow, Headers, Authentication y más ! – El Bruno
  12. Pingback: #Flow – Advanced options to work with HTTP Actions in #MicrosoftFlow, Headers, Authentication and more! – El Bruno
  13. Pingback: #Flow – HowTo lanzar un Button Flow desde un navegador – El Bruno
  14. Pingback: #Flow – How To emulate a Button for a Flow using a Browser – El Bruno
  15. Pingback: #Flow – Exportar e Importar definiciones de Flow con algunas opciones avanzadas – El Bruno
  16. Pingback: #Flow – Export and Import Flow definitions with advanced options – El Bruno
  17. Pingback: #Flow – Trabajando con expresiones (esto sube la productividad un 50% !) – El Bruno
  18. Pingback: #Flow – Working with expressions (50% more of power!) – El Bruno
  19. Pingback: #Flow – Nuevas opciones en Flow Button con listas de opciones como datos de entrada – El Bruno
  20. Pingback: #Flow – New input options when using Flow Button: list of choices – El Bruno
  21. Pingback: #Flow – Comenzar un Flow asociado a un elemento en una lista de #Sharepoint – El Bruno
  22. Pingback: #Flow – Trigger a Flow associated to an item in a #SharePoint list – El Bruno
  23. Pingback: #Flow – Controla el estado de tus Apps en #Azure Con #ApplicationInsights y #MSFlow – El Bruno
  24. Pingback: #Flow – Check your Apps health in #Azure using #ApplicationInsights and MSFlow – El Bruno
  25. Pingback: #LogicApps – Intro y diferencias con Microsoft Flow #MSFlow – El Bruno
  26. Pingback: #LogicApps – Introduction and main differences with Microsoft Flow #MSFlow – El Bruno
  27. Pingback: #LogicApps – Creando nuestra primera Logic App en #Azure – El Bruno
  28. Pingback: #LogicApps – Let’s create our first Logic App in #Azure – El Bruno
  29. Pingback: #LogicApps – Trabajando con Visual Studio 2017 y LogicApps #VS2017 – El Bruno
  30. Pingback: #LogicApps – Working with Visual Studio 2017 and Logic Apps #VS2017 – El Bruno
  31. Pingback: #Flow – How To iterate through collections of elements (#Excel, #Sharepoint, and more…) – El Bruno « Thinking Enterprise Solutions
  32. Pingback: #Flow – Analizando imágenes en 3 pasos con Microsoft Flow y Computer Vision #CognitiveServices – El Bruno
  33. Pingback: #Flow – Analyzing images in 3 steps with Microsoft Flow and Computer Vision #CognitiveServices – El Bruno

  34. Hello,

    I have a smililar requirement where I have to read all the rows in the excel file (uploaded in SharePoint doc library). There is a date column and a complain id column. If the complain id column is blank, 24 hours after the date (mentioned in the date column) it will trigger a mail to the person’s mail Id mentioned in the another column.

    Looking forward to your resoponse.

    Thanks in Advanve.

    -Sahadev

    Like

    Reply
  35. Pingback: #Flow – Reasignado una tarea de aprobación – El Bruno
  36. Pingback: #Flow – New feature: Approval reassignment – El Bruno
  37. Pingback: #Flow – Analizando imágenes en Listas de #Sharepoint utilizando #CognitiveServices – El Bruno
  38. Pingback: #Flow –Analyzing images in #Sharepoint Lists using #CognitiveServices – El Bruno

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.