PowerApps gives empty values to Flow (sometimes)

[Anonymous]

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.

[Max44]

Perhaps you can add an condition to check if the dynamic content is null or not. Try with the condition like this:

@empty(triggerBody()?['']).

[v-xida-msft · Accepted solution]

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,

[pp_dev]

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.

[ahemad]

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. 

[Hancha]

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