cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RezzaB
Helper III
Helper III

Date is correct but output states false

Hi 

 

Flow saves and the test succeeds but the date in the flow states false but it should be true and an email should be sent. I am not sure why it is saying false?

 

Here is the list:

RezzaB_0-1691713220655.png

 

Here is the flow:

RezzaB_1-1691713266474.png

 

RezzaB_2-1691713391581.png

 

Here is the flow

RezzaB_3-1691713530145.png

 

 

Other people have provided me other ways to do this flow, but they have been complicated and still do not work for me no matter what I do. I would like a simple flow to send a email when the date in the list is todays date. I have seen a youtube of this exact flow and works but just will not for me!!

 

Cheers,

Renee

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

@RezzaB 

Create a Dynamic Date

Please note: The Scope action is optional. Not required, but I use them in my flows to keep things organized. 

 

Not sure when you plan to run this flow but it's always best to ensure that the time zone matches which is why I use the Convert time zone action.

 

For the Base Time field you need to insert an expression. 

 

 

utcNow()

 

 

The utcNow() function will return the current date and time. 

 

For the source time zone, select (UTC) Coordinated Universal Time. Select the appropriate destination time zone to match your time zone. In the Format String field, select Round-trip.

creativeopinion_1-1692024354316.png

 

The next two actions we'll use to compose your dynamic date. This is the date we'll use to check against the 4 date columns in your SP list.

 

In the first compose action, insert the number of days to add or remove from today. If you want to remove days enter a negative number. In your case, you need to add days. So you will need to enter a 3 into the Compose action.

creativeopinion_1-1692055787490.png

 

The next compose action will store the expression that will create the date that is 3 days from today.

creativeopinion_3-1692024632228.png

'To do this you need to start with the addDays() function. Make sure you have the Expression tab selected. 

 

There are three parts to this function. You'll be using dynamic content for the first two: original date and days to add/remove.

 

 

addDays([orginal date],[days to add/remove],[dateformat])

 

 

creativeopinion_4-1692024669838.png

 

Switch to the Dynamic content tab. Make sure your cursor is in between the parentheses. Locate the Converted time dynamic content and select it to insert it into the expression.

creativeopinion_5-1692024753495.png

Add a comma after the dynamic content and insert the outputs from the Compose action.

creativeopinion_6-1692024802730.png

 

Add another comma and single quotes. In between the single quotes enter a date format. It can be any date format.

 

Confirm the output of your birthday column to check the format of the date. The output of my date column is as follows 'yyyy-MM-dd'.

creativeopinion_2-1691715613437.png

 

By formatting today's date in a similar way MM-dd I used the Filter Array action to see if the date contains 08-10. I will enter MM-dd between the single quotes.

 

Press OK to add the expression to the Compose action. Note: My screenshot says Update since I already had the expression.

creativeopinion_2-1692055817344.png

 

creativeopinion_8-1692024995516.png

 

Run a test.

 

Check the outputs of your Dynamic Date Compose action. The date being displayed should match your expression, so since you are looking for a date 3 days from today, it should display 08-17.

creativeopinion_0-1692055748931.png

Add a Filter Array Action

In your Filter Array action insert the value dynamic content from the Get Items action, in the first value field, insert the birthday dynamic content. My column name is Birthdate.

To Filter by One Date

Insert the Outputs from the Dynamic Date Compose Action. 

 

creativeopinion_3-1692055953915.png

 

To Filter by Two Dates

If you want to send an email a few days in advance AND on the day of the birthday. You need to use an expression. 

 

You can start in the basic mode first by following the instructions above. Press the Edit in advanced mode button.

creativeopinion_0-1692282093511.png

Copy the expression to your clipboard and paste it into a text editor. DO NOT try to edit in the advanced mode editor—use a text editor. 

creativeopinion_1-1692282166066.png

Switch back to basic mode. I created an additional Compose action to store Today's date. Follow the same instructions as I provided for using the addDays() function. Except you'll just replace the addDays() function with a formatDateTime() function. 

creativeopinion_3-1692282509454.png

The format of the date will need to be the same : 'MM-dd'

creativeopinion_4-1692282526376.png

Replace the original Outputs dynamic content (from the Compose action with the date 3 days prior to the birthdate) with the Outputs dynamic content from the Compose action with today's date). 

creativeopinion_2-1692282403207.png

