cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MasterOffice365
Advocate III
Advocate III

PowerApps SharePoint User Experience Demo - you'll want to watch this...

Imagine if you could develop an app with PowerApps that enables you to view any content in SharePoint you have permission to view on any site, view all the Document Libraries and Lists on those sites, view just about any documents such as PDFs, Word, PowerPoint within the same app, view photo libraries rendering highly compressed images AND even watch videos stored in your Document Libraries. And all that functionality had been implemented on just one screen in PowerApps without a single workaround or hack to enable all those things. And if you really want to, you can overide the View Threshold currently 2000 records much higher, although I wouldn't recommend it.

 

Not a chance, right? That type of functionality is years away surely? No doubt many of you have already been waiting years for it.

 

Guess again Smiley Very Happy

https://youtu.be/SYqscqPo9wM

1 ACCEPTED SOLUTION

Accepted Solutions

Tada.

 

Now final version of this app.

 

View PDF documents or any documents converted to PDFs on the fly, download, edit metadata, watch videos, view photos stored on any site in any document library including subfolder or list with zero connectors associated with the app, enabled leveraging the SharePoint v2 Graph APIs invoked by just 7 Flows that do everything demostrated in a single app with a single screen in that app!

 

Need I say more Smiley Very Happy

https://youtu.be/vSbwmHfqK3c

View solution in original post

15 REPLIES 15
Pstork1
Multi Super User
Multi Super User

Very nicely done.  You really should submit this as a potential template.

 

(Spoken as one MCSM to another)



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


@Pstork1 wrote:

Very nicely done.  You really should submit this as a potential template.

 

(Spoken as one MCSM to another)


Smiley Very Happy Smiley Very Happy Smiley Very Happy

 

What is quite remarkable is that 95% insofar as retrieving all the content reflected in the demo app is based on just 3 Flows. No Connectors whatsoever associated to the app. The Flows have been implemented in such a way that they could be reused for countless other apps you may potentially wish to create,

 

The complexity of the demo app however is high, primarily because there are just so much functionality showcased that it in a way may well spark an evolution insofar as how most App Makers have until now have developed solutions solely based on content from SharePoint Lists as apposed to consuming any content in their apps from SharePoint Docunent Libraries. 

Are you going to share your insights with the community?

Nice job, lot's of great stuff going on there.

Yip.

 

I am busy drafting a blog that goes into a lot of detail on how I developed this solution which I expect to publish that blog in about a week. I will also share the PowerApps solution when I post the blog.

 

All of the functionality showcased in the blog is based on the SharePoint v2 Graph APIs currently still in beta and thus not officially supported on production environments. That said given that there are so many workarounds aka hacks that partially provide some of the functionality I have implemented in the demo app, none of the current workarounds are supported either. 

I have uploaded a now "final" video demo of the app I have created on YouTube that is now narrated and displays even more functionality I have implemented subsequent to my earlier post on this thread.

This latest demo really depicts some awesome functionality that speaks to so many App Makers out there that keep asking when is this type of functionality I have now demonstrated is in fact possible today. 

https://youtu.be/gKL92VU6QwA

 

I will be posting a blog within the next week (hopefully) on exactly I made all the cool stuff I've demonstrated in the demo video possible within a single PowerApp.

Watch this space or check out my web site:

http://masteroffice365.com

Sometimes life happens and things take somewhat longer than anticipated!

Hence the corresponding blog to this thread is still imminently forthcoming...

 

Since my previous response on this thread I have been refining 2 of the 3 primary Flows I've created for my demo app more generic to accommodate a far wider use case scenarios. Those are now basically complete now and I by and large just need to describe what each step in each of the Flows does in my upcoming blog.

 

Equally I have enhanced the initial demo app I created to showcase what I at least think is quite an awesome user experience rendering content the user has permission stored in ANY site (and subsites) from ANY Document Library (and subfolders) or List.

 

