Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Time trigger Azure Function

Posted on by 92

Hello,

I hope someone will be able to help me with my quest.

I have an expiry table (new_tablee) that contains 2 fields:

table name (new_tablename)

remind me before (new_remindmebefore)

another two tables:

Students that contain: Name (cr6ec_name), Date(new_date), email(new_studentemail)

TBs that contain: Name (cr6ec_name), Student Name (new_studentname), Course Name (new_coursename), Date(new_date), email(new_studentemail)

**Student name and course name are lookup fields

the azure function should read the records in the expiry table to check the date based on "remind me before" every day.

then if the case verifies with remind me before values, it should create a new record in the notification table with fields: Name (new_name), student email (new_studemail), Date (new_date) = today's date, Stat (new_stat) = in progress.

Can someone help me with the azure function?

Thank you!

  • Suggested answer
    antc Profile Picture
    antc 2,909 on at
    RE: Time trigger Azure Function

    I think you would find it far easier to do this with a scheduled flow in Power Automate.

    Very easy to get current date and then add a conditional check and if yes create your records.

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: Time trigger Azure Function

    Hi,

    You can also use Dataverse Service Client to connect to Dataverse using azure function version 3

    msdynamicscrm137374033.wordpress.com/.../

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: Time trigger Azure Function

    Use .Net Framework option - it will create the function you need.

  • MBaba Profile Picture
    MBaba 92 on at
    RE: Time trigger Azure Function

    hello a33ik,

    I have followed several tutorials on creating an azure function, but I cannot find "Azure Function v1 (.Net Framework)" when creating a new project.

    pastedimage1663698269099v1.png

    I am using Visual Studio 2019. Is that the reason? Should I update it to 2022?

    Thank you.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
  • MBaba Profile Picture
    MBaba 92 on at
    RE: Time trigger Azure Function

    I am new to Azure functions.

    I do not know where to start and how to make the connection with CRM to be able to retrieve data and create records.

  • a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: Time trigger Azure Function

    Hello,

    So what exactly is not clear to you?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans