
Announcements
hello everyone
I am creating an app this will have 4 forms ideally
audits
customer complain
suggestion box
Corrective action
so far I have created the first 3 lists (audits, customer complain, suggestion box these all have the following columns
- name
-date
-unique id
- corrective action required (this is a question they pick yes or not)
i would like all the information to be copied over to the 4th list Corrective action a once the user answers picks yes on the corrective action.
How do i make it work do i create the list in lists and use look ups and then power automate based on a column answer could i use when an item is created ?
please i am really struggling and i dont seem to find any light hahahah thank you for your help and time again thanks
if all your lists have the same columns, then you just need to patch a copy into corrective action list when the OnCheck of the checkbox is done.
You'll need to replace the names of the columns and controls in the below code, but this will enable you to create new rows when the checkbox is checked.
OnCheck:
Patch('Corrective action', defaults('Corrective action'),
{
Name: NameControl.Text,
Date: DateControl.SelectedDate,
'Unique ID': UniqueIDControl.Text,
'Corrective Action required': CheckBoxName.Value
}
)