Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Blog

VIDEO – PowerApps – Super Gallery

Working with Gallery control in PowerApps can be a limiting way to navigate records.   Many PowerApps include multiple screens with dedicated Gallery screens for navigation.   Helping users locate records (sort, filter, scroll, and search) would be better accomplished with SharePoint Views.   SharePoint List Views are more mature with full features for ad-hoc sort, filter, search and ability to save query (shared/personal) and provide hyperlinks to view ASPX pages.

Why not use SharePoint Views instead of Gallery control?

Turns out we can.   On SharePoint modern pages:

  1. Create new custom column with simple formula “=[ID]”
  2. Apply JSON custom formatting to generate link <A HREF=”…power app URL..ID=1”> which opens PowerApps, giving ID number for a single record to Edit
  3. Share View URL with end users to navigate records (sort/filter/search/paging)

This gives a robust and familiar navigation experience.  Use PowerApps for it’s strength (input validation) and use SharePoint list for it’s strength (navigate records).  Cheers. 

shades_smile

Video

PowerApps – Super Gallery from Jeff Jones on Vimeo.

Screenshots

image
image
image

References

Code – GitHub Repo

Code – SuperGallery-Modern-VIEW-FORM-column

What’s in that patch? October 2019

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes.

Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at http://sharepointupdates.com/

If you found this helpful, please leave a comment.   

shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Oct 2019.PDF

ODOPEN – Onedrive Open Protocol

Recently I had F12 network trace open and launch OneDrive “Sync” button from SharePoint Modern pages toolbar.   A strange protocol showed on the network activity.  Not HTTP or HTTPS, but “ODOPEN://”

Application launcher custom URL prefixes enable web browsers to handoff to local desktop applications.   Here, ODOPEN is One Drive Open and activates the OneDrive client by passing parameters for the scope destination document library to sync.

Parameters are enumerated below in the Code section.   GUID for the scope (Site / Web / Library) identify the target data.   Current user detail is passed with user GUID and user Email.  Interesting to see how the “Sync” button works internally and wanted to share notes.

Cheers  

shades_smile

Video

Code

odopen://sync?userId=45f4af2f-e9e9-48a9-93c5-00df32aa7488&
userEmail=spjeff@spjeff.com&
isSiteAdmin=1&
siteId={07a88858-981d-4465-b36b-52ae6065d6b0}&
webId={c1c208d9-5b06-4703-981c-f6240fb45c4d}&
webTitle=Jeff Jones&
webTemplate=21&
webLogoUrl=_layouts/15/images/siteicon.png&
webUrl=https://spjeff-my.sharepoint.com/personal/spjeff_spjeff_com&
onPrem=0&
libraryType=1&
listId={9CBDD007-6D00-4F69-8D2C-BDD10D95F518}&
listTitle=Documents&
scope=OPENLIST

Screenshots

image

References

  • None found yet

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