Problems with share point lists that from begin was empty

[Omer_K]

Hello friends,
I have a connection problem in the app I created,
The app is made up of 3 screens, at the same time I export from 3 Excel tables to 3 Share Point lists , one (the main table) with data and 2 blank tables.
The first screen in the application pulls the data from the main table perfectly and after entering the data - there is a button that enters all the data to Table 2 (which was empty and then has the data I entered on the first screen)
The problem is, on the second screen I try to pull data from the second table and I do not succeed ..
I connect all the 3 lists but i can't pull from 2 lists any new data..
Any ideas?
Hope I was clear..

[StalinPonnusamy]

Hi @Omer_K 

Few questions or clarifications

• Once you Save the data from screen 1. Does it correctly save to SP list 2?
• I assume you use a Patch command to store to SP List 2 since data was connected to SP list 1 which submitform saves only to SP list 1.
• Did you add the other 2 SP lists as Data Source to the PowerApps?
• In a fresh (New) screen
  • Insert a gallery
  • Set the Items property to SP List 2 (No filter)
  • Is any data shown?

Thanks,
Stalin - Learn To Illuminate

[Omer_K]

Hey,
It does save me well in SP2
And yes, I use Patch function,
And now when I tried on a new screen to pull data without the Filter function it does work ..
Probably a problem here: Filter function,
How can I use the Filter function in spite of everything?

[Omer_K]

Well it seems that the problem is elsewhere ..
Dates !!
The date format in DatePicker in the app is:
dd / mm / yyyy while in SP2 the date is displayed as mm / dd / yyyy
this is the reason?
If so, how can I arrange that in SP2 the dates are displayed as dd / mm / yyyy?

[StalinPonnusamy]

Please change the region to change the format.

1. Go to the root of your site collection
2. Gear Icon > Site Settings
3. Click on Regional Settings under Site Administration
4. Under Region, click on Locale drop-down

[Omer_K]

Hey @StalinPonnusamy

I changed the dates and still it fails to pull the data from SP2 when I use the FILTER function ..

Any Ideas?

[StalinPonnusamy]

Hi @Omer_K 

Please share the filter function with me. I will analyze it

Thanks,
Stalin - Learn To Illuminate

[Omer_K]

Appreciate it - thank you very much 🙂

My Gallery:

Filter('SP2',
Date:DatePicker.SelectedDate And
Unit=Unit_1.Selected.Result
And Manger =  ManegerName.Selected.Result).Title

[Omer_K]

Now I notice that there are two blue lines below the equal sign in the FILTER function compared to the DatePicker to the date column in SP2..

[StalinPonnusamy]

Hi @Omer_K 

Filter('SP2',
Date = DatePicker.SelectedDate,
Unit=Unit_1.Selected.Result,
Manager =  ManegerName.Selected.Result)

Thanks,
Stalin - Learn To Illuminate