Unanswered

Establishing Conditions for Data Entry

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to setup an app so that when a Radial box is checked and the data is submitted on the edit screen, the new information will be placed on a completed screen, and removed from the active screen.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Could you please be a little clearer about what you are trying to achieve? Is it to confirm data submission?
When you say placed on a completed screen, you want this screen to remain invisible? (You say removed from the active screen, meaning that the active screen will remain with no data and active?)

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

Like (0)

Report
Copy link

Link copied!

Here's a better breakdown: Data from received items is placed on a spreadsheet, or entered in the app edit screen, and is on a screen called active orders; When the product is moved to its intended destination, I have included a checkbox on the edit screen to indicate the status of the product as being delivered and utalized the following code for when checked on - Collect(AxTable1_2,AxTable1);RemoveIf(AxTable1,Status="Delivered"); As a result of this I hope for the product to be hidden on the active orders and be seen on the resolved orders screen. As of right now I can get the data to be removed from the active screen but not transfered to the resolved orders screen.

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous, thanks this is much clearer. It is now clear what you are trying to achieve, and how you are trying to achieve it.

I would start by suggesting an alternative approach, that is to filter AxTable1 when displayed in the active orders screen. This way you avoid all the complication of moving orders from one table to another. Basically as the source for your active screen use:
Filter(AxTable1, Status <> "Delivered")
Could this work?

If you still want to move orders from one table to another, then the Collect part of your code should probably be changed to:
Patch(AxTable1_2, Defaults(AxTable1_2), ItemToBeMoved)
This is assuming AxTable1_2 is a data source and not a collection. ItemToBeMoved needs to be substituted with whatever identifies the current item. If the checkbox is in a gallery then this will simply be ThisItem or something like that.

However I would still strongly recommend not moving items from one table to another, and implement the business process by keeping items in a single table but changing their status.

Hope this helps.

Was this reply helpful? Yes No