Answered

Adding date submitted onto sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

In my expense app I currently have a button that when pressed, updated my 'approval' from unsubmitted to pending. This works, however I'd also like to add the time of when this button is pressed to a column that ive created called 'date submitted' (which is in sharepoint). how do i change my code to reflect this?

Here is my code:

UpdateIf(
LineItems,

Approval.Value = "Unsubmitted",
{
Approval: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value: "Pending"
}
}
);

Navigate(SubmittedExpensesScreen)

Thanks in advance and let me know if you have any questions!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try this

UpdateIf( LineItems, Approval.Value = "Unsubmitted", { Approval: {Value: "Pending"}, 'Date Submitted': Now() } ); Navigate(SubmittedExpensesScreen)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz ,

Perfect, works great!

Was this reply helpful? Yes No