Switch back into the advanced mode. Copy and paste that expression into your text editor.

creativeopinion_5-1692282674037.png

 

First, delete the second @ symbol. and put a comma between the two expressions.

creativeopinion_6-1692282724019.png

 

Put your cursor after the first @ symbol, and wrap the entire expression in an or() function.

creativeopinion_7-1692282902979.png

Copy this entire expression from the text editor back into the Filter Array action.

 

Add a Compose action to store the count of items returned from your Filter Array action. Use the length() function and insert the body outputs from the Filter Array action. 

 

creativeopinion_3-1691715675582.png

Add a Condition to check if any items are returned. I'm checking to see if the length of items returned is not equal to 0. If true, items have been returned. 

 

Run a test.

 

In the YES branch, add an Apply to Each action. Use this action to loop through the Body outputs from the Filter Array action. By using a Filter Array action outputs, you are only looping through items that match your conditions (birthday is today) rather than looping through every item returned from the Get Items action. 

 

creativeopinion_4-1691715967404.png

Next, add a Compose action to compose the outputs from the Filter Array body. You will need an expression for this. 

 

Take a look at the outputs from a previous flow run. The text you need for your expressions are in red between double quotes. 

creativeopinion_5-1691716234186.png

For example, I'm using a single text field for the first name and last name. 

In my Compose action, I'll add an expression, each expression will start the same: 

 

 

item()?['']

 

 

In the single quotes is where you will insert the red text. For the first name, the expression would look like this:

 

 

item()?['FirstName']

 

 

In my SP list, I'm using a column to store the users profile in a Person column. To access the email, the expression will look a bit different.

creativeopinion_6-1691716445978.png

creativeopinion_7-1691716480012.png

 

 

 

 

item()?['Profile']['Email']

 

 

I would recommend composing all the content you need for your email with Compose actions then running a test first. Before you move onto the next steps.

creativeopinion_1-1692326995961.png

 

Tip: If your flow is sending a reminder # days prior to the birthday as well as on the actual day of the birthday, create a Compose action to store the employee's birthday.

formatDateTime(item()?['INSERT YOUR BIRTHDAY COLUMN INTERNAL NAME'],'MM-dd')

creativeopinion_8-1692283861879.png

Checking for 3 Days Prior to and Today (optional)

Add a Condition to check if the day is equal to today if you'd like to use dynamic text in your email. Instead of creating two Send Email actions to send an email 3 Days prior and on the day of... you can use dynamic content instead to adjust the text in the email. This way, you only need to use ONE Send an Email action (rather than two).

 

If you are only checking for ONE date, you can move onto the Send an Email step.

First Value Field – Employee Birthday

Insert the outputs from the Compose action that is storing the Employee Birthdate. Since these actions are nested in the Apply to Each loop (which loops through each employee that has been filtered out by the Filter Array action), this Compose action will have the birthday of the current employee being looped through. The compose action is optional. If you choose not to use it, you'll need to format the birthday of the current Employee you are looping through so it matches the format: 'MM-dd'. Use a formatDateTime() function to wrap the birthday date of the employee. 

Second Value Field – Today's Date

Since we'll be using a variable to store the dynamic text (3 days prior or Today) we are using the condition to set the text based on whether or not the employee's birthday is today. To compare the employee's birthday to today, you need to insert the output from the Compose action that is storing today's date into the second value field. 

 

The condition reads:

If EMPLOYEE BIRTHDAY ('MM-dd') is equal to TODAY ('MM-dd').

 

creativeopinion_0-1692371149535.png

 

Initialize & Set Variables

If you are using variables in your flow, you need to initialize a String Variable at the root level of the flow (near the top). 

creativeopinion_11-1692284105245.png

 

For clarification, the Condition action needs to be added inside the Apply to Each loop. Remember that the Apply to Each loop is looping through EACH employee returned from the Filter Array action.

 

In each of the Condition branches you need to set your string variable. 

 

The condition reads:

If EMPLOYEE BIRTHDAY ('MM-dd') is equal to TODAY ('MM-dd').

 

  • YES BRANCH
    Set the text variable to Today. If the condition above is TRUE, then that means the employee's birthday is today.
  • NO BRANCH
    Set the text variable to in 3 days*. If the condition above is FALSE, then that means the employee's birthday is in 3 days.

*Adjust this to suit your flow. If you're sending out a reminder 5 days, adjust the text accordingly.

 

