Answered

PowerApps gives empty values to Flow (sometimes)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Currently I'm developing a PowerApp, the goal of the PowerApp is to provide the users the ability to browse to data, edit data and send it to another table in the Azure SQL Server. I'm using Microsoft Flow together with a stored procedure to transfer data from table1 to table2. It works fine, but after a couple of flow triggers the PowerApp wil give empty values to the flow. The empty values are in completely random columns and it isn't allied to a certain amount of time.

When refreshing the PowerApp (ctrl + F5) the flow gets all the normal values again, so it looks like it has something to do with the PowerApps cache, but that's an assumption. I use alot of variables to fill the values in my Flow, probably this will take up a lot of memory.

Does someone know how I can find the solution to this issue? Feel free to ask any questions!

Thank you in advance!

Kind regards.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Max44 223 on at

Like
a
(0)

Report
Copy link

Link copied!

Perhaps you can add an condition to check if the dynamic content is null or not. Try with the condition like this:
@empty(triggerBody()?['']).

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you mean that the canvas app would pass empty value to your flow?

Based on the issue that you mentioned, I have made a test, and don't have the issue that you mentioned. Please make sure you have specified proper value for these arguments of the 'FlowName'.Run(....) function within your canvas app.

Also please make sure the Network is in good condition on your side. The Network state would also affect transferring data from canvas app to flow.

As an alternative solution, I think it is not necessary to specify one argument within your flow for each parameter value you want to pass from your app. Instead, you could consider only specify one string parameter (which you want to pass from your app) within your flow using "Ask in PowerApps" dynamic content.

Within your app, set up a collection to store the parameter values you want to pass to flow. Then use JSON function to convert the collection data into a JSON Table string value, then specify the converted JSON Table string value as argument within the 'FlowName'.Run(...) function.

After that, within your flow, you could use the json expression to convert the passed JSON Table string value into a JSON Array value. Then you could apply a "Apply to each" action to this converted JSON Array value. Within the "Apply to each" action, you could add a "Insert row" action of SQL Server connector, within the "Insert row" action, you could use the following expression to reference the column value from the JSON Array value:

item()?['ColumnName']

More details about passing a collection value from canvas app to Power Automate flow, please check the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Save-a-multiples-rows-of-items-in-a-single-fields-in-SharePoint/m-p/359596#M102804

https://powerusers.microsoft.com/t5/Building-Power-Apps/Running-a-power-automate-flow-on-multiple-records-from-Power/m-p/459855

https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-ForAll-to-run-a-Flow-and-pass-in-parameters-from-a/m-p/449002

Best regards,

Was this reply helpful? Yes No
pp_dev 75 on at

Like
a
(0)

Report
Copy link

Link copied!

I am facing a similar issue. In my power apps, I pass multiple values; some of them initialise in OnStart, but in Flow, it sometimes gets that value and sometimes does not. This is seriously killing me. How many checks do I need to add in Flow and in the Power Apps? This is ridiculous.

Was this reply helpful? Yes No
ahemad 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I am also encountered with same problem, if there is any solution pls help.

I have passed collection to flow using json function, but sometimes the flow receives one column values for some row out of 150+ row as blank although the in collection those values are not blank.

I not able to resolve this pls guide me on this.

Was this reply helpful? Yes No
Hancha 101 on at

Like
a
(0)

Report
Copy link

Link copied!

I´m unfortunatelly having the same issues data from datapickers/comboboxes sometimes are not passed into flow
frequency approx. 1 of every 15 runs...

The dates are required (the button triggering flow is disabled until a date is chosen)
I´m using a collection transferred into JSON as flow parameter....
It´s maddening...

Was this reply helpful? Yes No