cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JamesA
Frequent Visitor

Injecting updated JSON into msapp without error

I am attempting to:

  • unpackage an exported .msaap file,
  • edit the "2.json" file (the content of the app itself) in the "Controls" folder (I find and replace of a lot of variables),
  • and then repackage the .msaap and upload it.

 

This doesn't work.  The app will open, but the canvas is blank.

 

Re-exporting the broken app and examining the .msaap file shows that the "2.json" file is now missing but the other files are just fine, as if the "2.json" files was stripped out during the upload/opening process in the PowerApps web interface.

 

In an attempt to solve the problem, I modifed file attribute flags in the .msaap file (which is just a .zip file), such as the "A" archive bit, and the Created and Accessed attributes.  The same error resulted.

 

Does anyone know how to edit the "2.json" file and successfully repackage to a working app?

 

It would save me literally dozens of hours...

 

-James

16 REPLIES 16
Anonymous
Not applicable

@JamesA ,

See my post from Friday that is related (and perhaps the same thing).  

 

https://powerusers.microsoft.com/t5/General-Discussion/BUG-Export-amp-Import-Canvas-App-Issues-Entit...

 

Unfortunately, haven't gotten any response on this one...

AH-ha, thank you, I had not seen your post.

 

This does indeed sound very similar:

 

"

  • Importing an MSAPP (or Zip) that has had ANY file modified (to resolve a separate issue I'll post about) fails with an error with no details - whether opening from Studio or from the Import screen.  Below is a screenshot:

    PowerApps Studio Open (Import) Error.PNG

"

And, you made the same observation that the .msaap package contents format has changed.

 

Something that occured to me while I was eating dinner -- are you using the new groups feature, the "enhanced Group control" experimental feature?

 

I was wondering if using that might produce a new file format.  I will have to create a new version of my app without the experimental feature turned on, and see if it exports in a different file format.

 

Hopefully someone will answer and puzzle this out.

v-yutliu-msft
Community Support
Community Support

Hi @JamesA ,

I've made a similar test and met the same problem like your description.

Only edit the .json file is not enough.

There are many settings in other files.

I'm afraid there's no directly to modify an app by editing .msapp file.

I suggest you express your views on PowerApps Ideas Forum. Your precious advice will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

What's more, here's a similar issue for your reference:

https://powerusers.microsoft.com/t5/General-Discussion/msapp-file-format/td-p/133244

The powerapps tool mentioned in this issue may help you.

 

 

Best regards,

Community Support Team _ Phoebe Liu

 

  

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Thanks for your response, however it is not as simple as you summarize.

 

There is currently an inherent issue with the .msaap file format.

 

Try these two tests --

 

1) unpack an .msaap file (unzip the archive) and make NO modifications to the files.  Repack everything as a new .zip file, rename to .msaap and try to open it.  With absolutely no changes to the files and the "many settings in other files" you claim, you will be unable to even load the .msaap in the PowerApps Studio.

 

2) extract JUST the "2.json" file within the "Controls" folder located in the .msaap archive. Open it, change one character, and then change it back so that the file is exactly as it was. Save that "modified" file. Replace the original "2.json" within the .msaap archive (note, we did NOT extract the entire archive)!  Attempt to open the .msaap file in PowerApps Studio, and you will be greeted with a version of the app that is "blank".  Again, no modification to the "many settings in other files" and yet the file format does not work.  If you again try to export/save this new version of the .msaap, you will note that the "2.json" file is simply missing from the archive.

 

This is an issue with the .msaap file format and how it is read by PowerApps Studio. 

 

The previous version of the .msaap file format (with the "Entities.json" file that contained the contents of the app) did not have this problem, and could be edited and uploaded.

 

Hopefully someone else will have some insight to the secrets of the .msaap file format,

 

Or, perhaps the issue will be addressed by Microsoft, however I think we are more likely to solve it as a community.

Anonymous
Not applicable

@JamesA  - yes I totally agree.  I did see those as well with additional testing after posting my issue.  

 

Totally agree that reZipping the MS App does not work - whether I use "Send to Compressed (zipped) folder", 7zip (in .ZIP format), etc.  

 

I was only trying to change three minor values in the 1.json file under Controls (start page) due to another issue where PowerApps Studio messed up these settings, resulting in the app crashing on startup outside the Studio environment (reported these other issues separately, but they were all tied to my same testing).  

 

 

Anonymous
Not applicable

FYI - This functionality (editing json files and rezipping) did work until recently, and was even referenced by several tutorials, and suggested (I believe) by several MS resources for things like themes in the past.

 