You'll be using the variable in your email. For example: John Smith's Birthday is [variable goes here]. Whatever text you put in your variable will be displayed wherever you use it. 

 

 

 

creativeopinion_2-1692371854031.png

 

Compose Email Body

You can compose the body of your email in a Compose action this way you can run a test to see what it looks like before even adding the Send an Email (V2) action to your flow. Make sure to add action is outside of the Condition action but inside the Apply to Each loop.

 

Tip: Because my text variable is formatted in this way: 'Today' / 'in 3 Days' I need to convert that text to lower case to use in my email body.

 

Otherwise part of my email body will display like this:

John Smith's birthday is Today -- or -- John Smith's birthday is in 3 Days. The text case is incorrect when used in a sentence. This is okay for a subject line in an email... but not in the body of the email (as shown below).

 

I used a toLower() function to do this.

toLower([insert variable here])

creativeopinion_3-1692372105250.png

 

Send an Email

Add a Send an email (V2) action after the Compose action. This action should be added inside the Apply to Each loop as you will be sending an email for each employee birthday that matches your criteria. 

 

Customize the email to suit your needs. 

 

Tip: Always add your own email address into the To field. 

creativeopinion_3-1692327251877.png

After you've run your tests and confirmed everything is working can you replace the email address with the outputs from the Compose action that are holding the Manager's Email address (or the actual recipient of the email).

 

This is why I prefer to use Compose actions. You will have already confirmed that the actual recipient is correct (if you tested with a Compose action before adding the Send Email action).

 

Once you've done your test, you can insert the outputs dynamic content into the Send an Email action.

creativeopinion_4-1692327635670.png

 

Hope this helps!

 

If I helped you solve your problem—please mark my post as a solution .
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

 

 

 

 

View solution in original post

You need to refer to my post from Sunday. Your send email action is incorrect.

 

You can't use dynamic content from the Get Items action. You need to use a expression to access the values from the Filter Array action. 

 

Take a look at your Apply to Each action. What is it looping though? It is looping through all the values in your SharePoint list, NOT the items that have been filtered. 

 

This is why you are getting tons of emails. You are getting emails for each item in your SharePoint list, when you should be getting an email for each FILTERED ITEM. 

View solution in original post

33 REPLIES 33

@RezzaB 

Can you add a Compose action above the Condition to store the Birthday dynamic content? You will need to use an expression so the format matches. You need to format the date so it matches the date you are comparing to.

 

For example, you are comparing August 11, 2020 to 11-08 which is not a match = false.

SudeepGhatakNZ
Multi Super User
Multi Super User

Use formatDateTime function with the 'yyyy-MM-dd' format on both sides of your condition

SudeepGhatakNZ_0-1691714831527.png

 

If my suggestion helped you, please give it a Thumbs up and Mark it as a Solution so that it can benefit others in the community.
Sudeep Ghatak
Microsoft MVP, Business Applications
www.sudeepghatak.com

@RezzaB 

Create a Dynamic Date

Please note: The Scope action is optional. Not required, but I use them in my flows to keep things organized. 

 

Not sure when you plan to run this flow but it's always best to ensure that the time zone matches which is why I use the Convert time zone action.

 

For the Base Time field you need to insert an expression. 

 

 

utcNow()

 

 

The utcNow() function will return the current date and time. 

 

For the source time zone, select (UTC) Coordinated Universal Time. Select the appropriate destination time zone to match your time zone. In the Format String field, select Round-trip.

creativeopinion_1-1692024354316.png

 

The next two actions we'll use to compose your dynamic date. This is the date we'll use to check against the 4 date columns in your SP list.

 

In the first compose action, insert the number of days to add or remove from today. If you want to remove days enter a negative number. In your case, you need to add days. So you will need to enter a 3 into the Compose action.

creativeopinion_1-1692055787490.png

 

The next compose action will store the expression that will create the date that is 3 days from today.

creativeopinion_3-1692024632228.png

'To do this you need to start with the addDays() function. Make sure you have the Expression tab selected. 

 

There are three parts to this function. You'll be using dynamic content for the first two: original date and days to add/remove.

 

 

addDays([orginal date],[days to add/remove],[dateformat])

 

 

creativeopinion_4-1692024669838.png

 

Switch to the Dynamic content tab. Make sure your cursor is in between the parentheses. Locate the Converted time dynamic content and select it to insert it into the expression.

