How to get .JSON file data as source data to Power Apps? ( .JSON file is in share point )

[chitra1234]

Hi All,

I need a help on below scenarios please.

Sceanario 1:

1. I have my .JSON file in sharepoint

2. I created PowerApps which is currently working with manual entry of data

3. Now what I want is, I want my Power Apps will read/get data from .JSON file from sharepoint. ( Actually only one column I needed from . JSON file as source input to Powerapps, which will be keep on changing )

4. Everytime if the data get changes in .JSON file my powerapps input also should be refreshed and get changed automatically.

Is that possible? Please give me a suggestion.

Scenario 2:

1. I embeded my Powerapps with Power BI. So if the data get update in powerapps my Power BI data will also updated for every refresh.

2. If I edit any table data in power apps will it be writeback to .JSON file in sharepoint?

Kindly help me on this. or any idea how to handle this would be more helpful.

Thanks,

Chitra

[v-shex-msft]

HI @chitra1234,

According to your description, I think these should more relate to powerapps usage. I'd like to suggest you post to powerapps community to get further support.

Power Apps Community - Power Platform Community (microsoft.com)

Regards,

Xiaoxin Sheng

[lbendlin]

As you have identified your problem is the writeback.  Having a JSON file as a data source is all nice, but writing into it is much harder. There is a JSON function in PowerApps that you can use

JSON function - Power Apps | Microsoft Docs

but it basically means that you need to ingest the entire JSON file when you start the app, store it (in a collection for example) and then write the entire JSON file back to the storage space when you make changes. 

That will likely prevent concurrent use of your app.