Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 4VDJQyh+DOYUdaemb4NmCq
Power Apps - Building Power Apps
Unanswered

How to read/create/update/delete records from a JSON file kept in an ADLS container using Power App and Power Automate

Like (0) ShareShare
ReportReport
Posted on 7 Sep 2023 07:53:56 by 6

I have a JSON file with the below Student's details in an ADLS container. I want to create an app that can perform below activities:

1- Read the records and show them in a gallery or form. 

2- Insert new records into the file.

3- Update an existing record from the app.

4- Delete an existing record from the app.

 

Please let me know how can I connect my power app(with Power Automate) with files in the ADLS container and achieve the above functionality. 

 

Sample JSON File:

 

[
{
"Id": 1,
"Name": "Mac",
"Email": "mac@amail.com",
"Phone No": 356734567
},
{
"Id": 2,
"Name": "George",
"Email": "g@amail.com",
"Phone No": 345677643
},
{
"Id": 3,
"Name": "Haris",
"Email": "h@amail.com",
"Phone No": 456876678
},
{
"Id": 4,
"Name": "Ford",
"Email": "f@amail.com",
"Phone No": 363679887
},
{
"Id": 5,
"Name": "Ben",
"Email": "b@amail.com",
"Phone No": 678546789
}
]

  • SayanDGupta Profile Picture
    6 on 13 Sep 2023 at 12:51:46
    Re: How to read/create/update/delete records from a JSON file kept in an ADLS container using Power App and Power Automate

    Thanks @AndrewR1 ,

     

    But for first, I have a file in the ADLS container. in order to add/update/delete/read the json file from power app, we connect with power automate with what connectors can I use ?

    Can you please help me with the flows to get the data from adls container file to power app

  • AndrewR1 Profile Picture
    1,572 Super User 2025 Season 1 on 07 Sep 2023 at 11:41:59
    Re: How to read/create/update/delete records from a JSON file kept in an ADLS container using Power App and Power Automate

    Hi @SayanDGupta I would start with getting the data in to the power app 1st. So where are you collecting this data form? or is it just you would like to pass the JSON to the power app? for example I have a flow that has the action of Power apps meaning I can call this flow directly from within a power app and then I collect a list of data out of Dataverse and pass this back as a JSON Object: 

    AndrewR1_0-1694086253566.png

    Secondly I would then use this in a collection to update and add new values to the collection with in the power app.

     

    I would the create an canvas app something similar to this:

    AndrewR1_1-1694086720056.png

     

    To have these changes made externally to the power app I would then use the Patch Function to update the Dataverse table or your selected data source. 

     

    I'm not sure in your case where the data sits so this could be then calling another Power Automate and pass back the updated collection to updated the ADLS. I would need more information on where you are collecting this data form? 

     

    But i would recommend trying to keep this with in the Power App and not having to use multiple Power Automates unless its absolutely necessary!

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

     

    Many Thanks
    Andrew



  • SayanDGupta Profile Picture
    6 on 07 Sep 2023 at 11:11:05
    Re: How to read/create/update/delete records from a JSON file kept in an ADLS container using Power App and Power Automate

    Hi @AndrewR1 , Thanks for your quick reply. Can you please guide me on what kind of power automate flow/connector should I use to communicate between the Power app and the ADLS files to read/create/update/delete records.

  • AndrewR1 Profile Picture
    1,572 Super User 2025 Season 1 on 07 Sep 2023 at 10:21:46
    Re: How to read/create/update/delete records from a JSON file kept in an ADLS container using Power App and Power Automate

    Hi @SayanDGupta firstly I would recommend that you connect the power automate to the power app like the below:

    AndrewR1_0-1694081563660.png

    Then I would create a button that the onselect property is somthing along the lisnes of:

    ClearCollect(
     ColADLS, //Creating a colection to stor the JSON Data
     LoadADLSData.Run() //This is you Power Automate you have added to the power app
    );

    I would have a timer control that onTimerEnd Property it would be:

    Select(ColectADSLData)

    The button you just created and set the duration to be 500

     

    You would the just add a gallery and have the collection you created as is Data source ColADLS and the same for and Details, Edit or New forms with the Item Property be Gallary1.SelectedItem 

    You could then also patch this to a data scours like Dataverse if you need the data store outside of the Power App.

     

    If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

    If you like my response, please give it a Thumbs Up.

     

    Many Thanks
    Andrew

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,771 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started