Code for Saving back to SQL table not working

[Anonymous]

The code I am using - kind of copied and modified from someone else's code I found online - which is to save changes made to editable field in PowerApps back to the SQL table - is not working. I tested by editing the field "Meeting Notes" for one project, and then clicked on the Save icon, then went to check the SQL table, and the change was not there.

Below is the screenshot of the PowerApps. The circled box is the editable field "Meeting Notes", which is a TextInput.

When user makes changes to that field, and then clicks on the Save icon, the code is set to:

OnSelect = Patch(ProjectTrackerPowerApps, First( Filter(ProjectTrackerPowerApps, ProjectTrackerID=Value(First([@PowerBIIntegration].Data).ProjectTrackerID)),{'Meeting Notes':TextInput1.Text)

(p.s. "ProjectTrackerPowerApps" is the table of the SQL table)

Thanks!

[RandyHayes]

@Anonymous 

You have a syntax error in your formula.  Plus, you would want to always avoid First(Filter as it creates a performance issue in the app.  The LookUp function performs the same process without the performance hit.

The formula should be:

Patch(ProjectTrackerPowerApps, 
    LookUp(ProjectTrackerPowerApps, 
        ProjectTrackerID=Value(First([@PowerBIIntegration].Data).ProjectTrackerID)
    ),
    {'Meeting Notes':TextInput1.Text}
)

This can also be changed to the following:

Patch(ProjectTrackerPowerApps, 
    {ProjectTrackerID=First([@PowerBIIntegration].Data).ProjectTrackerID,
     'Meeting Notes':TextInput1.Text
    }
)

Although you might not be hitting the right record based on looking at the First of the integration data, but that is hard to tell from your description and without knowing your app more.

I hope this is helpful for you.

[Anonymous]

Thanks @RandyHayes . I don't think this will work because I just noticed that one test record where I have put "This is test notes!" in the Meeting Notes field, that value is not showing up in the Meeting Notes field of the Powerapps. (Pls see screenshot). The Meeting Notes field in the Powerapps is a textinput component and the code is set to:

Default = First([@PowerBIIntegration].Data).'Meeting Notes'. 
Can you please help me correct this code so that the Meeting Notes shows up, and then I can test the Save code you kindly shared. Thank you!

[RandyHayes]

@Anonymous 

Well I feel your first issue is with First.  Why are you just working with the First record?  It seems you have a gallery there with multiple items in it.

Can you clarify?

[Anonymous]

Being 2 weeks old into PowerApps, when I created my PowerApps form and integrated into the PBI report, I kept having the "Getting your data" message hanging. Then after some searching online, I came across this solution: https://www.c-sharpcorner.com/forums/how-to-solve-the-getting-your-data-error-message-in-powerapps and used the code the person suggested and after I did, the data appeared when I opened the PowerBI report and the PowersApps loaded. So I was happy with that. But clearly, if that created a different issue, then I would want to correct that.

Can you please advise (suggest solution or code)?

I have been through so many video tutorials and forums and what not, and it's really difficult with no background in short time to fix things (I have a project deadline). Thank you Randy!

[RandyHayes]

@Anonymous 

Well let's start with your Gallery then...what is the Items property of your Gallery?

[Anonymous]

I don't have a Gallery. I tried working with a Gallery because so many tutorials show that - but it didn't work for me in the sense that the project selected in the PowerBI wasn't filtering in the PowerApps at all. Then when I took a different approach - no Gallery, just adding labels to the Tree View (see attached screenshot), I managed to at least get the project to filter. 

If possible, can we work with this Tree View because the filtering works. I just need the Project Name and Meeting Notes field values to display properly in the front end - ProjectTrackerID and Project ID display but not the other 2. This is a separate, but clearly related, issue I have also asked in separate thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/Label-value-not-displaying/m-p/1660884#M4229...

Thanks Randy.

[RandyHayes]

@Anonymous 

As I looked at your picture, it appears that you have a gallery as you offer a selection of an item.  Upon further looking at it, I realize that you are actually showing your PowerBI interface with your app next to it as it comes up.

Yes, so if you are only concerned with one record in your app as it is passed from the integration, then First is fine.

Let's focus on one thing though to start...the meeting notes.

Change the Default property to:

LookUp(ProjectTrackerPowerApps, 
        ProjectTrackerID=First([@PowerBIIntegration].Data).ProjectTrackerID,
       'Meeting Notes'
)

What is the result of that?

[Anonymous]

@RandyHayes You are a hero !!! It worked! Meetings Notes show up now! (see screenshot). Thank you!!! 

Now do you know why Project Name doesn't show up? 

The code for Project Name is: 

Text = First([@PowerBIIntegration].Data).'Project Name'

It's the same as for ProjectTrackerID and Project ID, but those 2 show up and Project Name doesn't.

Will also try the Save code now. 

YOU ARE GODSEND! (Literally)

[RandyHayes]

@Anonymous 

Glad to help!!  🙂

So let's change the Text property of the Project Name to this:

LookUp(ProjectTrackerPowerApps, 
        ProjectTrackerID=First([@PowerBIIntegration].Data).ProjectTrackerID,
       'Project Name'
)

You'll notice that what is different with these is that we are looking up the actual columns directly from the datasource...not from the integration.  The only thing we are getting from the integration is the ProjectTrackerID...which is all we need.