Unanswered

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

(0) Share

Report

Posted on by SayanDGupta

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
}
]

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AndrewR1 1,572 Moderator on at

Like (0)

Report
Hi @SayanDGupta firstly I would recommend that you connect the power automate to the power app like the below:
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

Was this reply helpful? Yes No
SayanDGupta 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
AndrewR1 1,572 Moderator on at

Like (0)

Report

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:
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:

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

Was this reply helpful? Yes No
SayanDGupta 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No