Power Platform Community Forum Thread Details

Hello.

I am building a flow connected to power apps that exports csv when a button is clicked given the input from set of filters. However, I am having problems with dataverse connector as it does not accept null values and does not trigger my flow when added.

I stumbled with many forums and I think it has something to do with dataverse accepting the schema of powerapps v2 connector with null values directly. However, I cannot modify the schema of the connector unless a trigger condition is set (maybe??)

I tried to use Parse JSON connector to replicate the issue.
using the copied shcema from powerapps v2 connector:

"type": "object",
 "properties": {
 "text": {
 "title": "ListBoxProvince",
 "type": "array",
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "BATANGAS",
 "BULACAN",
 "CAMARINES SUR",
 "CAVITE",
 "CEBU",
 "LEYTE",
 "NUEVA ECIJA",
 "QUEZON",
 "SOUTH COTABATO",
 "TARLAC",
 "ZAMBALES"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_1": {
 "title": "FilteredBox_Classification",
 "type": "array",
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "TO BE IDENTIFIED",
 "FOR VERIFICATION",
 "NOT AVAILABLE",
 "NOT USABLE",
 "OPEN TO SALE",
 "OPEN TO LEASE",
 "SECURED SALE",
 "SECURED LEASE"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_2": {
 "title": "FilteredBox_ProjectTag",
 "type": "array",
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "BAT-1",
 "BAT-2",
 "BAT-3",
 "BULROW",
 "CAB",
 "CABROW",
 "MIG(TAG)",
 "NAI",
 "NE-2 NAGSAAG",
 "NUE-1",
 "NUE-2",
 "PAL",
 "QUE-1",
 "QUE-2",
 "SIL",
 "SRA",
 "TAR-1",
 "TAR-2",
 "TAR-3A",
 "ZAM-1"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_3": {
 "title": "FilteredBox_Entity",
 "type": "array",
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "CIHC",
 "LHHC",
 "LLL",
 "MBHC",
 "PIC",
 "SPBULC",
 "SPCC",
 "SPCRPI",
 "SPNEC",
 "SPPPHI",
 "SPTAGC",
 "SPTANC",
 "SPTARC",
 "TNI"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_4": {
 "title": "FilteredBox_Type",
 "type": "array",
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "LAND",
 "ROW"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_5": {
 "title": "FilterBox_Muni",
 "type": "array",
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "ALITAGTAG",
 "CALATAGAN",
 "LIAN",
 "CALACA",
 "NASUGBU",
 "BALAYAN",
 "TUY",
 "SAN JUAN",
 "CABANATUAN CITY",
 "PENARANDA",
 "TANAUAN CITY",
 "ROSARIO",
 "SANTA ROSA",
 "SAN MIGUEL",
 "SAN LEONARDO",
 "SAN ILDEFONSO",
 "GAPAN CITY",
 "DONA REMEDIOS TRINIDAD",
 "SAN RAFAEL",
 "ANGAT",
 "NORZAGARAY",
 "SAN JOSE DEL MONTE",
 "GENERAL TINIO",
 "STA. MARIA",
 "PILI",
 "NAGA",
 "BULA",
 "OCAMPO",
 "MILAOR",
 "MINALABAC",
 "MARAGONDON",
 "TIGAON",
 "TERNATE",
 "MAGALLANES",
 "MEDELLIN",
 "NAIC",
 "DAANBANTAYAN",
 "KANANGA",
 "TAGOLOAN",
 "ORMOC CITY",
 "GENERAL TINIO",
 "SANTA ROSA",
 "CABANATUAN CITY",
 "PENARANDA",
 "GAPAN CITY",
 "SAN ILDEFONSO",
 "PANTABANGAN",
 "SAN MIGUEL",
 "SAN RAFAEL",
 "DONA REMEDIOS TRINIDAD",
 "EL NIDO",
 "ABORLAN",
 "AGNO",
 "BURGOS",
 "MABINI",
 "DASOL",
 "UMINGAN",
 "BANI",
 "BOLINAO",
 "INFANTA",
 "LUCENA",
 "DOLORES",
 "CANDELARIA",
 "LUCBAN",
 "SAN ANTONIO",
 "SARIAYA",
 "PAGBILAO",
 "MAUBAN",
 "POLOMOLOK",
 "TIAONG",
 "GENERAL SANTOS CITY",
 "TAYABAS",
 "SAN JOSE",
 "CONCEPCION",
 "TARLAC CITY",
 "MAYANTOC",
 "PURA",
 "LA PAZ",
 "SANTA IGNACIA",
 "CAPAS",
 "IBA",
 "BOTOLAN",
 "PALAUIG",
 "MASINLOC"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 }
 },
 "required": []
 }

and it resulted to this.

when a schema is modified to this:

