Fill a gallery from the response of a Stored Procedure

(0) Share

Report

Posted on by JohanBoerema

I'm trying to build a Gallery from the response of a Stored Procedure. I have created the flow in Power Automate:

The SP is working correct, when I check the history.

Also the response seems to work:

In the PowerApp I call this Flow, when I click an icon:

ClearCollect(queryResults,Gethoursperweekperuser.Run("...","2021-01-01","2021-02-02"))

When I now add a gallery, I can't assign any of the columns of the Response in here:

I just see 'Value'. What am I doing wrong in here?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Pstork1 69,270 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Are you binding the gallery to the collection? If so then you'll need to set the values for the fields manually using ThisItem.fieldname. They don't show up in the list when binding to a collection.

Was this reply helpful? Yes No
JohanBoerema 10 on at

Like (0)

Report
Copy link

Link copied!

Yes, I have set the data source of the gallery to the collection. When I then manually set my field to ThisItem.Projectcode, I get a formula error. Is that the case when you do it like this?
Also the field stays empty, while the response in the history does show values:

Was this reply helpful? Yes No
Pstork1 69,270 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you do a View Collection and drill down into that? It should look something like this after runing the stored procedure flow.

Was this reply helpful? Yes No
JohanBoerema 10 on at

Like (0)

Report
Copy link

Link copied!

Looks like the issue is in the collection:

Was this reply helpful? Yes No
Verified answer

Pstork1 69,270 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

When all you get back is a boolean that usually means that something about the JSON schema you have in the Response action isn't correct. I would try doing a parse JSON on the results using that schema and make sure you see the right results inside the flow. Then you'll have some confidence that the schema is correct. Also make sure to remove and re-add the flow in Power Apps everytime you make a change in Power Automate. Not doing that can result in a mismatched schema since a snapshot of the schema is taken when you add it to Power Apps.

Was this reply helpful? Yes No
JohanBoerema 10 on at

Like (0)

Report
Copy link

Link copied!

That's it thanks! Deleted it from the app and added it again, now it is working 🙂

Was this reply helpful? Yes No