In addition, the PowerApps Tools on GitHub (https://github.com/microsoft/powerapps-tools) also does just this.  Yes, these are mentioned as unsupported, but many at MS have recommended using these tools, including in response to support requests.  

 

 

Thanks, @Anonymous , sorry, my response above about "not as simple as you summarize" was for @v-yutliu-msft, if that wasn't clear!

 

Glad you see the same results.

 

It does appear to be a .msaap file format issue, and one that has recently occurred, since it appears many others were able to edit .json files and repackage without issue.

 

Wish I knew some other things to try.  Seems like an archive and packaged file attribute problem, possibly.  Maybe the CRC check for each packaged file is referenced somewhere, and when it doesn't match, it clears it from the archive.

Anonymous
Not applicable

FYI - I *FINALLY* got this working (though this is NOT a fix, just a workaround).

 

See the link here:  https://poszytek.eu/en/microsoft-en/office-365-en/powerapps-en/powerapps-export-fails-due-to-missing...

 

While this is addressing a different problem, the method he uses to update the MSAPP works.

 

Key here (as he keeps saying) DO NOT UNZIP the file!

 

What you'll do instead is:

 

  1. Download the MSAPP from within Powerapps Studio with File->Save As->This Computer
  2. Rename the file to change the .msapp extension to .zip
  3. Open the now .zip file using 7zip - OPEN - do NOT Extract
  4. Drag the files you want OUT of the ZIP file onto you harddrive in a folder
  5. Edit as needed.  If you happen to format the files (ALT-SHIFT-F in MS Code) to read them, make sure you undo this - ie: join the lines (in MS Code, select all (Control-A) lines in the file you changed, hit F1, type "join lines", and then save the file(s).
  6. Drag the modified file (with the same filename) over to 7zip, and close the ZIP file.
  7. In PowerApps Studio, do File->Open on the modified MSAPP file.  IT SHOULD WORK!

Note that I have NOT been able to rezip an MSAPP that has been unzipped and be able to import it (though this DID work in the past!!).  This is the only way I've gotten this to work (kudos to Tomasz Poszytek for the thought on this).  

 

BTW - in my case, I did not actually do lines 4-6 above, instead I just DELETED two JSON files (in Controls that were causing my app problems.

 

PowerApps for some STUPID reason made two Data Table controls I had done a cut and paste on (in the same app to a different location) TOP LEVEL controls - ie: at the same level as a screen (right under App).  Thus, while the app would load in Studio, I could not run it outside, nor could I get rid of those two control (or move, rename, etc).  Was a mess.

 

But this resolved it for me (until the next time Studio screws up an MSAPP file - last time I had to rebuild from scratch (a few days ago), and manually recreate every screen, copy controls from the old one (that didn't start) to the new one, and then doctor up MOST of the X, Y, Width, and Height for MOST of the controls (as many had formulas that were wiped out, or in some cases a static value (like 115) changed (to 1 in these cases).  

 

Wasted 3 hours this morning on this, and about 4 days last week on the other MSAPP issue.

 

But at least now I can FINALLY go in and manually fix myself now that PowerApps finally lets me import things this way.

 

 

I wish that this solution worked for me!

 

I actually had found Mr. Poszytek's post last week, and tried that -- removing the file without unzipping, editing, and inserting it.  No joy -- I am able to load the modified .msaap, however it's the same situation as I described above, an empty app.

 

I think because you are removing files, it works fine for you, but I am finding and replacing variables in copied blocks of code that I return into the .msaap.  No matter how carefully I format and return the code, it never makes it on load.

 

I'm still in the same position I described in the third or so post in this thread.

 

Very sad, super-frustrating -- I will be spending an epic amount of time this week with Notepad++ open in one window, and alt-tab-ing back and forth with code to find and replace variables in a real editing interface.  If it was supported, it would be a 1-hour job, but instead it's a 6-hour job.

 

Plz microsoft..plz.  Let us see the code.  Or, fix the .msaap file format (not expecting a response, just venting!)

 

Thanks for the ideas, though, I appreciate it!

 

 

Helpful resources

Announcements

Take a short Community User Survey | Help us make your experience better!

To ensure that we are providing the best possible experience for Community members, we want to hear from you!    We value your feedback! As part of our commitment to enhancing your experience, we invite you to participate in a brief 15-question survey. Your insights will help us improve our services and better serve the community.   👉 Community User Survey    Thank you for being an essential part of our community!    Power Platform Engagement Team  

Tuesday Tip | How to Get Community Support

It's time for another Tuesday Tip, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.       This Week: All About Community Support Whether you're a seasoned community veteran or just getting started, you may need a bit of help from time to time! If you need to share feedback with the Community Engagement team about the community or are looking for ways we can assist you with user groups, events, or something else, Community Support is the place to start.   Community Support is part of every one of our communities, accessible to all our community members.   Within each community's Community Support page, you'll find three distinct areas, each with a different focus to help you when you need support from us most. Power Apps: https://powerusers.microsoft.com/t5/Community-Support/ct-p/pa_community_support Power Automate: https://powerusers.microsoft.com/t5/Community-Support/ct-p/mpa_community_support Power Pages: https://powerusers.microsoft.com/t5/Community-Support/ct-p/mpp_community_support Copilot Studio: https://powerusers.microsoft.com/t5/Community-Support/ct-p/pva_community-support   Community Support Form If you need more assistance, you can reach out to the Community Team via the Community support form. Choose the type of support you require and fill in the form accordingly. We will respond to you promptly.    Thank you for being an active part of our community. Your contributions make a difference!   Best Regards, The Community Management Team

Community Roundup: A Look Back at Our Last 10 Tuesday Tips

As we continue to grow and learn together, it's important to reflect on the valuable insights we've shared. For today's #TuesdayTip, we're excited to take a moment to look back at the last 10 tips we've shared in case you missed any or want to revisit them. Thanks for your incredible support for this series--we're so glad it was able to help so many of you navigate your community experience!   Getting Started in the Community An overview of everything you need to know about navigating the community on one page!  Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Community Ranks and YOU Have you ever wondered how your fellow community members ascend the ranks within our community? We explain everything about ranks and how to achieve points so you can climb up in the rankings! Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Powering Up Your Community Profile Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile. Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Community Blogs--A Great Place to Start There's so much you'll discover in the Community Blogs, and we hope you'll check them out today!  Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Unlocking Community Achievements and Earning Badges Across the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. Check out some details on Community badges--and find out more in the detailed link at the end of the article! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Blogging in the Community Interested in blogging? Everything you need to know on writing blogs in our four communities! Get started blogging across the Power Platform communities today! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Subscriptions & Notifications We don't want you to miss a thing in the community! Read all about how to subscribe to sections of our forums and how to setup your notifications! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Getting Started with Private Messages & Macros Do you want to enhance your communication in the Community and streamline your interactions? One of the best ways to do this is to ensure you are using Private Messaging--and the ever-handy macros that are available to you as a Community member! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Community User Groups Learn everything about being part of, starting, or leading a User Group in the Power Platform Community. Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Update Your Community Profile Today! Keep your community profile up to date which is essential for staying connected and engaged with the community. Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Thank you for being an integral part of our journey.   Here's to many more Tuesday Tips as we pave the way for a brighter, more connected future! As always, watch the News & Announcements for the next set of tips, coming soon!

Calling all User Group Leaders and Super Users! Mark Your Calendars for the next Community Ambassador Call on May 9th!

This month's Community Ambassador call is on May 9th at 9a & 3p PDT. Please keep an eye out in your private messages and Teams channels for your invitation. There are lots of exciting updates coming to the Community, and we have some exclusive opportunities to share with you! As always, we'll also review regular updates for User Groups, Super Users, and share general information about what's going on in the Community.     Be sure to register & we hope to see all of you there!

April 2024 Community Newsletter

We're pleased to share the April Community Newsletter, where we highlight the latest news, product releases, upcoming events, and the amazing work of our outstanding Community members.   If you're new to the Community, please make sure to follow the latest News & Announcements and check out the Community on LinkedIn as well! It's the best way to stay up-to-date with all the news from across Microsoft Power Platform and beyond.    COMMUNITY HIGHLIGHTS   Check out the most active community members of the last month! These hardworking members are posting regularly, answering questions, kudos, and providing top solutions in their communities. We are so thankful for each of you--keep up the great work! If you hope to see your name here next month, follow these awesome community members to see what they do!   Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzDeenujialexander2523ragavanrajanLaurensMManishSolankiMattJimisonLucas001AmikcapuanodanilostephenrobertOliverRodriguestimlAndrewJManikandanSFubarmmbr1606VishnuReddy1997theMacResolutionsVishalJhaveriVictorIvanidzejsrandhawahagrua33ikExpiscornovusFGuerrero1PowerAddictgulshankhuranaANBExpiscornovusprathyooSpongYeNived_Nambiardeeksha15795apangelesGochixgrantjenkinsvasu24Mfon   LATEST NEWS Business Applications Launch Event - On Demand In case you missed the Business Applications Launch Event, you can now catch up on all the announcements and watch the entire event on-demand inside Charles Lamanna's latest cloud blog.   This is your one stop shop for all the latest Copilot features across Power Platform and #Dynamics365, including first-hand looks at how companies such as Lenovo, Sonepar, Ford Motor Company, Omnicom and more are using these new capabilities in transformative ways. Click the image below to watch today!     Power Platform Community Conference 2024 is here! It's time to look forward to the next installment of the Power Platform Community Conference, which takes place this year on 18-20th September 2024 at the MGM Grand in Las Vegas!   Come and be inspired by Microsoft senior thought leaders and the engineers behind the #PowerPlatform, with Charles Lamanna, Sangya Singh, Ryan Cunningham, Kim Manis, Nirav Shah, Omar Aftab and Leon Welicki already confirmed to speak. You'll also be able to learn from industry experts and Microsoft MVPs who are dedicated to bridging the gap between humanity and technology. These include the likes of Lisa Crosbie, Victor Dantas, Kristine Kolodziejski, David Yack, Daniel Christian, Miguel Félix, and Mats Necker, with many more to be announced over the coming weeks.   Click here to watch our brand-new sizzle reel for #PPCC24 or click the image below to find out more about registration. See you in Vegas!     Power Up Program Announces New Video-Based Learning Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram. These include a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the image below to find out more!     UPCOMING EVENTS Microsoft Build - Seattle and Online - 21-23rd May 2024 Taking place on 21-23rd May 2024 both online and in Seattle, this is the perfect event to learn more about low code development, creating copilots, cloud platforms, and so much more to help you unleash the power of AI.   There's a serious wealth of talent speaking across the three days, including the likes of Satya Nadella, Amanda K. Silver, Scott Guthrie, Sarah Bird, Charles Lamanna, Miti J., Kevin Scott, Asha Sharma, Rajesh Jha, Arun Ulag, Clay Wesener, and many more.   And don't worry if you can't make it to Seattle, the event will be online and totally free to join. Click the image below to register for #MSBuild today!     European Collab Summit - Germany - 14-16th May 2024 The clock is counting down to the amazing European Collaboration Summit, which takes place in Germany May 14-16, 2024. #CollabSummit2024 is designed to provide cutting-edge insights and best practices into Power Platform, Microsoft 365, Teams, Viva, and so much more. There's a whole host of experts speakers across the three-day event, including the likes of Vesa Juvonen, Laurie Pottmeyer, Dan Holme, Mark Kashman, Dona Sarkar, Gavin Barron, Emily Mancini, Martina Grom, Ahmad Najjar, Liz Sundet, Nikki Chapple, Sara Fennah, Seb Matthews, Tobias Martin, Zoe Wilson, Fabian Williams, and many more.   Click the image below to find out more about #ECS2024 and register today!   Microsoft 365 & Power Platform Conference - Seattle - 3-7th June If you're looking to turbo boost your Power Platform skills this year, why not take a look at everything TechCon365 has to offer at the Seattle Convention Center on June 3-7, 2024.   This amazing 3-day conference (with 2 optional days of workshops) offers over 130 sessions across multiple tracks, alongside 25 workshops presented by Power Platform, Microsoft 365, Microsoft Teams, Viva, Azure, Copilot and AI experts. There's a great array of speakers, including the likes of Nirav Shah, Naomi Moneypenny, Jason Himmelstein, Heather Cook, Karuana Gatimu, Mark Kashman, Michelle Gilbert, Taiki Y., Kristi K., Nate Chamberlain, Julie Koesmarno, Daniel Glenn, Sarah Haase, Marc Windle, Amit Vasu, Joanne C Klein, Agnes Molnar, and many more.   Click the image below for more #Techcon365 intel and register today!   For more events, click the image below to visit the Microsoft Community Days website.    

Tuesday Tip | Update Your Community Profile Today!

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   We're excited to announce that updating your community profile has never been easier! Keeping your profile up to date is essential for staying connected and engaged with the community.   Check out the following Support Articles with these topics: Accessing Your Community ProfileRetrieving Your Profile URLUpdating Your Community Profile Time ZoneChanging Your Community Profile Picture (Avatar)Setting Your Date Display Preferences Click on your community link for more information: Power Apps, Power Automate, Power Pages, Copilot Studio   Thank you for being an active part of our community. Your contributions make a difference! Best Regards, The Community Management Team

Users online (5,072)