Power Apps Custom connectors understanding

More than 365 plus connectors avaialble as microsoft and non microsoft services you may want to communicate with services that are not available as pre buit connectors.

Capability to create, share the connector, trigger the connectors on it own, or by any actions.

Life cycle:

Build your API:

using RESTAPI(Like power apps we have Logic apps, which supports SOAP APIs) that allows logic apps, power automate, powerapps to communicate with rest or soap api.

two types of APIs:

public apis(public internet eg: spootify, slack, rackspace etc..)

private apis (visible only to your network)

For public apis that you can plan to create or manage using these microsoft azure products

Azure functions,

Azure web apps,

Azure api apps.

2. Secure you api:

We have standard authentication methods for you apis and connectors

with help of azure active directory.

1. Generic OAuth 2.0,

2. OAuth 2.0 for specific services Azure AD, Dropbox, Github, Salesforce.

3. API Key

4. Basic authentication (username and password)

If you are setting Azure AD authentication for your API in azure portal, then we don't need to implement authentication again.

3. Describe the API and define the connector:

Describe you API so that power apps, power automate, logic apps can communicate with your API.

In order to describe, we have below options.

1. An OpenAPI definition

2. Postman collection

Why logic apps are different from Power Apps and Power automate?

Connectors created in Power Automate are available in Power Apps. Likewise, connectors created in Power Apps are available in Power Automate. This isn't true for connectors created in Logic Apps.

However, you can reuse the OpenAPI definition or Postman collection to recreate the connector in PApps, PAutoamte and LogicApps.

5. Share you connector:

with in you organization or other users

6. Certify your connector:

submit to MS, they will certify.

Comments

Powerapps overcome 2000 item limit from any datasource

First go through delegation concept https://tejasadventure.blogspot.com/2020/05/power-apps-understanding.html In powerapps, we observe by default 500 item limit has set with in the app level for any data source. In order to overcome, we have option to set the limit of 2000 item limit maximum in the app. Now using code, MaximoFacility is my data source name contains 3000 items. ColFacilityDropdown is the collection storing the count of items from data source. We expect to see more than 2000 items. Based on StartWith function filtering the data with respective to the charectors and numbers as mentioned below. Code: Place the below code in a button on select property. Add label with code CountRows(ColFacilityDropdown) ClearCollect(ColFacilityDropdown,Filter(Filter(MaximoFacility, Status = "ACTIVE"), StartsWith( Title, "A" ))); Collect(ColFacilityDropdown,Filter(Filter(MaximoFacility, Status = "ACTIVE"), StartsWith( Title, "B" ))); Collect(ColFacilit...

Power Apps Understanding

https://tejasadventure.blogspot.com/2019/10/power-apps-we-have-1.html https://tejasadventure.blogspot.com/2019/11/power-apps-how-to-configure-using-blank.html https://tejasadventure.blogspot.com/2019/11/power-apps-field-controls.html Report We can use people picker fields, look up fields file attachment back next save cancel download the report and this report can be used in other system of powerapp. Add new report button - asks add from existing report Report all item view can design in the way like sharepoint list views for example. we can group it Group AND or Group OR by apply filters Canvas apps: Arrange user experience and interface design allow creativity and business use case guide how the way app wants to look like. Sources can be around 200+ ways. Majorly SharePOint, Power BI From data, From Sample From CDS From blank canvas via appSource Model driven apps: Model driven apps uses power of CDS rapidly to configure your for...

PowerApps multiselect cascading dropdown and save an item to SharePoint List

I have one scenario as below List 1: Division List has title field List 2: District List has Title and Division Field(LookUp from Division List) List 3: Facility List has Title, District Field(LookUp field from District List) List 4: County List has Title, Facility Field(LookUp field from Facility List) Main List: Spill Report is the main list Division Field( Look up from Division List) District Field(Look up field from District List) Facility Field(Look up field from Facility List) County Field(Look up field from County List) List Screenshots provided below can be refered for clarification. ----------------------------------------------------------------------------------------------------- PowerApps Canvas Apps In Power Apps Canvas App, We need to first design the app with the 4 respective fields Since those fields are multiselect, then it is to combo box. Generally power apps are not supported for multiselect cascasding dropdown. Refere microsoft documentation, Know Limit...

SharePoint & Power Apps Learning

Search This Blog