Answered

patch data from PowerApps to SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am editing SharePoint Customize form in PowerApps. In my SharePoint list, I have one combo box column named status. In my customized form, I had added one button to submit form and create a new row in SharePoint list.

I was required to update the status column (combo box) in the new row as "Submitted" after click on the submit button. However, my power fx query is not working at all. Anyone can help on it? Thank you

My power fx for the submit button:

Set(varStatus,LookUp(Choices([@'Create New Request'].Request_x0020_Status),Value="Submitted"));

SubmitForm(SharePointForm1);
If(SubmitForm(SharePointForm1),Notify("Your request has been submitted for review!",NotificationType.Success));
IfError(SubmitForm(SharePointForm1),Notify("Your request has been failed to submit!",NotificationType.Error));
Set(varStatus,Blank());

This is my column in SharePoint List

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
You can add the Status DataCard in your form and if you want to hide it, you can set the visible property to false.
In default property of your DataCardValueStatus you can write - If(FormName.Mode=FormMode.New, {Value: "Submitted"}, Parent.Default)

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

Like (0)

Report
Copy link

Link copied!

Hi, my form has "submit" and "save as draft" button. if "save as draft" button get clicked, the status column should have the value of "Save as draft". So, if I put in default property in datacard, no matter which button i clicked, it will always updated as submitted in my list. right? However, I already hide the status data card in my form

Was this reply helpful? Yes No
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes it does not matter if the card is hidden.

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hiding data card will not have any impact. You can revise the formula on DefaultSelectedItems property of your Status data card
If(Form9.Mode=FormMode.New, If(varButton="draft",{Value: "Save as draft"}, {Value: "Submitted"}),Parent.Default)
On Save as draft button, use a variable and set it's value to = Set(varButton,"draft")
On Submit button set the variable value to Set(varButton,"main")
I think this should work

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

Like (0)

Report
Copy link

Link copied!

Hi,
It is working now. Thank you @NandiniBhagya20

Was this reply helpful? Yes No