Answered

If statement inside lookup statement

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to add an if statement inside lookup. I want it so that "onSelect" if approved equals no change to yes; and if approved equals yes change to no.

Patch(Expense, (LookUp(Expense, Approved="No")), ({Approved:"Yes"}));

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous

Can you please share more details about the configuration of the app? I want to understand the controls used.

If you are looking to update all records where the value is Approved, then you need to use the UpdateIf function:

UpdateIf(Expense, Approved="No", {Approved:"Yes"});

UpdateIf(Expense, Approved="Yes", {Approved:"No"});

If you are just looking for one item, then use the below expressions:

Patch(Expense, LookUp(Expense, ColumnToMatch="ValuetoMatch"), {Approved: If(LookUp(Expense, ColumnToMatch="ValuetoMatch").Approved = "Yes","No","Yes")})

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered

questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (1)

Report
Copy link

Link copied!

What datasource are you using?

If the Approved Column is a simple text column;

UpdateIf(Expense,
    Approved=”Yes”,{Approved: “No”},
   Approved =”No”, { Approved: “Yes”})

However if its a YesNo Column:

UpdateIf(Expense,

    Approved =true, { Approved: 0},

   Approved =false,{Approved: 1})

------------

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
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi
Thanks for replying. The app is an expense app when you click on the "Approved" or "Not approved" button for an expense it will change to the opposite e.g. you click on "Approved" it will change to "Not approved".

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I dont want all approved expenses to change from "Yes" to "No". Just the one selected I tried using This.Approved = "Yes" but it does not work

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

In that case, you can set the expression to:

UpdateIf(Expense, ID = GalleryName.Selected.ID, {Approved: If(Gallery.Selected.Approved = "Yes","No","Yes")})

OR

UpdateIf(Expense, ID = ThisItem.ID, {Approved: If(ThisItem.Approved = "Yes","No","Yes")})

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

At the moment in my excel file I do not have column called "ID" could I use "PowerAppsId" column? or would I have to create another column called "ID"

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

All tables in a database should have a Unique ID column that is never changed once it is assigned and is not reused. It can be a whole number (preferred) or a string and it is called the Primary Key of the table. The PowerAppsID column is for internal use only and can is not exposed within PowerApps so the answer to your question would be no. For more information about database keys and why we use them see my blog post here: https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640

Was this reply helpful? Yes No