Unanswered

PowerApps Flow passing Blank() to stored procedure...

(0) Share

Report

Posted on by pyee

In PowerApps, I use a Coalesce([field], Blank()) formula to pass parameters to the Flow, which sends those parameters to my SQL stored procedure. When I look at the flow as it runs, what is actually getting passed is an object that looks like.

{
 "kind": 16,
 "severity": 1,
 "dataSourceName": null
}

Obviously, SQL is having trouble with this, since it really should just be passing a {null}... but it's getting:

sales={\r\n \"kind\": 16,\r\n \"severity\": 1,\r\n \"dataSourceName\": null\r\n}

What am I doing wrong here?

Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

pyee 35 on at

Like (1)

Report

Update:

I determined that the formula that was putting the data into the collection in the first place was simply: Value(Textbox1.Text). Apparently, when a textbox is blank, and you store the Value() of the Text property, it stores that object. So, I've updated that formula to be Coalesce(Value(Textbox1.Text, Blank()), and the Flow formula to Coalesce([field], 0), and it's passing 0's to the stored procedure as expected.

Still can't get it to work with Coalesce([field], Blank()), which would be preferable, but at least I can pass 0's and then handle 0s back into nulls on the stored procedure side.

Was this reply helpful? Yes No
Verified answer

v-yamao-msft on at

Like (1)

Report

Hi @pyee,

Do you want to pass a null value from PowerApps to flow?

I have seen a similar request on Flow Ideas Forum, please vote the idea at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Ability-to-set-a-PowerApps-parameter-to-Blank-i-e-null/idi-p/114503

Best regards,

Mabel Mao

Was this reply helpful? Yes No
GabrielStJohn on at

Like (0)

Report

Hello, @pyee!

Thank you for posting on the Flow Community Forum! If you have already posted your idea to the Flow Community Ideas Forum or found an existing idea to upvote, then you need to post the URL to the idea’s thread as a reply to this thread. Then click "Accept as Solution" on the reply if you approve it as a solution to your issue so that other users may vote for the Flow Idea and identify the information easily within this thread.

Thank You for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

Was this reply helpful? Yes No
Meidhi_78410 4 on at

Like (0)

Report

try with collapse in PowerApps and test the parameter in your stored procedure

PA
SQL

Was this reply helpful? Yes No