Flow / Power Automate - Leverage Variables with Power FX in Power Automate Tutorial

Discover the power of leveraging variables with Power FX in Power Automate. Learn how to list channel files based on date constraints, transform monthly flows into weekly ones, and use Power FX functions for dynamic date manipulations. Explore the comprehensive tutorial for effective flow activation and message posting in your team channel. Unlock the potential of Power Automate for efficient workflow management!

  • 03:28
  • 18 views
00:00:03
we will explore power FX functions that enable various types of calculations.
00:00:08
We will start with an existing flow that lists
00:00:11
the files of a team's channel in a message
00:00:14
adding a date constraint to it
00:00:16
specifically,
00:00:17
we will list the files from a channel only
00:00:19
if they were created within the last seven days
00:00:23
to begin, duplicate an existing flow that does not have this constraint.
00:00:28
This flow is from a previous tutorial
00:00:31
from the context menu. Perform a save as and rename the copy explicitly.
00:00:36
Once done, click on the pencil icon to edit this flow.
00:00:41
This flow is monthly and recurrent transform it
00:00:44
into a weekly flow every Monday at 10 a.m.
00:00:48
In this flow, you will find a variable used to generate the list of channel files
00:00:53
to remain organized,
00:00:54
change the label of the initialization block for this variable.
00:00:59
Next, add an action to generate a new variable
00:01:05
to store the date seven days prior to the current date.
00:01:08
Here, you will use a power FX function via the FX button
00:01:15
in the window. You will find power FX functions categorized by themes.
00:01:20
Note that there is no assistant here. Just a brief description.
00:01:24
It is common to have to search the web to
00:01:26
determine if a function exists and to gather syntactic information.
00:01:31
In this instance,
00:01:32
the add days function allows you to add or
00:01:35
subtract a number of days associated with a date.
00:01:39
Select the function enter the parentheses and supply the
00:01:42
arguments of this function according to the expected syntax.
00:01:45
Using the UTC. Now function which dynamically refers to the current date.
00:01:51
The second parameter separated by a comma will contain minus seven,
00:01:56
the number of days to subtract followed by the format parameter.
00:02:03
Now in the loop processing each file from the channel,
00:02:06
add a conditional if action based on
00:02:09
the files creation date to populate your variable
00:02:12
listing the files only if they are created on or after seven days ago.
00:02:17
That is
00:02:18
the previous Monday
00:02:21
retrieve the dynamic content related to the creation date by
00:02:24
specifying greater and equal to your previously created date.
00:02:28
Variable
00:02:30
then drag the block populating the variable,
00:02:32
listing the files into the case where the condition is met.
00:02:36
Take this opportunity to add a second conditional
00:02:39
block to avoid posting a team's message.
00:02:41
If no file has been added,
00:02:44
test your message block containing your list of files less than seven days
00:02:49
old by specifying that it must not be empty to post the team's message
00:02:54
which you will drag into the condition.
00:02:56
Also add an introductory sentence
00:03:00
on the team side, add two files from your desktop to the relevant team,
00:03:05
all that remains is to save and test the flow
00:03:09
power automate. Will inform you that the flow is not active
00:03:13
in the list of your flows, activate it and run it
00:03:16
in your team channel.
00:03:17
You will see a post containing only the two newly created files from now
00:03:22
on your flow is active and will post a message every Monday if needed.

No elements match your search in this video....
Do another search or back to content !

 

DiLeaP AI: THIS MIGHT BE HELPFUL

Reminder

Show