Query multi tables

(0) Share

Report

Posted on by usaman45

314

I have two tables in SQL: one named Header and the other named Detail. The Detail table can be returned as an array.

Therefore, I want to call a single SQL stored procedure and retrieve it back to Power Apps in two parts - one for the header and the other for the detail. How can I achieve this?

All responses (1)

Answers (0)

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: Query multi tables

@usaman45

You can add two individual SQL datasources in PowerApps which will retrieve the data separately.

You can bind the Detail table to a Gallery control and Header table to a form.