Data from Gallery is not being saved to database once I close the app.

(0) Share

Report

Posted on by vikna

175

Hi Team,

I've used the below code to show the data in each boxes. It works well until I close the app and relaunch it.

Please see Pic 2. Seems like the 2nd row onwards does not save.

Pic 1 :

Pic 2 :

I've added the below code to "On Visible" so that it will save to my database the moment it opens the page :

ForAll(Filter(GalleryLaptop.AllItems, Toggle1.Value = true), Patch(SUMMARY_LAPTOP, ThisRecord, {LUTONG:TextInput6_1.Text, 'MENARA SHELL':TextInput6_2.Text, 'PLAZA SHELL':TextInput6_3.Text, 'LABUAN SUPPLY BASE':TextInput6_4.Text, TOTAL:TextInput6_5.Text})) ;
ForAll(Filter(GalleryAccessories.AllItems, Toggle2.Value = true), Patch(SUMMARY_ACCESSORIES, ThisRecord, {LUTONG:TextInput11.Text, 'MENARA SHELL':TextInput11_1.Text, 'PLAZA SHELL':TextInput11_2.Text, 'LABUAN SUPPLY BASE':TextInput11_3.Text, TOTAL:TextInput11_4.Text}))

Please advise.

Thanks to @v-albai-msft for providing the solution for my initial issue :
https://powerusers.microsoft.com/t5/Building-Power-Apps/Show-data-from-one-Gallery-based-on-location-in-another-Gallery/m-p/909949#M288738

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vikna ,

Please provide more information.

What's Toggle1 ? I did not find it from the picture. Please provide the relevant formula and describe its usage.

What's Items formula of GalleryLaptop ?

What's Items formula of GalleryAccessories?

What's Items formula of Gallery1_1?

What's formula of LaptopModel?

What's formula of Laptops?

From the image, it seems that you are using nested galleries?

Please provide as much information as possible, such as what is each name you defined?

Best Regards,
Wearsky

Was this reply helpful? Yes No
vikna 175 on at

Like
a
(0)

Report
Copy link

Link copied!

Basically there is 4 Gallery for Laptop and another 4 for Accessories.
Total 4 locations
LAPTOP
Lutong : Gallery 1_1
Menara Shell : : Gallery 1_2
Plaza Shell : Gallery1
Labuan Supply Base : Gallery1_3

ACCESSORIES

Lutong : GalleryLUT
Menara Shell : : GalleryKL
Plaza Shell : GalleryKK
Labuan Supply Base : GalleryLSB

What's Toggle1 ? I did not find it from the picture. Please provide the relevant formula and describe its usage.
It is hidden. Purpose is to tell if there is any changes done on the box .
Formula :
ThisItem.LUTONG <> TextInput6_1.Text Or ThisItem.'MENARA SHELL' <> TextInput6_2.Text Or ThisItem.'PLAZA SHELL' <> TextInput6_3.Text Or ThisItem.'LABUAN SUPPLY BASE' <> TextInput6_4.Text Or ThisItem.TOTAL <> TextInput6_5.Text

What's Items formula of GalleryLaptop ?
TextInput6_1 : LookUp(Gallery1_1.AllItems,LaptopModel.Text = Laptops.Text).Total.Text
TextInput6_2 : LookUp(Gallery1_2.AllItems,LaptopModelKL.Text=Laptops.Text).TotalKL.Text
TextInput6_3 : LookUp(Gallery1.AllItems,LaptopModelKK.Text=Laptops.Text).TotalKK.Text
TextInput6_4 : LookUp(Gallery1_3.AllItems,LaptopModelLSb.Text=Laptops.Text).TotalLSB.Text
TextInput6_5 : TextInput6_1 + TextInput6_2 + TextInput6_3 + TextInput6_4

