Unanswered

App works in preview in studio but not online

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm quite new to PowerApps.

I have a simple form, with one connection to an xls stored in onedrive. This is a sort of checklist of stuff to do that should keep track of usernames (email) who update each task and the date in which they do. It'll eventually feature a counter or something like it.

The xls has the following fields

Area | Process | Username | Date

I've been using the following in a button to create new records in this xls:

Patch(Table1;Defaults(Table1);{Area:"Area1"; Process: "Process1"; Username: User().Email;Date: Now()})

When I run the app from the PowerApps Preview (locally) it works fine. When I publish it or try it online it does not.

E: When ran online/published it only writes to the first Field, the value "Area1". Everything else is ignored.

I have a feeling it has to do with locales but at this point I can't be certain.

I tried replacing the ; for , and it tells me it got the wrong token, so right now I'm in a bit of a bind.

Does anyone have any experience with this?

Thank you.

(Sorry for my english as it is not my native language).

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

In the meantime I've found that it works fine in Edge. Doesn't work well in Chrome.

This is problematic as not everyone on my company has W10 yet. We're still rolling out the implementation.

Anyway I could get it to work in Chrome? I'm a bit scared of IE to be honest.

Was this reply helpful? Yes No
hpkeong 2,944 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Patch shall be in such as way:
Patch(DS, Defaults(DS), {....})
e,g,:
Patch(Table1, Defaults(Table1), {Area: TextInput1.Text, Process: TextInput2.Text, UserName:User().Email,..})

For Web Apps, once you have published the apps, it can be opened via any browser.
Please try on home.dynamics.com

Hope this helps.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello HpKeong,

I've tried with commas and it does not work. Commas are not separators in my specific locale.
I added a picture of this happening.

So, I am forced since my locale works that way, to use semicolons. It is the same in VBA and even in Excel where we use semicolons instead of commas.

The only browser where I have an error updating the data source is Chrome, however. Edge and IE seem to handle the locale just fine.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

I think this is the issue with the language used under Chorme Browser.

By default, Microsoft Edge and internet Explorer 11 would use the Language preference configured under System Language control Panel, which is your Locale language, but chrome handles language in a different way.

Please follow the article below to configure the language in Chrome to match your local language, then check to see if it would work:

Change Chrome Languages & translate webpages

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Michael,

Eventually I figured it out and managed to enforce Locales.

It's my first time dealing with WebApps so I'm not quite used to these connundrums hah.

Thanks for your time and help.

Was this reply helpful? Yes No