Unanswered

Azure function to create rows in dataverse (Using power apps)

(0) Share

Report

Posted on by AlGom

Hi all,

is it possible to add, delete rows in dataverse using Azure functions? . The idea of this is to create a function in azure (timer trigger) to use as a custom conector with power apps that save a specific row every 5 mins for example.

Categories:

Microsoft Dataverse

All responses (4)

Answers (0)

MattB-MSFT Microsoft Employee on at

Like (1)

Report

Re: Azure function to create rows in dataverse (Using power apps)

You can walk though this video, created by an MVP. Its a bit dated. but still generally accurate.

Connecting To Dataverse From Azure Functions Using Azure Key Vault - February 2021 Washington, DC Us - YouTube

Few key changes... The Client being used to connect to Dataverse in the video is called CdsServiceClient, that client is now called "Dataverse ServiceClient" and can be found here, its ok if you search for CdsServiceClient, it will guide you to the Dataverse ServiceClient.

Also I would encourage you to use the strong type code generators to aid in development and communications with Dataverse. This tool ( CrmServiceUtil ) will allow you to generate Model classes for your tables and custom API's when communicating with Dataverse. its not required, it just makes things easier :).
AlGom 18 on at

Like (0)

Report

Re: Azure function to create rows in dataverse (Using power apps)

i've done the guide that you provide me but i i'm so new working with azure functions... You know some guide or video that "explain" how to work with dataverse table information. I mean some practice that, for example , create data in a dataverse table colum or edit existing data... Thanks for response :9
ChrisPiasecki 6,389 Most Valuable Professional on at

Like (0)

Report

Re: Azure function to create rows in dataverse (Using power apps)

Hi @AlGom,

If you are using a timer trigger, it doesn't really make sense as a custom connector in Power Apps as you wouldn't be triggering it on-demand or based on some event.

In terms of using an Azure function in general though, yes you can use the Dataverse Service Client to programmatically modify data in Dataverse.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Ram Prakash 5,179 Super User 2025 Season 1 on at

Like (0)

Report

Re: Azure function to create rows in dataverse (Using power apps)

Hi @AlGom

Yes it is Possible.

You can use below link for Creating Application User with Client ID and Client Secret

https://the365bit.com/2022/01/19/accessing-the-dataverse-from-an-azure-function/

then Publish the same in azure and make a Time Tigger

Ping me if you have any issues 🙂

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com