Answered

Submit Multiple Data in PowerApps Gallery to SharePoint List

(0) Share

Report

Posted on by Bonniedog2

I have an app with a gallery linked to a list (Tracheostomy tubes). I want the user to search the gallery, add a quantity in a textinput field (txt_Number) against as many items as required, and then click a button to submit the details to another list (Tracheo tube orders) - each tube selected to go into a separate item. The 'orders' list has a column (Quantity) where the number of items should be added. Having difficulties working this out (tried using Patch but didn't work). Any help would be great! Pic below of the app:

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bonniedog2 ,

The general method of doing this looks like below:

ForAll(Gallery.AllItems As GA, Patch('Tracheo tube orders', Defaults('Tracheo tube orders'),{'Tracheo tube': GA.Title, Quantity: GA.NumberTextInputBox.Text}))

If you see any errors in your formula, please share the formula as well as the message.

Best regards,

Was this reply helpful? Yes No
Bonniedog2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the help - what does 'Tracheo tube' in 'Tracheo tube': GA.Title ... etc refer to?

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Bonniedog2 ,

Tracheo tube is the column name in Tracheo tube orders table, GA.Title means Title column value in the Gallery, that is current row item's Title. GA.NumberTextInputBox means current row's number text input box in the Gallery.

Best regards,

Was this reply helpful? Yes No
Bonniedog2 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry - here's what I've added: ForAll(BrowseGallery.AllItems As GA, Patch('Tracheo tube orders', Defaults('Tracheo tube orders'),{'Brand': GA.Title, Quantity: GA.txt_Number.Text}))
I'm not sure of what I should be adding as the bolded value. This is the error:

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bonniedog2 ,

It seems the Brand column is a LookUp or Choices column. Which one is it?

If it's Choices column:

'Brand': {Value: GA.Title}

if it's LookUp:

'Brand': LookUp(Choices(SPlist.Brand),Value = GA.Title)

Best regards,

Was this reply helpful? Yes No
Bonniedog2 on at

Like
a
(0)

Report
Copy link

Link copied!

'Choices' column, and this got it working. Saved a lot of time - thanks!!

Was this reply helpful? Yes No