What's Items formula of GalleryAccessories?
TextInput11 : LookUp(GalleryLUT.AllItems,ProductsLUT.Text = Accessories.Text).QuantityLUT.Text
TextInput11_1 : LookUp(GalleryKL.AllItems,ProductsKL.Text = Accessories.Text).QuantityKL.Text
TextInput11_2 : LookUp(GalleryKK.AllItems,ProductsKK.Text = Accessories.Text).QuantityKK.Text
TextInput11_3 : LookUp(GalleryLSB.AllItems,ProductsLSB.Text = Accessories.Text).QuantityLSB.Text
TextInput11_4 : TextInput11.Text + TextInput11_1.Text + TextInput11_2.Text + TextInput11_3.Text

Toggle 2 :
ThisItem.LUTONG <> TextInput11.Text Or ThisItem.'MENARA SHELL' <> TextInput11_1.Text Or ThisItem.'PLAZA SHELL' <> TextInput11_2.Text Or ThisItem.'LABUAN SUPPLY BASE' <> TextInput11_3.Text Or ThisItem.TOTAL <> TextInput11_4.Text
What's Items formula of Gallery1_1?
no specific formula. Its connected to a data source (Excel) when I hit the update button

Update button formula : (toggle is hidden)
ForAll(Filter(Gallery1_1.AllItems, Toggle3_1.Value = true) , Patch(LUT_LAPTOP, ThisRecord, {JML:TextInput1_8.Text, CAR:TextInput1_9.Text, SECONDEE:TextInput1_10.Text , BREAKFIX:TextInput1_11.Text,VIP:TextInput1_12.Text, TOTAL:Total.Text}))

What's formula of LaptopModel?
What's formula of Laptops?
This is based on @v-albai-msft advise in my previous post :
https://powerusers.microsoft.com/t5/Building-Power-Apps/Show-data-from-one-Gallery-based-on-location-in-another-Gallery/m-p/909949#M288738

I hope this explains better. hopefully not too much useless information. I'm still new to Powerapp 🙂

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @vikna ,

Thanks for your supplement.

I have the following questions:

1\ I see that you have 3 loop patch functions, which one failed to execute? Please see the picture below

2\ Could you add a description of the problem you encountered? Did you run it for the first time without problems?

Did you open the app for the second time and it didn't work properly?

Your formula has no grammatical errors, so I want to know what you want to achieve.

3\ Thank you for the supplementary explanation of many textinput controls .But I also want to know the Items property of your gallery 'GalleryLaptop ' and 'GalleryAccessories'.

4\ What is your data source? How many data sources do you have?

From your formula, I can see that you have three loop patch formulas, so do you have 3 data sources and do you want to modify their records?

Best Regards,

Wearsky

Was this reply helpful? Yes No
vikna 175 on at

Like
a
(0)

Report
Copy link

Link copied!

1. All 3 did not fail to execute. There are no errors generated

2.
a. This is the main page which have 2 dropdown
Location :
Lutong
Menara Shell
Plaza Shell
Labuan
Summary

Items :
Laptops
Location

b. After selecting the dropdowns, I click on EDIT.

c. I have 2 more screens for each of the 4 location mentioned before each similar as below.

d. This is the summary page.
If I open the app, and then update laptop and accessories inventories from the page above, it updates the summary screen properly.

e. However, I close the app and then launch it again, it will be something similar as below.
The only this that stays are the details for HP EliteBook 830 (G5,G6,G7) AND USB Standard Keyboard ALL.

f. At the launch of SUMMARY page (On Visible) , the below formula will be applied to ensure it saves to my database.
And it saves in the Excel database.
However, upon closing my application, those details are missing

g. And all data in my other screen is retained. Only SUMMARY page is having issues.

WHAT I NEED TO ACHIEVE:
I want to ensure that the details captured in the SUMMARY pages does not go missing.

3. The Item formula for GalleryLaptop and GalleryAccessories.

4. These are my data sources using Excel file location in One Drive.

The output in Excel should be like below for each location (WORKS FINE) and one page of summary(NOT WORKING) :

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

Like
a
(1)

Report
Copy link

Link copied!

Hi @vikna ,

Sorry, your data structure and app are very complicated.

I don't have any good suggestions.

Hope someone can help you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
vikna 175 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for your advise so far.

hopefully someone would be able to advice.

Was this reply helpful? Yes No