Unanswered

Building a powerapp into a power BI dashboard. Data problems

(0) Share

Report

Posted on by ClayTrinitas

Hi,

Background, I am trying to build a powerapp into my power BI dashboard. What I have done is build out a Sharepoint online list and connect it to my BI dashboard. Then I use the custom powerapps visual in my dashboard to create a new app using the uploaded data from Sharepoint. It takes me over to my powerapps platform to build out the powerapp at that point.

Problem: I have a gallery built from the powerbiintegration that I have connected to the powerapp, this gallery seems to work fine. The problem is, when I am trying to build a form that is connected to the Sharepoint data set directly (so I can write to the data directly), it doesnt seem to understand or have a primary key or something, that links the two data sets (powerbiintegration & Sharepoint list). I am trying to have the form "item" use Gallery1.Selected , to select the parent or that particular data set selected. I continue to get this error message though "Invalid formula, expected a value compatiable with data source", and I'm not sure how to fix it. Not even sure whats wrong with it. I'm following the same process that multiple video tutorials follow, and this problem does not arise in those videos. Does anyone know how to fix this or how to work around it? (preferrably fix the problem)

Here is my sharepoint data set. Same data set is connected to Power BI and connected to powerapps to write directly to this data set.

Sharepoint Projection Data Pic.PNG

Follow up question: The above seems to be the correct way to edit the powerapp data that is also connected to the sharepoint list. But is there a way to have just the one initial gallery screen on the app, that is linked to the powerbiintegration data. And insert a test input box that could update the sharepoint list directly using a patch function, instead of having to navigate to a separate form screen, that is connected to the other data set? I could not get the patch function to work properly, kept returning a "the value is out of scope" error message.

Just curious if anyone can help me solve this problem, It is much appreciated!!!!

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xida-msft on at

Like (0)

Report
HI @ClayTrinitas ,

Do you want to edit your SP List dataset within your embedded canvas app in your Power BI report?

Based on the issue that you mentioned, I think there is something wrong with your operation in your canvas app. Firstly, you need to add your same SP List data source into this embedded canvas app (check the following screenshot for adding SP list data source into this app😞

Then go your Edit form screen, set the DataSource property of the Edit form to your above added SP List data source. Then set the Item property to following:

LookUp('Your SP List', ID = Gallery1.Selected.ID)

Note: I assume that you enabled the "ID" column into the PowerBIIntegration from your BI Report.

For your second question, yes, I think it is not necessary to add a Edit form in your embedded canvas app to achieve your needs. You could consider configure the Gallery as a Editable tabular (add a Text Input boxes inside your Gallery), and add a "Save" icon inside this Gallery, set the OnSelect property of this "Save" icon to following:

Patch( 'Your SP List', LookUp('Your SP List', ID = ThisItem.ID), { ColumnName: TextInputBox.Text } )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
ClayTrinitas 4 on at

Like (0)

Report

The first answer worked great!! I had looked at doing to Lookup function before but wasn't sure how to format it properly. Thank you for you help on that, much appreciated!

Question 2 though, did not seem to work unfortunetly. It continued to give me the error "value is out of scope" or something along those lines. I forgot to copy and paste it, I apologize. But it was the same original error I had been getting from before. Any idea on how to fix that, or another solution maybe for the second question?

Thank you!!!

Was this reply helpful? Yes No
KatieL1 26 on at

Like (0)

Report

Hello,
I'm having this same issue as listed here for number 1.
As you will see in the image, I added the lookup function and the warning icon changed from a red exclamation to a yellow hazard. Sill not returning my details.
error reads "Unexpected characters. The formula contains 'ParenClose' where 'Eof is expected."

Was this reply helpful? Yes No