Assistance with setting a lookup list item value

(0) Share

Report

Posted on by LTEVA

Hi community,

Please assist on the below if possible:

I give current status in some detail so to have a better overview of what I try to achieve.

What I have :

A SharePoint list where my Contract Management data resides (Done)
A Contract Type dropdown which include the Contract Termination value (done)
A Related Contract (dropdown):where I choose from existing contracts by “Title” (done)
A Contract Status dropdown (Active,Expired, Terminated)
An Approval status (dropdown): (Pending-Approved)

The request is like that:

If “Approval Status”= Approved && “Contract Type” = “Contract Termination” then the “Related Contract Title” (lookup SP item Title??) must get Contract Status = “Terminated”.

I cannot come up with a correct formula to achieve this.

Can you help?

Thanks all

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LTEVA ,

Would you like to make Contract Status dropdown auto select "Terminated" when Approval Status is Approved and Contract Type is Contract Termination?

If so, please try:
Set the DefaultSelectedItems property of Contract Status dropdown to:
If( ApprovalStatusDataCardValue.Selected.Value="Approved" && ContractTypeDataCardVaule.Selected.Value="Contract Termination", Filter( Choices( [@List].ContractStatus ), Value = "Terminated" ) )

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
LTEVA 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

thanks for the assistance in this.

There is also one filed in my form (Related Contract) that correlates to an existing item(contract) in my SP list.
So this Contract Termination (if approved) will "Terminate" an existing active Contract

What i try to do is to patch/update the Contract Status value of the Related Contract when(if) the (IF) you suggested is true
Thanks again!!

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LTEVA ，

My formula just make the Contract Status dropdown auto-populate with the "Terminated" selection when meet the situation. I did not put Related Contract dropdown in the formula since I don't think the related contract would be a condition of the contract status, you could apply Terminate status on any contract if you like, right?

If the post have solved your question, please consider accept it as a solution to help the other members find it.
If you have any further questions, please let us know.

Best regards,
Community Support Team _ Jeffer Ni

Was this reply helpful? Yes No