In my app I also demonstrate on-the-fly conversions of Word, PowerPoint, HTML and likely others I haven't tested can instantly be converted to PDFs and displayed in a PDF Viewer control and equally just as easily view actual PDF documents stored in a SharePoint document library in that same PDF Viewer control with zero effort or workarounds that have historically been required in order to view PDF documents stored in SharePoint due to authentication related challenges. 

 

Notwithstanding the demo now showcases how calling a single Flow content from any list on any site can be consumed by the app inclusive of ALL the metadata pertaining to whichever list you query, which thereafter be displayed in a Gallery control or any other requirement for your app. Furthermore the same Flow returns the actual schema definition for the list, such that at run time the app is able to determine the field type for each column in that list for example which columns are lookup fields to another list on the site, person or group fields, date time fields, text fields with the number of lines and maximum length, choice fields inclusive of possible choices for that column as well as attachments etc. 

 

I have recorded a new video of the demo app I have created. I am currently reworking the Flows to remove some unnecessary complexities rather than try and explain in the upcoming blog what the initial intention of those "now" unnecessary steps were intended for. 

 

Demo of v2 of the app on YouTube:

PowerApps SharePoint User Experience Demo v2

 

On a side note, everything in the video recording I uploaded has been implemented in a single screen in the demo PowerApp showcased in the video. Surprisingly enough I found it easier to develop the demo app with all the functionality depicted on one screen, go figure Smiley Wink

Tada.

 

Now final version of this app.

 

View PDF documents or any documents converted to PDFs on the fly, download, edit metadata, watch videos, view photos stored on any site in any document library including subfolder or list with zero connectors associated with the app, enabled leveraging the SharePoint v2 Graph APIs invoked by just 7 Flows that do everything demostrated in a single app with a single screen in that app!

 

Need I say more Smiley Very Happy

https://youtu.be/vSbwmHfqK3c

Anonymous
Not applicable

Thanks so much for all your work on this thread and topic @Office365Master!

 

@Anonymous 

Helpful resources

Announcements

Check Out the February 2024 Dynamics 365 Newsletter

Some of our most active Power Platform Community members are also active in our D365 Community. This month, we are excited to share the latest news from the D365 Community with you.   Our Dynamics365 Community has updated yet again! Since launching in June of 2023, the new Community has seen consistent updates and exciting new ways to feature and celebrate its members. In the latest edition of the Dynamics365 Community newsletter, you can see the new Leaderboard feature! This feature showcases which Community members have earned the most points over the previous month, enabling them to see how they are doing with their engagement--and their progress toward Super User status. Visit the leaderboard for yourself: https://aka.ms/d365clb     Read the whole newsletter featuring the new leaderboard as well as the D365 Monthly Community Member spotlight, FastTrack Tech Talks, upcoming events, and more. February 2024 Dynamics 365 Community Newsletter

Celebrating a New Season of Super Users with Charles Lamanna, CVP Microsoft Business Applications

February 8 was the kickoff to the 2024 Season One Super User program for Power Platform Communities, and we are thrilled to welcome back so many returning Super Users--as well as so many brand new Super Users who started their journey last fall. Our Community Super Users are the true heroes, answering questions, providing solutions, filtering spam, and so much more. The impact they make on the Communities each day is significant, and we wanted to do something special to welcome them at our first kickoff meeting of the year.   Charles Lamanna, Microsoft CVP of Business Applications, has stressed frequently how valuable our Community is to the growth and potential of Power Platform, and we are honored to share this message from him to our 2024 Season One Super Users--as well as anyone who might be interested in joining this elite group of Community members.     If you want to know more about Super Users, check out these posts for more information today:    Power Apps: What is A Super User? - Power Platform CommunityPower Automate: What is A Super User? - Power Platform Community Copilot Studio: What is A Super User? - Power Platform Community Power Pages: What is A Super User? - Power Platform Community

February 2024 User Group Update: Welcoming New Groups and Highlighting Upcoming Events

