Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Learn Power Apps

2.5k members • Free

2 contributions to Learn Power Apps
No accesss to data in user mode
Hi guys, Another issue here. I have an app that's quite simple. The excel file it uses as a database is on the company sharepoint. Thanks to your help, it now works fine in edit mode (open it in edit and hit the "play' button). All the data is shown, I can search and all that. In user mode, though, Nothing. I get a blank app with no data. Can't do anything. I read about mentioning the form used in the "on display" input but that just made it worse. Any idea?
0 likes • Jul 17
I tested it again early this morning. I was the only one logged in, the file was not in use and I am owner for both the app and the excel file. I really hoped it could be such a problem but no. I totally agree with you, Dustin, Sharepoint lists are way better but its company policy to use only excel files. Makes no sense to me but it's blocked and I'm not administrator so nothing I can do.
1 like • Jul 17
Right, I have to confess how stupid I am. I hadn't published the app so it could only be used in edit mode. I just published it, tested it on multiple machines and it works. Sorry for wasting your time but thanks.
Search on multiple columns of an excel file.
Hi guys. I'm struggling with a search input right now. It's supposed to search on four different columns from an excel file (no choice) named "Title" (text) "CODE" (text) "Commission paritaire" (3 digit number or blank) and "Permanent" (Name and surname). On most of the versions of the formulas I have tried, Title and code work fine, Commission paritaire returns either nonsense or nothing and Permanent does not return anything at all. Here's an example of one of my last tries: Filter( 'BASE DE DONNEES PRIMES SYNDICALESs'; IsBlank(SearchBox.Text) || ( Search(Title; SearchBox.Text) || Search(CODE; SearchBox.Text) || Search(Permanent; SearchBox.Text) || Search(Text(Commission_paritaire; "[$-fr-FR]0"); SearchBox.Text) ) ) Can anybody see something wrong with that?
1 like • Jul 16
Thanks Dustin. That helped a lot. After a few adjustments, the search works just fine.
1-2 of 2
François Debois
1
1point to level up
@francois-debois-9201
I'm a 41 years old Business analyst from Belgium

Active 15d ago
Joined Jul 11, 2025
Powered by