Answered

Use Power App Button to update specific SharePoint Online list column

(1) Share

Report

Posted on by josjohns Microsoft Employee

I created a SPO List to use as a data source for a Time Clock power app - data source is called "Time Entry". My unique identifier is the Title column where I combined current user and now() data. I also have a Shift Start column, Break Start, Break End and Shift End. The "Start Shift" button is working perfectly to create the new row. However, I've tried using multiple combinations of patch and lookup without successfully updating the break start, break end and shift end columns of the existing row. I am attempting to do this via button push in the app. Here are some examples of things I've tried so far. Hoping someone might be able to help!

Patch('Time Entry', default('Time Entry'), LookUp('Time Entry',Title = DataCardValue10.Text), {Now()})

LookUp('Time Entry',Title = DataCardValue10.Text); Patch('Time Entry', Defaults('Time Entry'),{'Break Start': Now()})LookUp('Time Entry',"Title" = DataCardValue11.Text,{'Break Start':Now()})

Patch('Time Entry', LookUp('Time Entry',"Title" = DataCardValue9.Text), {'Break Start':Now()})

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@josjohns

The only real valid formula you have there is:

Patch('Time Entry', LookUp('Time Entry',"Title" = DataCardValue9.Text), {'Break Start':Now()})

Except, it should be:

Patch('Time Entry', LookUp('Time Entry', Title = DataCardValue9.Text), {'Break Start':Now()})

So, with that one, what issue are you having?

Was this reply helpful? Yes No
josjohns Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@RandyHayes , you are awesome! Guess I was close, but not quite there. Looks like I need to better understand the difference between "Title" and Title. Your suggestion works perfectly, thank you!! Much appreciated!!!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@josjohns

No problem!

Yes, if you put double quotes around anything in PowerApps formulas, it will be seen as just Text.

If you put single quotes around anything, it will treat it as a reference to something - like a column or a control.

However, you would only need single quotes around anything that has special characters in it (like the space), so your data source, Time Entry has a space, so you would need to reference that as 'Time Entry', but for the columns in the datasource...just reference by their name (unless they have a space - and then single quote them).

Was this reply helpful? Yes No