cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pyee
Advocate III
Advocate III

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

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-nul...

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
pyee
Advocate III
Advocate III

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.

v-yamao-msft
Community Support
Community Support

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-nul...

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

GabrielStJohn
Microsoft
Microsoft

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

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Meidhi_78410
Frequent Visitor

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

 

PA

image.png

SQL

image.png

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (19,779)