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

I have the same question (0)

All responses (1)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No