Choice in list column changes choice column in separate list

(0) Share

Report

Posted on by RyanJ1

108

Hello,

My situation is as follows:

I have two lists: TaskList and RequirementList.

I have a choice column in my TaskList titled "Status", with 5 choices (New (default value), In Progress, Complete, Closed, Suspended).

I have a choice column in my RequirementList titled "Complete", which is a toggle with 2 choices (Not Complete (default value) and Complete).

What I am trying to accomplish is:

1. When ONE requirement from the RequirementList is toggled "Complete", change the TaskList "Status" Value from New to In Progress.

2. When ALL requirements from the RequirementList are toggled "Complete", change the TaskList "Status" Value to Complete.

Below is a screenshot of the List Galleries beside each other for a visual.

However, the data fields are actionable in associated forms:

Status:

Requirements:

I have tried many different avenues to make this work (to include asking chatGPT 😕 ) but nothing has been close. I have 0 IT background besides the effort I've put into this project so far, so any help would be GREATLY appreciated!

BR,

RyanJ1

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @RyanJ1

How is the TaskList linked with RequirementList? Are you using a lookup column?

Was this reply helpful? Yes No
RyanJ1 108 on at

Like (0)

Report
Copy link

Link copied!
@cha_cha ,
When I create an new "Task" item on the TaskList, a task number is automatically generated:
NewTaskForm.Item:
varFormData
NewTaskNum.Default:
If(TaskForm_1.Mode=FormMode.New,Concatenate(Text(ThisItem.'Start date',"mm-yy"),Last('G4 Task Tracker List').Title+1),ThisItem.Title)
This number is then "linked" to my RequirementsList "RefID" column:
RefID.Default:
If(RequirementsForm.Mode=FormMode.New,varFormData.Title,ThisItem.RefID)
RequirementForm.Item:
VarReqItem

Was this reply helpful? Yes No
RyanJ1 108 on at

Like (0)

Report
Copy link

Link copied!

@cha_cha ,
Do you have any recommendations/solutions?

Was this reply helpful? Yes No