Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Time trigger Azure Function

(0) ShareShare
ReportReport
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,964 Super User 2024 Season 1 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,325 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,325 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,325 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans