Its just started today we are experiencing the problem. The following message pops up
Everything else seems like its working its collecting data, saving in the SQL Azure table. As well as runs the flow and creates a row on the SharePoint list.
The flow is straight forward:
Any ideas whats happening. Is that because Microsoft modified the PowerApps platform?
I have made a test on my side, I don't face the issue that you mentioned, but I face the the error as below:
Even though I type a proper value within Row id field of "Get row" action, the error still shows up. My flow's configuration as below:
In addition, I could not choose a Table value via drop down within Table name field of "Get row" action, it always shows "No Item". But when I add a "Get rows" action within my flow, I could choose a Table value via drop down within Table name field of "Get rows" action.
If you want to get a row from a table which is stored in Azure SQL DataBase, you could also consider take a try with the following workaround:
Within "Filter query" field of "Get rows" action, type the following formula (OData query):
id eq 1
Note: the id is a column in my Azure SQL table and it is the Identity column in my Azure SQL table. I use OData query to filter the rows of the Azure SQL table and find the specific row.
The flow works successfully as below:
If you want to take a try with the above solution, please make sure that there is a Identity column within your Azure SQL table.
More details about OData query in SQL Server, please check the following article:
This is not the problem.
The problem is, calling any flows from the Powerapps would create this error message.
Here is the reply from MS support.
Please let us know when this can be resolved.
This is impacting our production system, and MS's reputation is at stake.
Sorry about the delay in response. They have not given an ETA as of yet for this. I have reached out to get an update as multiple users are seeing this same message in their PowerApps.
Please reach out with any questions.
BAP - Power Bi | PowerApps |Microsoft Flow
Time Zone: Eastern Time (US and Canada) (UTC -05:00)
Hours: 9 AM – 6 PM Mon- Fri
P: +1 (980) 7762655
If you have any questions or comments regarding the service I have provided, please feel free to reach out to my manager Brian Schumer firstname.lastname@example.org
We also confirmed that the issue no longer persists.
The most unacceptable thing here is, this issue affected the already published app in our Prod environment.
What a lousy upgrade.
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!