Change all gallery records when pressing send option

(0) Share

Report

Posted on by joosttricht

Hi,

I want to create the following:

I have an gallery where data from an onedrive Excel file is pulled. I have managed to create an textinput and a button to change one cell of information. I want to create a button where I can change textinput within the gallery. But I am unable to do this.

The onselect of the button called "Send" has the following code in the onselect: Patch(Tabel13;ThisItem;{'Geboekte voorraad (300100)':Value(TextInput1_3.Text)})

Could you help me with it?

Joost

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @joosttricht,

Do I understand it correctly that the individual send buttons work, but you would like to send all information at once via the arrow icon instead of individually via the send button?

You can leverage the same code that is already working from your send buttons, and slightly adjust it to loop through the gallery items:

ForAll( //Loop through gallery items (change to correct gallery name) GalleryName.AllItems As Main; //Patch the geboekte voorraad value Patch( Tabel13; Main; {'Geboekte voorraad (300100)':Value(Main.TextInput1_3.Text)} ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
joosttricht 9 on at

Like
a
(0)

Report
Copy link

Link copied!

It has solved the question! Am I also able to filter out the values that are not changed in the textinput?

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@joosttricht with not changed, do you mean empty Text Input values? In that case, you could filter out those rows:

ForAll( //Loop through gallery items (change to correct gallery name) Filter( GalleryName.AllItems, //Change TextInput to the correct name !IsBlank(TextInput.Text) ) As Main; //Patch the geboekte voorraad value Patch( Tabel13; Main; {'Geboekte voorraad (300100)':Value(Main.TextInput1_3.Text)} ) )

I hope this helps!

Was this reply helpful? Yes No