Friday, March 31, 2023

Convert a collection to comma separated or colon separated string

 Lets assume [colName] is your collection, [column] is your column & you want to convert it into a string with items in the Title column comma or ';' separated.

 For Ex. you have a collection with emails in the Email column & you want to convert it into a string for sending emails to all who are there in the collection.

Use below formula:

Mid(Concat([colName], ";" & [column]), 2, 1000)

Use ", " for separating using comma.

Mid(Concat([colName], ", " & [column]), 2, 1000)

How to make scrollable content in PowerApp using Canvas control

 The Canvas control is not available by default. Add a new screen of  "Scrollable" content type.

Cut the "Canvas" control shown below & use it as parent control in your screens. Add your controls to its Datacard.


Thursday, March 30, 2023

Add ellipses (... dots) after a long text in PowerApps

 We have a variable - 'longText' having a long list of characters and we want to trim the characters after a limit e.g. 130 characters, we can use below formula for the 'Text' property:


If(Len(longText)>130, Concatenate(Left(longText,130),"..."),longText)


Add Service Principle support in Custom Connector

  then search for "Streamlining Integration: Using Service Principal authentication on Custom connectors with Microsoft Graph Applicati...