Unanswered

SharePoint List ID Value Name

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

In a SharePoint list, there are several fields that are available automatically before you start creating your own columns, one of these is the ID field which has a unique value every time a new entry is entered. I'm trying to patch some updates to my sharepoint list which is located via the ID column so i'm entering the below code (i've shortened the actual code for ease) but it's telling me that "The type of this argument "ID" does not match the expected type 'Number' . Found type "Text". Can you advise what this should be changed to please so that I can update the sharepoint items and not create new entries?

Patch(QualityPortal, Defaults(QualityPortal), 
{
ID: 'ID_DataCard'.Text,
Title: 'ValueDateTimeNow-1'.Text
});

Many thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Your formula indicates that you are Patching into the ID column which is already autonumber as you have indicated. If that is so, then remove the ID part from the code as it will automatically be generated,

If your ID is your own created field and not autonumber, try:

Try converting the textbox to number:

Patch(QualityPortal, Defaults(QualityPortal),
{ID: Value(YourTextboxName.Text),
Title: 'ValueDateTimeNow-1'.Text
});

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
WarrenBelz 155,283 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Dave-ITMan ,

To update exiting records

Patch( QualityPortal, {ID: Value('ID_DataCard'.Text)}, {Title: 'ValueDateTimeNow-1'.Text} );

Was this reply helpful? Yes No