Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    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.