Answered

Update SQL Table with Patch for Multiple Records from PowerBI Integration

(0) Share

Report

Posted on by StephenR

Good day, for the life of me I can't seem to figure this out. I have a Power BI report with a table that is connected to a power app so users can update the records they select in the report on the SQL table. I can get this to work for a single record perfectly fine, but when trying to update multiple with a ForAll using

ForAll([@PowerBIIntegration].Data, Patch(CSTargetList,LookUp(CSTargetList,CSTListId = Value(Label2.Text)), {ApprovalStatus:Dropdown1.SelectedText.Value, TargetListName:TargetListName, Serial:Serial}))

Only the first record of the Gallery is updated not all of the items. if I change the Value(Label2.Text) to Gallery.AllItems.Label2 I get a comparison error of Text to Table. So currently stuck.

Any help would be appreciated.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-yujincui-msft on at

Like (0)

Report
Hi @StephenR ,

Maybe you could try the following formula:
ForAll([@PowerBIIntegration].Data, Patch(CSTargetList,LookUp(CSTargetList,CSTListId = [@PowerBIIntegration].Data[@CSTListId]), {ApprovalStatus:Dropdown1.SelectedText.Value, TargetListName:TargetListName, Serial:Serial}))

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report

Hi @StephenR ,

Is your problem solved?

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
StephenR 17 on at

Like (0)

Report

Thank you so much for this, sorry I can't believe I never came back and properly thanked you!

Was this reply helpful? Yes No