Skip to main content
Community site session details

Community site session details

Session Id : VWX47LVpsrjllI5+8TgjhB
Power Apps - Microsoft Dataverse
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 13 Jul 2022 10:24:49 by 18

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:
  • MattB-MSFT Profile Picture
    Microsoft Employee on 14 Jul 2022 at 16:10:33
    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 Profile Picture
    18 on 14 Jul 2022 at 10:11:44
    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 Profile Picture
    6,412 Most Valuable Professional on 13 Jul 2022 at 13:24:31
    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 Profile Picture
    5,345 Super User 2025 Season 2 on 13 Jul 2022 at 13:20:02
    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

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Featured topics