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!

I have the same question (0)

All responses (7)

Answers (0)

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

So what exactly is not clear to you?

Was this reply helpful? Yes No
MBaba 92 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

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/.../

Was this reply helpful? Yes No
MBaba 92 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

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

msdynamicscrm137374033.wordpress.com/.../

Was this reply helpful? Yes No
Suggested answer

antc 2,909 on at

Like (0)

Report

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.

Was this reply helpful? Yes No