Microsoft Dynamics 365 | Integration, Dataverse...

Time trigger Azure Function

(0) Share

Report

Posted on by MBaba

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!

All responses (7)

Answers (0)

Suggested answer

antc 2,909 on at

Like (0)

Report

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 28,964 Super User 2024 Season 1 on at

Like (0)

Report

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 84,325 Most Valuable Professional on at

Like (1)

Report

RE: Time trigger Azure Function

Use .Net Framework option - it will create the function you need.
MBaba 92 on at

Like (0)

Report

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.

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

Thank you.
Suggested answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: Time trigger Azure Function

Hello,

Here are few articles that can help you:

prajapatiamit.medium.com/lets-get-started-with-azure-function-for-dynamics-365-crm-part-1-438fad7fa14b

msdynamicscrm137374033.wordpress.com/.../
MBaba 92 on at

Like (0)

Report

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 84,325 Most Valuable Professional on at

Like (1)

Report

RE: Time trigger Azure Function

Hello,

So what exactly is not clear to you?