Unanswered

Relocate amount

(0) Share

Report

Posted on by Alokin

I need help with a formula for a button that will relocate the amount from one column to another.

The example is shown in the screenshot. I need when I select a budget from dropdown menus and enter the amount that value to be removed from budget1 and added to budget2 by a simple click on a button below.

The database is stored in an excel file on one drive.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alokin ,

How are you storing it now ? If using a Patch, you just need to send the amount to the second field and Blank() to the first.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Alokin 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I am using if blank and Patch to add amount to the budgets but cant find a way to relocate amount between budgets.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Alokin ,

Sorry a bit lost here - from the limited information you have posted collectively in your two posts, why does "relocate" not simply mean adding it to List 2 and deleting it from list 1. Please share the code (in Text) you are currently using, where you are using it and what it is not doing that you require.
Alokin 6 on at

Like
a
(0)

Report
Copy link

Link copied!

I am using data cards for adding budgets and a code for adding expenses.
I dont have a code for relocating i dont know how to start with this.
Alokin 6 on at

Like
a
(0)

Report
Copy link

Link copied!

The problem is not just to delete it from the first budget, i need for example if budget1 have $1000 and budget2 have $2000 if i enter an amount for example i need $500 to be moved from budget1 to budget2 after pressing relocate button the budget1 to be $500 and budget2 to be $2500.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alokin ,

Can you please post all of that as Text. Also use Format Text and put it in a Text box (the </> icon above)
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Alokin ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps