Answered

Updating info in PowerApps

(0) Share

Report

Posted on by PincheMaldy

Hello, I'm trying to update some data in Powerapps, I'm using Forall, Patch, and Lookup but I got an error because I'm not updating/including in the Patch instruction all the required fields, what can I do to solve it?

Example:

ForAll(updateCollection, Patch(Coll01,LookUp(Coll01, Coll01[@ProcessID]=updateCollection[@updID]),{Completed:completed})));

The error is: "Title: Field 'Title' is required", but I'm not interested in updating the value of Title.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Sid_Jafri 478 on at

Like
a
(0)

Report
Copy link

Link copied!

Then you make that field is not required or pass the same value that you already have

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@PincheMaldy

You (or SharePoint) has probably renamed the Title column. SharePoint "remembers" the original name and uses it in certain operations. Your choice is to go back into SharePoint and remove the required property from that column, figure out what the Title column has been renamed to, or add a dummy value to your patch for the Title. Then you can go back to SharePoint and see what happened with your patch. Something like

ForAll( updateCollection, Patch( Coll01,LookUp( Coll01, Coll01[@ProcessID]=updateCollection[@updID]), {Title:"SomeDummy",Completed:completed} ) ) )

Was this reply helpful? Yes No
PincheMaldy 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, thanks for your quick response, I have more than 5 required values in my list, Do I have to "update" all of them with the current value? Is there another way to update only specific data and not including the required fields?
I can include the required fields in my instruction but it would be great if I can send only the value that I need to update instead of all the required fields.

Was this reply helpful? Yes No
PincheMaldy 38 on at

Like
a
(0)

Report
Copy link

Link copied!

.

Was this reply helpful? Yes No
PincheMaldy 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for your response, Is there another way to update only specific data and not including the required fields?
I can include the required fields in my instruction but it would be great if I can send only the value that I need to update instead of all the required fields.

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PincheMaldy

Don't make the fields required in SharePoint. You can make them required in PowerApps and it will be easier to work with your data forms.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@PincheMaldy

For some other SharePoint pointers check out this blog post. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/The-Ten-Commandments-of-SharePoint-in-PowerApps/ba-p/848842

Was this reply helpful? Yes No