Power Platform Community Forum Thread Details

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:

Building Power Apps