Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
Dataverse Connector in Flows not acepting null values: TriggerMismatch compared to blank values
Post Flair (click to view more posts with a particular flair)
Post Body

Hi,

I am building an app that exports csv file using a list row dataverse connector in flow when a button is clicked. However, I am getting an error when adding the dataverse connector:

https://preview.redd.it/q88sth3yu8kc1.png?width=1905&format=png&auto=webp&s=7d36855577302c828247e2a1e52d97db0b3f0ad6

If it's removed, the trigger and flow proceeds and I get this output.

https://preview.redd.it/jg9g64pdv8kc1.png?width=1368&format=png&auto=webp&s=49169ab7a84df11f9cc86b2f86762296d24386e6

Here's my onselect value of the export button.

'Copyof-Copyof-EXPORTCSV'.Run(
        {
            text: If(IsEmpty(ListBoxProvince.SelectedItems.Value), Blank() , ListBoxProvince.SelectedItems.Value),
            text_1: If(IsEmpty(FilterBox_Classification.SelectedItems.Value), Blank(), FilterBox_Classification.SelectedItems.Value),
            text_2: If(IsEmpty(FilterBox_ProjectTag.SelectedItems.Value), Blank(), FilterBox_ProjectTag.SelectedItems.Value),
            text_3: If(IsEmpty(FilterBox_Entity.SelectedItems.Value), Blank(), FilterBox_Entity.SelectedItems.Value),
            text_4: If(IsEmpty(FilterBox_Type.SelectedItems.Value), Blank(), FilterBox_Type.SelectedItems.Value),
            text_5: If(IsEmpty(FilterBox_Muni.SelectedItems.Value), Blank(), FilterBox_Muni.SelectedItems.Value)
        }
)

Also, there's something weird happening in my filterboxes. When I initialize all by selecting and unselecting from dropdownlist, it only triggers when I select items in the filters and then unselect it which outputs this in PowerApps

https://preview.redd.it/3amaf004z8kc1.png?width=220&format=png&auto=webp&s=fa6755338661c62d69a073c4bb05df49d8cf7d4b

But before, when a filter is blank, it outputs like this where unselected and uninitialized filters are set to null. But this was made with no datasets connected or involved.

https://preview.redd.it/kw13v6j5z8kc1.png?width=343&format=png&auto=webp&s=8a2c30b64cd369d855d1434a575a805e7cecd83c

Can someone help me with this? Thank you.

Author
Account Strength
80%
Account Age
4 years
Verified Email
Yes
Verified Flair
No
Total Karma
3
Link Karma
3
Comment Karma
n/a
Profile updated: 4 days ago
Posts updated: 2 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
8 months ago