Announcements
I've come a long way. I have a dataset in Power BI and I have developed a Flow.My flow can be seen in the image below. The image below shows my code in Power Apps.The problem is that I only see one row in my collection in Power Apps with the entire JSON from Power Automate. What steps do I still need to take, can anyone help me with this?
As you've discovered, the Respond to a Power App action cannot send back a table (array) of data. Instead, you need to use the Response action. This blog goes into detail about using the Response action, including making sure you define the output schema so the app can read it.
Hope that helps,
Bryan
Indeed, I saw something about the Response connector too. I'm curious how I should work with this, because he link you sent me is about SQL. What do I have to fill in in the body (and the headers?)
The body is the part that is going to carry your table payload back to the app. In the blog link I sent you, it works with an SQL query, but you can generalize it to any sort of tabular response. Here's a larger video link on the same topic that will cover much more than I can write in a few sentences. The key part - make sure you define the output schema or the app can't understand it. Also, you will no longer need the "Respond to a PowerApp or flow" action when you use the "Response" action
In this case, I'm using a Power BI dataset and not a Sharepoint List or a SQL Database. I'm using the Response connector now and this is what I got:
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 411 Super User 2026 Season 2
Mohsin Ali 338
WarrenBelz 256 Most Valuable Professional
