Using Stored Procedure to populate Collection But only getting "?"

(1) Share

Report

Posted on by Jsunnb

So I was able to finally successfully get a table to return from a stored procedure using PowerApps by referencing this question
https://community.powerplatform.com/forums/thread/details/?threadid=cc17d0dc-618d-4a61-be00-2e56a1cb0c4d

However, when use this code: (sorry about having to rename things, but in general you can see the structure)

ClearCollect(
    colRedactedName,
    Table(
        RedactedSource.dboRedactedStoredProcedureName(
            {
                Var1: Blank(),
                Var2: Blank(),
                Var3: Blank(),
                Var4: Blank(),
                Var5: Blank(),
                Var6: Blank(),
                Var7: Blank(),
                Var8: Blank(),
                Var9: Blank(),
                Var10: Blank(),
                Var11: Blank(),
                Var12: Blank(),
                Var13: Blank(),
                Var14: Blank(),
                Var15: Blank()
            }
        ).ResultSets.Table1
    )
)

This is what I get when I look at the collection

When I do that same stored procedure in MS SSMS, I get the exact same number of rows, so it does appear to be sorta working, but I don't understand why each record comes back as a question mark. Any guess what I'm doing wrong?

Categories:

Connecting to Data

All responses (1)

Answers (0)

Jsunnb 61 on at

Like (0)

Report

Using Stored Procedure to populate Collection But only getting "?"

I think I stumbled across the answer as I was trying everything. Basically, on my gallery, I need to use ThisItem.Values.Var1. Its just that the Var1 won't autofill, so you have to now how your stored procedure is returning. Honestly, that is fine for me since I also made the stored procedure, but I could see that being difficult if there were someone making it for you.