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
8 views

Available in Microsoft365

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.

DiLeaP AI: THIS MIGHT BE HELPFUL

Teams Premium - Activate the features of Teams Premium

In this video, you will learn how to activate the features of Teams Premium.
The video covers the necessary steps to fully enjoy all that Teams Premium has to offer.
It explains that Teams Premium requires an additional paid license, which must be assigned to a user in Microsoft 365 administration.
The video demonstrates how to join the admin and access the team-specific admin center, where you can manage Teams settings such as meetings, webinars, messaging, and security.
It also highlights the administration app in the Teams navigation menu, which includes a dashboard with additional settings.
To access the new features specific to Teams Premium, you can find them directly in your Teams application.
If some features don't appear, it is recommended to restart Teams and check for software updates.
Activating Teams Premium will enhance your Teams experience and provide access to advanced features.

3:48
10763 views

Outlook - How do I share a document securely with Outlook?

In this video, you will learn how to securely share a document with Outlook.
Instead of attaching the document to your email, it is safer to add it to your OneDrive or SharePoint library.
This allows you to set permissions for who can view and edit the document.
When you share the link to your document from Outlook, the permissions you set in OneDrive or SharePoint are retained.
You can easily change the sharing permissions in the attachment drop-down menu.
Regularly checking and updating the permissions ensures the safety of your document.
This tutorial will help you securely share documents using Outlook in Microsoft 365.

1:49
2900 views

Project Online - Discovering the interface

In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and easily find documents, information, and people within the Microsoft 365 suite.

4:51
4293 views

FindTime - Create a scheduling poll

Discover how to create a meeting poll in this video titled "Creating a scheduling poll" This resource is designed for intermediate-level learners looking for effective ways to communicate and manage their time.

You will learn how to create an interactive poll to gather opinions and preferences from meeting participants. This skill will enable you to facilitate decision-making and organize more productive meetings.

Don't miss this opportunity to enhance your communication and time management skills.

4:12
4111 views

Outlook - How do I recognize a fraudulent email?

In this video, you will learn how to recognize a fraudulent email and protect yourself from phishing attacks.
Phishing emails often mimic legitimate ones, using logos and information from reputable companies.
However, there are usually spelling errors, a haphazard layout, or inconsistencies with the company's graphic design.
Pay attention to the sender's email address, as it may not match the company's domain.
Be cautious if the sender's name consists of random letters and numbers.
Avoid clicking on links that ask you to renew your account or provide personal or banking information.
Even clicking on a link can install malware on your computer.
If you have any doubts, contact the company using secure contact information from their official website.
This knowledge will help you stay safe online and protect your personal information.

2:01
2567 views

RELATED COURSES This tutorial is part of the following courses

Microsoft Video Training Power Automate – From discovery to mastering automation

Boost your productivity with our Power Automate course! Learn to automate your tasks and seamlessly integrate various Microsoft 365 services.

Your trainer for this course
Cours E-learning

3 Views

ALL COURSES