cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
divakova
New Member

Dynamic Content not showing: Sharepoint list + Office Outlook 365

Hello everyone!

 

I am trying to set up a Contract Management system in Sharepoint and trying to set up automatic emails that would be sent when a contract Expiration Date (column - date) is a week away. I do this through Flow and connect 'Schedule' with 'Sharepoint - Get item' and then add an apply to all values to 'Office Outlook 365 - Send an email'. Here, I seem to get no Dynamic Content popping up.

 

Essentially I have been following this tutorial and I am stuck from 5m21s:  https://www.youtube.com/watch?v=1_Qi5UNGj6k

 

I saw questions on this related to forms, but couldn't find the solutions helpful in this case.

 

Best,

Simone

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dynamic Content not showing: Sharepoint list + Office Outlook 365

Hi @divakova 

This is super easy as there is a template for you built right in that will do the hard part!.

 

Just select Flow from the SharePoint Library and then Select Reminder and pick your date field and specify how many days out you want it to trigger.

 

By default this groups all items on the same day in the email, if this is not suitable you can modify it to your desire.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Dynamic Content not showing: Sharepoint list + Office Outlook 365

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Super User
Super User

Re: Dynamic Content not showing: Sharepoint list + Office Outlook 365

@divakova I have dug out one example that I use for sending reminders that a review is due in 7 days. In my SharePoint list I have a date column for NextReview  and a person column for Owner.

After the Recurrence that runs at 9am every day there is a SharePoint Get items action. We than add an apply to each control and select value from the dynamic content:

0-Trigger-Get-Apply.png

The next action is to add a Compose to format today's date. I always use US format for this to avoid ISO 8601 errors. Then we add another Compose and select NextReview from the dynamic content. 

1-Compose-Today-NextReview.png

Then add another Compose to calculate the reminder date: 

2-Compose-ReminderDate.png

Then format that date to to the same US format with another Compose: 

3-Compose-FormatReminder.png

The Condition is next that checks if Today is equal to 

4-Condition.png

If the reminder date is today then in the red If yes channel add an Office 365 Users Get user profile (v2) action and select the Owner email from dynamic content. I've then formatted the next review date into UK format and used that in the email.

5-GetProfile-Compose-Email.png

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Super User
Super User

Re: Dynamic Content not showing: Sharepoint list + Office Outlook 365

Hi @divakova 

This is super easy as there is a template for you built right in that will do the hard part!.

 

Just select Flow from the SharePoint Library and then Select Reminder and pick your date field and specify how many days out you want it to trigger.

 

By default this groups all items on the same day in the email, if this is not suitable you can modify it to your desire.

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,983)