Power Automate Part 5 - Variables and Basic Arrays

preview_player
Показать описание
By Andy Brown

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This tutorial is the first of a series of 3. It explains what variables are in Power Automate and how to use them, and also gives example of setting and collapsing arrays. The next two tutorials in the series will show how to tidy up flows to make them neater and more elegant, and how to add conditions to test expressions in flows.

Chapters
00:00 Topic list
00:57 What this tutorial shows (OneDrive vs. SharePoint file counts)
03:21 The variables we need to create, and how variables work
06:14 Initialising the variables for OneDrive
08:59 Getting an array of the OneDrive files
12:19 Collapsing this array
15:56 Counting the files in the array
17:59 Repeating the above steps for SharePoint files

Рекомендации по теме
Комментарии
Автор

That part when expressions do not give a hint about variables is crazy xD also in VBA it is so simple to count files and here we have to create multiple steps... If I had to I would use VBA all the time but it seems life ain't that easy :D
I appreciate the video. You are such a great tutor. Your content is second to none!!!!

enrikekasijas
Автор

how did you format the input for file identifier on the 'get files in this sharepoint folder' step? I'm having trouble getting that step to work :(

gden-draft
Автор

does the SharePoint portion work with SharePoint Lists, or only with a folder of documents? if not, is there a way to change this process to work the same with a SharePoint List or maybe even to return the number of items in a List with a specific label or value in a certain field?

gden-draft
Автор

I have a quick question. I am trying to pull company data in excel through excel VBA like Cash, Assets etc and do you think it is possible to access the SEC edgar API using Excel VBA? I just want to get your opinion before I fall down the Rabitt whole.

mellowjello
Автор

Hello, for Power Automate flow, could you please provide some direction on how can I set up a scheduled flow where I can email a report on certain work day of the month (say 2nd work day of each month). Thank you!

zm
Автор

Power automate or Uipath ? Which one is best for automation in your opinion?

mahmudurrahman