Entity relationship

[erisa]

Hello,

Am using power apps to make an inventory application, specifically where staff can request for commodities.

How can I allow a staff member to select items from the gallery then adds the quantity and when he clicks on the make request, it takes a collection of all the items selected to the request table for further approval. 

• First I have stock table from which I created my gallery and I am using the toggle controller to select and take to another gallery as a collection from which I want to attatch a quantity for each item selected and after which this information is taken to the requests table. There is a 1 to many relationship

Any help is highly appreciated

[poweractivate · Accepted solution]

@erisa 

Try this and see if it helps

Create a collection to store selected items:

In the OnSelect property of the Toggle control, you can add an item to the collection if it's selected, and remove it if it's unselected. Here's an example:

If(
   Toggle1.Value,
   Collect(
      SelectedItems,
      {Title: ThisItem.Title, ID: ThisItem.ID, Quantity: TextInput1.Text}
   ),
   Remove(
      SelectedItems,
      LookUp(SelectedItems, ID = ThisItem.ID)
   )
)

This formula checks the state of the Toggle. If it's turned on, it adds the current item to the SelectedItems collection along with the quantity inputted in TextInput1. If the Toggle is turned off, it removes the item from the collection.

Update the quantity of selected items:

You can use a text input or a slider (depending on your preference) in your gallery to allow the user to specify the quantity of the selected item. If the user changes this value, you'll need to update the quantity in your collection. Here's an example of how you could do this with a text input (TextInput1) in the OnChange property:

If(
   Toggle1.Value,
   UpdateIf(
      SelectedItems,
      ID = ThisItem.ID,
      {Quantity: TextInput1.Text}
   )
)

This formula checks if the current item is in the SelectedItems collection (by checking if the Toggle is on), and if it is, updates the quantity.

Submit the collection to your requests table:

When the user clicks the 'make request' button, you'll want to submit the SelectedItems collection to your requests table. The exact way to do this will depend on how your requests table is set up, but here's an example if you're using a SharePoint list:

Patch(
   Requests,
   Defaults(Requests),
      ForAll(
      SelectedItems,
      {
         Title: Title,
         ID: ID,
         Quantity: Value(Quantity)
      }
   )
);

Clear(SelectedItems);

Make sure to use ForAll inside Patch as I did above, it's better that way (rather than to use ForAll outside Patch)

This formula iterates through each item in the SelectedItems collection and creates a new item in the Requests list with the same Title, ID, and Quantity. It then clears the SelectedItems collection.

Remember to adapt the formula examples above based on your app's structure and control names. Also, ensure that your data sources (like SharePoint lists, if any) are connected correctly in your Power App. This should give you a good starting point for your inventory application. 


See if it helps @erisa 

[erisa]

It has worked perfectly well, thanks guys