{
 "type": "object",
 "properties": {
 "text": {
 "title": "ListBoxProvince",
 "type": [
 "array",
 "null"
 ],
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "BATANGAS",
 "BULACAN",
 "CAMARINES SUR",
 "CAVITE",
 "CEBU",
 "LEYTE",
 "NUEVA ECIJA",
 "QUEZON",
 "SOUTH COTABATO",
 "TARLAC",
 "ZAMBALES"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_1": {
 "title": "FilteredBox_Classification",
 "type": [
 "array",
 "null"
 ],
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "TO BE IDENTIFIED",
 "FOR VERIFICATION",
 "NOT AVAILABLE",
 "NOT USABLE",
 "OPEN TO SALE",
 "OPEN TO LEASE",
 "SECURED SALE",
 "SECURED LEASE"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_2": {
 "title": "FilteredBox_ProjectTag",
 "type": [
 "array",
 "null"
 ],
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "BAT-1",
 "BAT-2",
 "BAT-3",
 "BULROW",
 "CAB",
 "CABROW",
 "MIG(TAG)",
 "NAI",
 "NE-2 NAGSAAG",
 "NUE-1",
 "NUE-2",
 "PAL",
 "QUE-1",
 "QUE-2",
 "SIL",
 "SRA",
 "TAR-1",
 "TAR-2",
 "TAR-3A",
 "ZAM-1"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_3": {
 "title": "FilteredBox_Entity",
 "type": [
 "array",
 "null"
 ],
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "CIHC",
 "LHHC",
 "LLL",
 "MBHC",
 "PIC",
 "SPBULC",
 "SPCC",
 "SPCRPI",
 "SPNEC",
 "SPPPHI",
 "SPTAGC",
 "SPTANC",
 "SPTARC",
 "TNI"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_4": {
 "title": "FilteredBox_Type",
 "type": [
 "array",
 "null"
 ],
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "LAND",
 "ROW"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 },
 "text_5": {
 "title": "FilterBox_Muni",
 "type": [
 "array",
 "null"
 ],
 "x-ms-dynamically-added": true,
 "description": "Please enter your input",
 "items": {
 "enum": [
 "ALITAGTAG",
 "CALATAGAN",
 "LIAN",
 "CALACA",
 "NASUGBU",
 "BALAYAN",
 "TUY",
 "SAN JUAN",
 "CABANATUAN CITY",
 "PENARANDA",
 "TANAUAN CITY",
 "ROSARIO",
 "SANTA ROSA",
 "SAN MIGUEL",
 "SAN LEONARDO",
 "SAN ILDEFONSO",
 "GAPAN CITY",
 "DONA REMEDIOS TRINIDAD",
 "SAN RAFAEL",
 "ANGAT",
 "NORZAGARAY",
 "SAN JOSE DEL MONTE",
 "GENERAL TINIO",
 "STA. MARIA",
 "PILI",
 "NAGA",
 "BULA",
 "OCAMPO",
 "MILAOR",
 "MINALABAC",
 "MARAGONDON",
 "TIGAON",
 "TERNATE",
 "MAGALLANES",
 "MEDELLIN",
 "NAIC",
 "DAANBANTAYAN",
 "KANANGA",
 "TAGOLOAN",
 "ORMOC CITY",
 "GENERAL TINIO",
 "SANTA ROSA",
 "CABANATUAN CITY",
 "PENARANDA",
 "GAPAN CITY",
 "SAN ILDEFONSO",
 "PANTABANGAN",
 "SAN MIGUEL",
 "SAN RAFAEL",
 "DONA REMEDIOS TRINIDAD",
 "EL NIDO",
 "ABORLAN",
 "AGNO",
 "BURGOS",
 "MABINI",
 "DASOL",
 "UMINGAN",
 "BANI",
 "BOLINAO",
 "INFANTA",
 "LUCENA",
 "DOLORES",
 "CANDELARIA",
 "LUCBAN",
 "SAN ANTONIO",
 "SARIAYA",
 "PAGBILAO",
 "MAUBAN",
 "POLOMOLOK",
 "TIAONG",
 "GENERAL SANTOS CITY",
 "TAYABAS",
 "SAN JOSE",
 "CONCEPCION",
 "TARLAC CITY",
 "MAYANTOC",
 "PURA",
 "LA PAZ",
 "SANTA IGNACIA",
 "CAPAS",
 "IBA",
 "BOTOLAN",
 "PALAUIG",
 "MASINLOC"
 ],
 "type": "string"
 },
 "x-ms-content-hint": "TEXT"
 }
 },
 "required": []
}

I am now getting this output:

Is there any way to modify the power apps schema by setting up the trigger condition of powerapps v2 connector?

Thanks,

Categories:

Building flows

Actually, that's what I'm doing. I'm trying to replace null values with blank arrays by adding compose function. However, my flow still got this error whenever I add list rows dataverse connector.

and here's my onselect property code that made this error:

// Export CSV and Get File URL
Set(
 csvfileURL,
 'Copyof-EXPORTCSV'.Run(
 {
 text: ListBoxProvince.SelectedItems.Value,
 text_1: FilterBox_Classification.SelectedItems.Value,
 text_2: FilterBox_ProjectTag.SelectedItems.Value,
 text_3: FilterBox_Entity.SelectedItems.Value,
 text_4: FilterBox_Type.SelectedItems.Value,
 text_5: FilterBox_Muni.SelectedItems.Value
 }
 ).fileurl
);

// Notify User
Notify("The copy of csv file has been sent to your email successfully. Please check your inbox.", NotificationType.Information);