Read and Write SQL Data Source Different - SQL Server with Power BI Integration

(0) Share

Report

Posted on by SG202311

Hi Everyone,

Hoping to find solution like my last post

Below is the snip of prototype i am working on. I have a form in Power BI and i want the users to edit the record whichever they select or create a new entry when they choose New Button.

Currently Dropdowns and Table are reading from same SQL Table except for Strain Dropdown.

I changed the "items" property drop down to Distinct('dbo.ProductDetails' , StrainName), so that it reads from another table.

I have 2 problems with this approach -

1) when i choose an Existing record in Power BI table this value is not getting populated

2) Only 2 records are being pulled from Database for Strain Column , though i haven't restricted anywhere

End Goal - I need to Create Dependent Dropdowns which are reading from different tables. Each Dropdown has its own source or in some cases 2 dropdowns read from same table.

Read Tables and Write tables are different. On Submit form I want to submit values into a different table. How do i configure it?

Any help will be greatly appreciated

Thanks in Advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SG202311,

To populate the Strain dropdown, you need to set its Default property as:

LookUp('dbo.ProductDetails' , StrainName=Gallery.Selected.Strain)

Since you have set its Items with another table, you need to retrieve this value from the 'dbo.ProductDetails'.

Was this reply helpful? Yes No
SG202311 18 on at

Like
a
(0)

Report
Copy link

Link copied!

This doesn't work ..
Below is the error i get. Screenshot shows the actual table name which i have renamed to dbo.ProductDetails in the post

Also I do not have any Gallery defined. All i have is these

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SG202311,

Gallery.Selected could be replaced with the formula you set for the Item property of the form.

So, replace it and specify the Strain field.

Was this reply helpful? Yes No