Power Apps form for SharePoint list conditional check on save

(0) Share

Report

Posted on by RM-06012333-0

1. Form is submitted with drop down item "referred" selected.

2. Yes/No toggle needs to switch from no to yes if the form is submitted with the "referred" drop down selected and then be disabled permanently.

The toggle is just to show whether or not the form has ever been submitted/saved with "referred" selected and shouldn't switch the toggle value if the drop down is changed to and from "referred" multiple times.

I'm not sure the best way to achieve this so figured I'd reach out.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Kalathiya 709 on at

Like (0)

Report
Copy link

Link copied!
Hello @RM-06012333-0,

In this case need to create a flag column (boolean) in your data source (SharePoint List), let’s call it WasEverReferred. We need it toggle shows if the form was ever saved with “referred” selected. Dropdown changes during editing shouldn’t affect it, so we need a separate flag to make it one-way.

Dropdown on Change Property will be:

If( Self.Selected.Value = "referred", Set(varSetReferredFlag, true) )

Form On Success Property:

If( varSetReferredFlag && !Self.LastSubmit.WasEverReferred, Patch( DataSource, //Replace with you list name Self.LastSubmit, { WasEverReferred: true } ) ); Set(varSetReferredFlag,false); //Reset variable

Toggle - Display mode condition:

If( ThisItem.WasEverReferred = true || varSetReferredFlag = true, DisplayMode.Disabled, DisplayMode.Edit )

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No
Kalathiya 709 on at

Like (0)

Report
Copy link

Link copied!

@RM-06012333-0,

I wanted to follow up and see if this resolved the issue for you. I’m happy to help further if needed.

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping.

Was this reply helpful? Yes No