creativeopinion_5-1692024753495.png

Add a comma after the dynamic content and insert the outputs from the Compose action.

creativeopinion_6-1692024802730.png

 

Add another comma and single quotes. In between the single quotes enter a date format. It can be any date format.

 

Confirm the output of your birthday column to check the format of the date. The output of my date column is as follows 'yyyy-MM-dd'.

creativeopinion_2-1691715613437.png

 

By formatting today's date in a similar way MM-dd I used the Filter Array action to see if the date contains 08-10. I will enter MM-dd between the single quotes.

 

Press OK to add the expression to the Compose action. Note: My screenshot says Update since I already had the expression.

creativeopinion_2-1692055817344.png

 

creativeopinion_8-1692024995516.png

 

Run a test.

 

Check the outputs of your Dynamic Date Compose action. The date being displayed should match your expression, so since you are looking for a date 3 days from today, it should display 08-17.

creativeopinion_0-1692055748931.png

Add a Filter Array Action

In your Filter Array action insert the value dynamic content from the Get Items action, in the first value field, insert the birthday dynamic content. My column name is Birthdate.

To Filter by One Date

Insert the Outputs from the Dynamic Date Compose Action. 

 

creativeopinion_3-1692055953915.png

 

To Filter by Two Dates

If you want to send an email a few days in advance AND on the day of the birthday. You need to use an expression. 

 

You can start in the basic mode first by following the instructions above. Press the Edit in advanced mode button.

creativeopinion_0-1692282093511.png

Copy the expression to your clipboard and paste it into a text editor. DO NOT try to edit in the advanced mode editor—use a text editor. 

creativeopinion_1-1692282166066.png

Switch back to basic mode. I created an additional Compose action to store Today's date. Follow the same instructions as I provided for using the addDays() function. Except you'll just replace the addDays() function with a formatDateTime() function. 

creativeopinion_3-1692282509454.png

The format of the date will need to be the same : 'MM-dd'

creativeopinion_4-1692282526376.png

Replace the original Outputs dynamic content (from the Compose action with the date 3 days prior to the birthdate) with the Outputs dynamic content from the Compose action with today's date). 

creativeopinion_2-1692282403207.png

Switch back into the advanced mode. Copy and paste that expression into your text editor.

creativeopinion_5-1692282674037.png

 

First, delete the second @ symbol. and put a comma between the two expressions.

creativeopinion_6-1692282724019.png

 

Put your cursor after the first @ symbol, and wrap the entire expression in an or() function.

creativeopinion_7-1692282902979.png

Copy this entire expression from the text editor back into the Filter Array action.

 

Add a Compose action to store the count of items returned from your Filter Array action. Use the length() function and insert the body outputs from the Filter Array action. 

 

creativeopinion_3-1691715675582.png

Add a Condition to check if any items are returned. I'm checking to see if the length of items returned is not equal to 0. If true, items have been returned. 

 

Run a test.

 

In the YES branch, add an Apply to Each action. Use this action to loop through the Body outputs from the Filter Array action. By using a Filter Array action outputs, you are only looping through items that match your conditions (birthday is today) rather than looping through every item returned from the Get Items action. 

 

creativeopinion_4-1691715967404.png

Next, add a Compose action to compose the outputs from the Filter Array body. You will need an expression for this. 

 

Take a look at the outputs from a previous flow run. The text you need for your expressions are in red between double quotes. 

creativeopinion_5-1691716234186.png

For example, I'm using a single text field for the first name and last name. 

In my Compose action, I'll add an expression, each expression will start the same: 

 

 

item()?['']

 

 

In the single quotes is where you will insert the red text. For the first name, the expression would look like this:

 

 

item()?['FirstName']

 

 

In my SP list, I'm using a column to store the users profile in a Person column. To access the email, the expression will look a bit different.

creativeopinion_6-1691716445978.png

creativeopinion_7-1691716480012.png

 

 

 

 

item()?['Profile']['Email']

 

 

I would recommend composing all the content you need for your email with Compose actions then running a test first. Before you move onto the next steps.

creativeopinion_1-1692326995961.png

 

Tip: If your flow is sending a reminder # days prior to the birthday as well as on the actual day of the birthday, create a Compose action to store the employee's birthday.

formatDateTime(item()?['INSERT YOUR BIRTHDAY COLUMN INTERNAL NAME'],'MM-dd')

