Get value from SP list that we just Inserted

(0) Share

Report

Posted on by CU22070439-0

Hello Community,

How do we get the value from SP list that we just inserted by Patch and get it for send email?

I have button Reject OnSelect

Results

Currently I'm missing Manager Rejected Date that I just inserted. in SP List, the value of Rejected date has created but I can't get it to send email.

anyone able to help?

appreciated.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

rb 835 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Good news!! Patch actually returns exactly what you are looking for, you just need to capture it in a variable using Set() or UpdateContext(). Eg:
UpdateContext({SubmittedRecord: Patch('ASCIS PR Tracking', {ID: 1}, {Comments: "Updated record!!"})})
Then you can reference SubmittedRecord like any other.

https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-patch
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @metsshan

Great, Let me try it. Once there is issue I'll post update in here.

Thanks
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @metsshan

Unfortunately I still can't get the return value when received email. here look like after implement update context().
I still missing 'Manager Approved Date' and Comments value but Patch has successfully updated in SP.
Rejected Date - Comments Value in SP
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Am4ree,

Have you solved your problem?

Do you want to get the last updated record after you save it?

Actually, I think you could reference to the Modified column in your List to capture the latest record.

Office365Outlook.SendEmailV2( "QiQiao@xxxx.onmicrosoft.com", "HolaWorld", "Date" & First( Sort( BU,//This is my data source Modified, Descending ) ).Modified )
CU22070439-0 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft ,

Theoretically Yes, I just want to get return value that I have patch function on Rejected Button.
When Rejected Button Pressed - it will patch state from submitted to Rejected and insert new value on 'Manager Rejected Date' (Date) and 'Comments' (Text Input) Column in SP. and Send email to recipient to including new value that I had inserted before.

but I still can't get new value when received email