It's a new month and a brand-new year, which means another opportunity to celebrate our amazing User Groups!Each month, we highlight the new User Groups that have joined the community. It's been a busy season for new groups, because we are thrilled to welcome 15 New User Groups! Take a look at the list below, shared by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you!   We love our User Groups and the difference they make in the lives of our Community! Thank you to all the new User Groups, new User Group leaders--we look forward to hearing about your successes and the impact you will leave!   In addition to our monthly New User Group spotlight, it's a great time to share some of the latest events happening in our User Group community! Take a look at the list below to find one that fits your schedule and need! There's a great combination of in-person and virtual events to choose from. It's a great time of year to connect and engage with User Groups both locally and online. Please Welcome Our NEW User Groups   Power Platform: Heathcare Power Platform User Group Power Platform Connect Hub Power Platform Usergroup Denmark Mexico Norte- Power Platform User Group Pune Power User Group Sudbury Power Platform User GroupMicrosoft User Group GhanaMPPBLR - Microsoft Power Platform Bengaluru User Group Power Apps:   Myrtle Beach Power Platform User GroupAnanseTechWB PowerApps Copilot Studio: Pathfinders Power Platform Community Dynamics365: Cairo, Egypt MSD 365 Business Central/NAV/F&O User GruopMS Dynamics 365 Business Central LatamCincinnati OH D365 F&O User Group February User Group Events February 2024 Cleveland Power Platform User GroupPortallunsj - Februar 2024Indiana D365/AX February User Group MeetingQ1 2024 KC Power Platform and Dynamics 365 CRM Users Group 

Super Users 2024 Season One is Here!

   We are excited to announce the first season of our 2024 Super Users is here! Our kickoff to the new year welcomes many returning Super Users and several new faces, and it's always exciting to see the impact these incredible individuals will have on the Community in 2024! We are so grateful for the daily difference they make in the Community already and know they will keep staying engaged and excited for all that will happen this year.   How to Spot a Super User in the Community:Have you ever written a post or asked for help in the Community and had it answered by a user with the Super User icon next to their name? It means you have found the actual, real-life superheroes of the Power Platform Community! Super Users are our heroes because of the way they consistently make a difference in the Community. Our amazing Super Users help keep the Community a safe place by flagging spam and letting the Community Managers know about issues. They also make the Community a great place to find answers, because they are often the first to offer solutions and get clarity on questions. Finally, Super Users share valuable insights on ways to keep the Community growing, engaging, and looking ahead!We are honored to reveal the new badges for this season of Super Users! Congratulations to all the new and returning Super Users!     To better answer the question "What is a Super User?" please check out this article: Power Apps: What is A Super User? - Power Platform CommunityPower Automate: What is A Super User? - Power Platform Community Copilot Studio: What is A Super User? - Power Platform Community Power Pages: What is A Super User? - Power Platform Community

January 2024 Community Newsletter

