Unanswered

Dynamically take data from Power Apps to SQL

(0) Share

Report

Posted on by bulprosbibg

Hello,

I've created a stored procedure with Flow and use it in Power Apps. The problem is when I want to take the data as it is dynamically. Im having 13 columns and when I use 'PowerApp->Executestoredprocedure(V2)'.Run(1,2,3,4,5,6,7,8,9,10,11,12,13) manually the stored procedure works, but I want to make it dynamically. All the columns have different sets. Can anyone tell me how to take the dynamically data from these columns?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@bulprosbibg

You might need to give an example here. I’m not sure what meant by manually vs dynamically.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
bulprosbibg 21 on at

Like (0)

Report
Copy link

Link copied!

Okay. For example:

1) I have one table in my database which is called Flow with 13 different columns
2) Each of these columns has different value
3) I've created the following Flow:
+ 10 more columns
4) When I include 13 records in the Run propery from the Flow it works and 13 records are inserted in my database
5) You can see how the database looks now:
6) I want to use the following records automatically from Power Apps:

But I dont know how to include them in the "Run" statement

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @bulprosbibg

It looks like this might be the same, or very closely related to what I've posted here. Can you see if that helps?

https://powerusers.microsoft.com/t5/Building-Power-Apps/Insert-records-to-SQL-database/m-p/613717/highlight/false#M193652

Was this reply helpful? Yes No