Unanswered

Updating an entry instead of creating a new one.

(0) Share

Report

Posted on by nshaw75

440

Hi guy's with some help I have managed to get a schema to attach a file from my app to a SharePoint list. This is the schema I have

Patch('Permit Tracker', Defaults('Permit Tracker'),

{

Title: "TESTING PATCH"},

Form3. Updates );Navigate(Screen2);

This works great to attach the file to the new item it creates in the sharepoint list. However, I need the SharePoint list item to update the original item and not create a new one.

I got a tip to add a line in - ID= YourRecordID alas, that didn't work, no doubt I should have used inverted commas etc

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

nshaw75 440 on at

Like (1)

Report
Copy link

Link copied!

Yeah, there are some great video's to help, I also like Reza Dorani, he has a lot of really useful videos, which as you say gets you thinking in the right way. I always find though that the examples that are shown are not exactly what I want from and app and I have to try and combine different parts of the examples to get to what I want, then ask the Power Platform community for help yo get things finished. I have definitely learned a lot, and thanks to you and everyone else who has answered my queries 😊

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I get that the start with power apps is not easy. It helped me to watch some videos of Shane Young from power apps 911 to get in the "Power apps state of mind" and understand what power apps expects from me to get what I expect from power apps.

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

@DBO_DV thanks for the reply. I did manage to get it working by having the attachment control back in the form. A colleague from work showed me their app and I somehow replicated theirs. Most of the issues I manage to sort out tend to be just pure luck or by trying things a million and one times.

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @nshaw75,

it Depends are you trying to submit it from a form or any other control?

Was this reply helpful? Yes No
nshaw75 440 on at

Like (0)

Report
Copy link

Link copied!

Hi @DBO_DV thanks for the help. I am now getting the following error.
I wanted to just check when it states my record ID it is looking for the ID column in the SharePoint list which in my scenario is labelled "ID". Would we therefore say ID = ID in the formula?

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hey @nshaw75 ,
Patch('Permit Tracker', LookUp('Permit Tracker',YourRecordID=ID), { Title: "TESTING PATCH"}, Form3. Updates );Navigate(Screen2);

The issue was the Defaults(), this function indicates to create a new entry. With the lookUp you can tell which one to adapt.

Was this reply helpful? Yes No