Answered

Patch lable value if contents of a variable matches contents of column on sharepoint

(0) Share

Report

Posted on by lmahmuti

Hello,

I am trying to Patch data to sharepoint (Personal Data) only if variable (Alias) value matches contents of the sharepoint. The update should be on the same row that the match occurs. I am getting errors and wondering what I am doing wrong

If(CountRows(Filter('Personal Data',Title = Alias))>0,Patch('Personal Data',{Result:Pers_Total}))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

lmahmuti 95 on at

Like
a
(0)

Report
Copy link

Link copied!

I inserted a label and assigned variable value to it (Pers_Total_1) and changed the code as follows but it is patching on the next line not on the line that the match is occurring

If(
!IsEmpty(
Filter(
'Personal Data',
Title = Pers_Total_1.Text
)
),
Patch(
'Personal Data',
{
Title: Pers_Total_1.Text,
Result: Pers_Total.Text
}
)

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @lmahmuti ,

Your Patch() function is incorrect. The Patch() function requires 3 elements, the datasource being patched, the record being patched and the items within that record. You are missing the second element. In the example here

Patch( Customers, Lookup( Customers, Name = "Contoso" ), { Phone: “1-212-555-1234” } )

The Lookup() function is used to specify the record to be patched. Please check this resource https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch for more examples of how to add a new record to a datasource and how to modify an existing record.

Was this reply helpful? Yes No