web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to call a view bas...

Power Apps

Unanswered

How to call a view based stored procedure on gallery in Power apps

(0) Share

Report

Report

Posted on by tsangd

39

I want to call my stored procedure which contains a view class in power apps gallery, I managed to set a button to update the table but unfortnately i get an error when I try to implement the flow which contains the stored procedure in gallery (items),

image 1) Power apps error when I try to add the flow powerAppビュー to my gallery.

image2) SQL stored procedure [allTable] using view table [created allTable] View

image3) power automate flow using stored procedure allTable

Microsoft SQL, stored procedure which uses the view table "allTableView"

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @tsangd :

Firstly, you could add a response action to return a table from flow to the app.

Passing Collections from Power Automate to App

Seconldy, flow.run() is a Behavior formula and cannot be used directly as a gallery item, you could try:

Add a button and set it's OnSelect property to:

ClearCollect(TheCollection,FlowName.run())

Set the gallery's items property to:

TheCollection

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation