Urgent - Using SQL flow response in a gallery

(0) Share

Report

Posted on by LostMary

Hi,

I have created a flow which, based on input from my canvas app, executes a SQL stored procedure. This returns several records from a really large database, and I am using the Response action to pass "ResultSets" into my app, which I then want to populate a Gallery.

This is what I am currently doing...

Screen OnVisible

ClearCollect(colSalesLT, FirstN('SalesLT.Customer', 100))

Gallery's Items

If(IsEmpty(colSalesLT), FirstN('SalesLT.Customer', 100), colSalesLT)

I have a button which takes the content of a text input field, and runs the flow. It's OnSelect is:

UpdateContext({varLoading: true});
UpdateContext({varFilter: TextInput1.Text});
ClearCollect(
 colSalesLT,
 Getpatients.Run(First(Split(Trim(varFilter), " ")).Value, Last(Split(Trim(varFilter), " ")).Value)
);
UpdateContext({varLoading: false});

The flow runs fine, but the gallery is empty. Why could this be?

Thanks

LM.

Categories:

Building Power Apps

All responses (1)

Answers (0)

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LostMary , The Screen OnVisible and Gallery's Items are same, So I dont understand the reason of using that because more or less both are same.

Can you confirm that the Response action that you are using in Flow is getting the output with proper scheme ?

Thanks,
ANB