creativeopinion_8-1692283861879.png

Checking for 3 Days Prior to and Today (optional)

Add a Condition to check if the day is equal to today if you'd like to use dynamic text in your email. Instead of creating two Send Email actions to send an email 3 Days prior and on the day of... you can use dynamic content instead to adjust the text in the email. This way, you only need to use ONE Send an Email action (rather than two).

 

If you are only checking for ONE date, you can move onto the Send an Email step.

First Value Field – Employee Birthday

Insert the outputs from the Compose action that is storing the Employee Birthdate. Since these actions are nested in the Apply to Each loop (which loops through each employee that has been filtered out by the Filter Array action), this Compose action will have the birthday of the current employee being looped through. The compose action is optional. If you choose not to use it, you'll need to format the birthday of the current Employee you are looping through so it matches the format: 'MM-dd'. Use a formatDateTime() function to wrap the birthday date of the employee. 

Second Value Field – Today's Date

Since we'll be using a variable to store the dynamic text (3 days prior or Today) we are using the condition to set the text based on whether or not the employee's birthday is today. To compare the employee's birthday to today, you need to insert the output from the Compose action that is storing today's date into the second value field. 

 

The condition reads:

If EMPLOYEE BIRTHDAY ('MM-dd') is equal to TODAY ('MM-dd').

 

creativeopinion_0-1692371149535.png

 

Initialize & Set Variables

If you are using variables in your flow, you need to initialize a String Variable at the root level of the flow (near the top). 

creativeopinion_11-1692284105245.png

 

For clarification, the Condition action needs to be added inside the Apply to Each loop. Remember that the Apply to Each loop is looping through EACH employee returned from the Filter Array action.

 

In each of the Condition branches you need to set your string variable. 

 

The condition reads:

If EMPLOYEE BIRTHDAY ('MM-dd') is equal to TODAY ('MM-dd').

 

  • YES BRANCH
    Set the text variable to Today. If the condition above is TRUE, then that means the employee's birthday is today.
  • NO BRANCH
    Set the text variable to in 3 days*. If the condition above is FALSE, then that means the employee's birthday is in 3 days.

*Adjust this to suit your flow. If you're sending out a reminder 5 days, adjust the text accordingly.

 

You'll be using the variable in your email. For example: John Smith's Birthday is [variable goes here]. Whatever text you put in your variable will be displayed wherever you use it. 

 

 

 

creativeopinion_2-1692371854031.png

 

Compose Email Body

You can compose the body of your email in a Compose action this way you can run a test to see what it looks like before even adding the Send an Email (V2) action to your flow. Make sure to add action is outside of the Condition action but inside the Apply to Each loop.

 

Tip: Because my text variable is formatted in this way: 'Today' / 'in 3 Days' I need to convert that text to lower case to use in my email body.

 

Otherwise part of my email body will display like this:

John Smith's birthday is Today -- or -- John Smith's birthday is in 3 Days. The text case is incorrect when used in a sentence. This is okay for a subject line in an email... but not in the body of the email (as shown below).

 

I used a toLower() function to do this.

toLower([insert variable here])

creativeopinion_3-1692372105250.png

 

Send an Email

Add a Send an email (V2) action after the Compose action. This action should be added inside the Apply to Each loop as you will be sending an email for each employee birthday that matches your criteria. 

 

Customize the email to suit your needs. 

 

Tip: Always add your own email address into the To field. 

creativeopinion_3-1692327251877.png

After you've run your tests and confirmed everything is working can you replace the email address with the outputs from the Compose action that are holding the Manager's Email address (or the actual recipient of the email).

 

This is why I prefer to use Compose actions. You will have already confirmed that the actual recipient is correct (if you tested with a Compose action before adding the Send Email action).

 

Once you've done your test, you can insert the outputs dynamic content into the Send an Email action.

creativeopinion_4-1692327635670.png

 

Hope this helps!

 

If I helped you solve your problem—please mark my post as a solution .
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

 

 

 

 

Thanks @creativeopinion how do I get it to match? I see your other post and it is very complicated for my beginner level of power automate. I just want to get the dates to match so it = true

I've outlined the instructions below. This is what your flow should look like.

creativeopinion_0-1691720331124.png

Details for each action are listed in my previous post.

Morning @creativeopinion I am following your steps.

Date is same format as yours 

RezzaB_0-1691969007174.png

 

I am stuck at this step...

RezzaB_1-1691969080613.png

What is the formula for  this expression please?

Cheers,

Renee

It's just the length() function. In between the parentheses you need to insert the body outputs from the Filter Array action. 

 

The length() function will return the number of items from the Filter Array action. 

creativeopinion_0-1691970657130.png

 

 

Thanks @creativeopinion 

Now I am getting a flow failed:

RezzaB_0-1691973507032.png

 

RezzaB_2-1691973727213.png

Cheers,

Renee

 

Can you confirm if all of your items in your SharePoint list contain a birthday? In this screenshot of the Filter Array action, please scroll down to the Birthday column (look for red text that has Birthday). I'd like to see what the inputs are. 

creativeopinion_0-1691979198366.png

 

Also, can you confirm the what the outputs from the Compose - Today's Date Month and day action are? Please screenshot the outputs from your last flow run.

No, not all employees have a birthday date. The list is for birthdays as well as work anniversaries and for employees who do not want their birthday acknowledged, I have left it blank. I have left it blank as I don't want managers to be emailed via this workflow to ask them to email a birthday wish to their team member. Is there another way around this? 

 

Here you go:

RezzaB_0-1691981334317.png

 

 Cheers,

Renee

Yes you need to add a Filter Query to the Get Items action to filter out items that do not contain a birthday. When possible it's always best practice to use the filter query in the Get Items action to reduce the number of items being returned.

 

Important: Replace Birthdate with the internal column name of your birthday column. 

creativeopinion_0-1691981666495.png

 

To find the internal column name of your column, you need to go to your list settings and click on the column name. Watch this portion of my most recent YT Tutorial for instructions on how to do this.

RezzaB
Helper III
Helper III

woo hoo, thanks, we have success:

RezzaB_0-1691982035534.png

Now do I add send email action? do I use compose in the email?

Cheers,

Renee

As mentioned before. Compose actions are optional. However, I prefer to use them to help with troubleshooting. In your case it can be good to keep them in your flow to confirm all the values you plan to use in your Email. Such as the Manager's name, and email address. Where are you getting that information from? Are you using a Person column in your list for that?

 

You can now add the Send an email (V2) action. However, as you are still testing I would recommend you send the emails to yourself first. Whenever I am building a flow with a Send an email (V2) or a Teams post, I ALWAYS send to myself to confirm that everything is looking the way I want it to look. I also like to add ***Automated Email*** to all emails being sent with a flow. 

 

I usually indicate where the email will be sent in the first line of the email with the dynamic content that contains the email address. This way I can confirm who it will go to when I switch out my email address with the appropriate dynamic content.

 

Insert your dynamic content throughout the email. If you want to only include First names you will need to split the full name (unless you are storing the first name in a separate column). 

 

creativeopinion_0-1691982948218.png

 

Hope this helps!

 

Thanks @creativeopinion . yes I have person columns in my list. 

 

What I wanted the flow to do is email the manager (grabbing the email from the person column in the list) to advise them that they have a team members birthday and to email them birthday wishes.

 

Following your instructions, I have added Manager email, but when I try to get the Manager name expression is invalid

RezzaB_0-1691993738837.png

RezzaB_1-1691993816364.png

 

You are missing a single quote in your expression.

creativeopinion_0-1692038205114.png

 

OMG... it's finally working, woo hoo. Thanks, @creativeopinion 

 

Can I please throw a spanner in the works... What if I want the reminder to be sent 3 days before the birthday date? what do I do for that please?

 

Cheers,

Renee

You need to Compose a Dynamic Date in that case. I will update my original post with instructions on how to do this. 

@RezzaB 
You need to make a slight adjustment to you flow. I've updated the post that has all the instructions with additional instructions and screenshots. 

In your case, you will need to delete the Compose action that was storing today's date. 

creativeopinion_7-1692056513194.png
You can drag your action into the Scope action (if you choose to use it) or just add the additional Compose actions that I have instructed you to add to your flow. 

 

The way I've built the expression using the Compose action makes it easy for you to adjust the number of days for the notification should you wa

creativeopinion_8-1692056547931.png

 

Please make sure to refer to the original post with instructions.

 

 

Hi @creativeopinion  thank you for this. It looks like it is working. I will do more testing on Thursday using a different list. I really appreciate all your assistance. Chat soon 🙂

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (700)