Unanswered

check box patch column

(0) Share

Report

Posted on by Pinoq

102

I would like to create a form with 3 check box to record if item A, item B, and item C already give to the related staff. What I want to do is that, I have a column in the sharepoint list with status,when all three checkbox is checked, patch the sharepoint list status column to complete.
If anyone of the item is missing, everytime edit or view the form, pop a error message and show what is missing. How can I set this function?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

You can try OnSelect of a Button:
If(CheckboxA.Value=true&&
CheckboxB.Value=true&&
CheckboxC.Value=true,
Patch(SPList,
Defaults(SPList),
{Status:"Complete"},Notify("Please Not all the Checkboxes are Selected))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like
a
(0)

Report
Copy link

Link copied!

Are you going to the form from a gallery? If so then on the OnSelect set a variable to the value of the field. Then on the on visible to the view with the form have a popup message based on the value of the variable. This would the onvisible property to the popup

Was this reply helpful? Yes No
Pinoq 102 on at

Like
a
(0)

Report
Copy link

Link copied!

Also,I have set the column as a checkbox in sharepoint list.But when I customize the form in power apps,I show as a drop down.could I know how can I change it to a check box?

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please Is your First request answered?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Max44 223 on at

Like
a
(0)

Report
Copy link

Link copied!

Andree alluded to this in his first statement, but if you automate one part of a dropdown you need to automate ALL of the dropdown states. The formula has to go in the place you want the results. Whenever anyone manually changes the dropdown status, your formula will be overwritten. So you will need to automate all of the other stages. I've seen this done by using checkboxes for each stage, or date input fields for the completion date of different stages.

Was this reply helpful? Yes No