Welcome to our January 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 in each Community and check out the Community on LinkedIn as well! It's the best way to stay up-to-date in 2024 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, giving (and receiving!) kudos, and consistently 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, make it your New Year's Resolution to be more active in the community in 2024.   Power AppsPower AutomateCopilot StudioPower PagesWarrenBelzWarrenBelzPstork1saudali_25LaurensMPstork1stephenrobertLucas001AARON_ClbendincpaytonSurendran_RANBNived_NambiarMariamPaulachanNikhil2JmanriqueriosANBJupyter123rodger-stmmbr1606Agniusstevesmith27mandelaPhineastrice602AnnaMoyalanOOlashynBCLS776grantjenkinsExpiscornovusJcookSpongYeAARON_CManishSolankiapangelesPstork1ManishSolankiSanju1Fubar   LATEST NEWS Power Platform 2024 Release Wave Highlights This month saw the 2024 Release Wave 1 plans for Microsoft Power Platform and Microsoft Dynamics 365- a compilation of new capabilities planned for release between April and September 2024. Click here to read Corporate Vice President Maureen (Mo) Osborne's detailed breakdown of the upcoming capabilities, and click the image below to check out some of the Power Platform 2024 Release Wave 1 highlights.     "What's New" Power Platform Shorts Series This month we also launched our brand-new 'Power Shorts' series on YouTube - a selection of super sweet snapshots to keep you in the loop with all the latest trends from across the Power Platform and beyond. Click the image below to check out the entire playlist so far, and don't forget to subscribe to our YouTube channel for all the latest updates.   Super User In Training (S.U.I.T) It was great to see the Power Platform Community officially kick off Season One of their Super User in Training (SUIT) program this month! Their first meeting saw an amazing turnout of over 300 enthusiastic participants who started their dynamic journey toward becoming Super Users. Huge thanks to Manas Maheshwari, Eric Archer, Heather Hernandez, and Duane Montague for a fantastic kick-off. The first meeting also saw seasoned Super User, Drew Poggemann, share invaluable insights on navigating the #MicrosoftCommunity with finesse. Many thanks to Drew for setting the stage and emphasizing the importance of active engagement and the art of providing thoughtful community solutions. If you want to learn more about the features and benefits of gaining Super User status, click the image below to find out more, and watch this space for more info about Season Two and how you can SUIT UP in the community!     UPCOMING EVENTS Microsoft 365 Community Day - Miami - February 1-2, 2024 It's not long now until the Microsoft 365 Community Day Miami, which will be taking place at the Wolfson Campus at Miami Dade College on 1-2 Feb. 2024. This free event is all about unlocking the full potential of Power Platform, Microsoft 365, and AI, so whether you’re a tech enthusiast, a business owner, or just curious about the latest Microsoft advancements, #M365Miami is for you.   The event is completely free and there will sessions in both English and Spanish to celebrate the vibrant and diverse make-up of our amazing community. Click the image below to join this amazing Community Day in Miami and become a part of our incredible network of learners and innovators!     Microsoft Fabric - Las Vegas - March 26-28, 2024 Exciting times ahead for the inaugural #MicrosoftFabric Community Conference on March 26-28 at the MGM Grand in Las Vegas. And if you book now, you can save $100 off registration! The Microsoft Fabric Conference will cover all the latest in analytics, AI, databases, and governance across 150+ sessions.   There will be a special Community Lounge onsite, interactive learning labs, plus you'll be able to 'Ask the Experts' all your questions to get help from data, analytics, and AI specialists, including community members and the Fabric Customer Advisory Team. Just add the code MSCUST when registering for a $100 discount today. Click the image below to find out more about the ultimate learning event for Microsoft Fabric!     Microsoft 365 Conference - Orlando - April 30 - May 2, 2024 Have you added The Microsoft 365 Conference to your community calendar yet? It happens this April 30th - May 2nd in Orlando, Florida. The 2024 Microsoft 365 Conference is one of the world’s largest gatherings of Microsoft engineers and community, with a strong focus on Power Platform, SharePoint, Azure, and the transition to an AI-powered modern workplace.   Click the image link below to find out more and be prepared to be enlightened, educated, and inspired at #M365Conf24!   LATEST COMMUNITY BLOG ARTICLES Power Apps Community Blog Power Automate Community Blog Copilot Studio Community Blog Power Pages Community Blog Check out 'Using the Community' for more helpful tips and information: Power Apps, Power Automate, Copilot Studio, Power Pages  

Did You Attend the Microsoft Power Platform Conference in 2022 or 2023? Claim Your Badge Today!

If you were one of the thousands of people who joined us at the first #MPPC Microsoft Power Platform Conference in 2022 in Orlando--or attended the second-annual conference in Las Vegas in 2023--we are excited to honor you with a special community badge! Show your support for #MPPC Microsoft Power Platform Conference this year by claiming your badge!         Just follow this link to claim your badge for attending #MPPC in 2022 and/or 2023: MPPCBadgeRequest    Want to earn your badge for 2024? Just keep watching our News & Announcements for the latest updates on #MPPC24.

Top Solution Authors
Top Kudoed Authors
Users online (4,407)