You’re offline. This is a read only version of the page.
17
I have data in Powerapps CDS table like my screenshot.I want to get the next item once I submit the button my current "IN progress" Item will change into "completed" . Then I have to move the status to in progress in to Next item in the table.
Please anyone having idea share it here.
Hi @gowtham1907,
Based on the issue that you mentioned, do you want to update the Status column clicking the button?
Could you please share a bit more about the scenario, what is the data type of the CompletionStatusID column?
Not sure about the data type of the CompletionStatusID column, I assume that it is a Text.
1). Add a Gallery and populate it with your Dataverse table
2). Insert a button within the Gallery and set the OnSelect as below:
Share
Report
All responses (
Answers (
Patch(
EmailLists, // This is my Dataverse table, please replace it with yours
ThisItem,
{CompletionStatusID: "Completed"}
);
Patch(
EmailLists,
LookUp(
EmailLists,
CompletionStatusID = "Pending"
),
{CompletionStatusID: "InProgress"}
)Regards,
Qi
