Microsoft #PowerApps and Flow – #Codecamp Iasi presentation

Sâmbătă 28 Oct 2017 am avut depsebita plăcere să revin pe scena prezentărilor de IT. Trecuse ceva timp și le mulțumesc organizatorilor pe această cale pentru această ocazie.

Sunt multe de vorbit despre subiect, mai ales că acele tehnologii sunt într-o stare incipientă de dezvoltare. Atașez acestui mesaj prezentarea de ieri, care conține și legături la filmulețele cu demo. Am ales varianta de a face demo filmate, pentru a diminua riscul de a avea surprize cu internetul în timpul prezentării. În momentul în care ai mii de participanți într-un hotel, nici un wireless nu prea face față. Faptul că sala era la nivelul –1 nici 4G-ul nu ne ajuta prea mult.

Legătura directă către prezentare: https://1drv.ms/p/s!ApGubfWFh8Nuq9NFGV8T5ONvYma99w

Lista filmulețelor demo este mai jos. Ultimele două nu au sunet. Voi adăuga adnotări pe ele pentru o înțelegere mai bună a subiectului.

1. PowerApps form for SharePoint Online List (1) – https://www.youtube.com/watch?v=N85de_prnoA

Crearea unei formular mobil de introducere date într-o listă din SharePoint On-line. Explicarea ecranelor de bază.

2. PowerApps New Data source and populating a DropDown (2) – https://www.youtube.com/watch?v=GsKYj6gEC_I

Adăugarea unei surse de date dintr-o altă listă SharePoint Online și inserarea și popularea unui control de tip DropDown conectat la sursa secundară.

Aici trebuie luat în calcul că lipsește o informație din demo si anume faptul că nu se face automat update pe field dacă nu este specificat acest lucru (vezi imagine)

3. PowerApps Linked/Filtered DropDowns (3) – https://www.youtube.com/watch?v=vPxh25yEWTs

Interconectarea a doua controale dropdown.

4. Microsoft Flow – Send a custom email message (4) – https://www.youtube.com/watch?v=BFABPC9Q0zs&t=25s

Un model de utilizare a Flow pentru transmiterea unui mesaj de mail odată cu crearea unui nou element nou intr-o listă din SharePoint Online. În filmuleț sunt demonstrate câteva funcționalități de bază a fluxurilor: blocuri decizionale, variabile, tratarea erorilor, istoric de execuție.

Mulțumesc tuturor pentru participare și feedback și sper să ne mai revedem.

29/10/2017

Calculating Time Difference in InfoPath Form

This article describe a custom method for time difference based on a custom combo box used for hours and minutes input.

You can download the XSN file from https://1drv.ms/u/s!ApGubfWFh8Nuq5o3q77TRbTkVX634w

This form is designated to calculate the time difference between end hour and minute and start hour and start minute.

The form contains a XML resource file used to populate the combo box for hours and minutes:

Structure:

HValue – Integer from 0 to 23
HDisplay – Text, 00, 01 to 23
HType – R – Regular, ABH – After Business Hours, N – Night hours
MValue – Integer from 0 to 59
MDisplay – Text, 00, 01 to 59

Worked hours and minutes are calculated using xPath 1.0 (details in article IF-THEN-ELSE in xPath)

For H Diff (worked hours) formula is:

concat(substring(concat(substring(../my:EndH – ../my:StartH, 1, (../my:EndM – ../my:StartM >= 0) * string-length(../my:EndH – ../my:StartH)), substring(../my:EndH – ../my:StartH – 1, 1, (not(../my:EndM – ../my:StartM >= 0)) * string-length(../my:EndH – ../my:StartH – 1))), 1, (../my:EndH – ../my:StartH >= 0) * string-length(concat(substring(../my:EndH – ../my:StartH, 1, (../my:EndM – ../my:StartM >= 0) * string-length(../my:EndH – ../my:StartH)), substring(../my:EndH – ../my:StartH – 1, 1, (not(../my:EndM – ../my:StartM >= 0)) * string-length(../my:EndH – ../my:StartH – 1))))), substring(concat(substring(../my:EndH – ../my:StartH + 24, 1, (../my:EndM – ../my:StartM >= 0) * string-length(../my:EndH – ../my:StartH + 24)), substring(../my:EndH – ../my:StartH + 23, 1, (not(../my:EndM – ../my:StartM >= 0)) * string-length(../my:EndH – ../my:StartH + 23))), 1, (not(../my:EndH – ../my:StartH >= 0)) * string-length(concat(substring(../my:EndH – ../my:StartH + 24, 1, (../my:EndM – ../my:StartM >= 0) * string-length(../my:EndH – ../my:StartH + 24)), substring(../my:EndH – ../my:StartH + 23, 1, (not(../my:EndM – ../my:StartM >= 0)) * string-length(../my:EndH – ../my:StartH + 23)))))) – ../my:LunchBreak

LunchBreak – is 1 when is checked and 0 when is unchecked.

For number of minutes (M Diff) the formula is:

concat(substring(../my:EndM – ../my:StartM, 1, (../my:EndM – ../my:StartM >= 0) * string-length(../my:EndM – ../my:StartM)), substring(../my:EndM – ../my:StartM + 60, 1, (not(../my:EndM – ../my:StartM >= 0)) * string-length(../my:EndM – ../my:StartM + 60)))

Also, in the form is implemented a validation rules for cases when the hour is the same and start minutes are greater than end minutes.

This rule is used also to deactivate submit button.

Future improvements: Add AM/PM format for time differences.

Hope it helps!

27/12/2016

Fix Microsoft #SharePoint bug in Oslo Master page

This article describes a method for solving a problem with the interface in SharePoint sites with Oslo master page layout.

Symptoms

When you are selecting an Oslo master page layout for your site (Team Site) there is an issue in displaying large column lists.

See the following picture:

You can observe left margin. If the list from the site contains more columns the left margin is bigger.

Investigation

I use classic Console/Debugger app from my browser and I identify that there is an issue related to the CSS formatting applied to:

div id=”titleAreaBox” and to div class=”content wrapper”.

You can observe in Style section, value of the margins of content wrapper are in percent’s. These percent’s that are applies here are from the width of the page, not of the screen.

Solving steps

1. In SharePoint Designer 2013, open the site and navigate to Master Pages section.

2. Open in edit mode the file oslo.master. Find the expression div id=”titleAreaBox”, edit the line and add style=”margin-left:5px”

3. Find the expression div class=”contentwrapper”, edit the line and add style=”margin-left:20px;margin-top:20px;”

Save the page and go back to browser and refresh.

If you do not have access to SharePoint Designer, you can choose to corect the pages from a list using jQuery script added in page:

Hope it helps.

13/12/2016