Answered

Getting your data error - How to determine if it is an app issue or the per user license issue.

(0) Share

Report

Posted on by bkatz

Good Morning,

I've created a Canvas app connected using the SQL server connector. I am able to use the application as normal, view records, add, delete, etc. I shared it with the first user in my organization for them to test it. They are able to view the records list in the gallery and create new records but when they click on a record when they get to the details screen they see "getting your data" in both form boxes. I would have thought it was an app issue but I don't get this when I click on a record. How do I tell the difference between an issue within the app (not passing the data correctly) and whether it is that I have the per user app license and they don't (i'm in a large enterprise organization)?

I did a monitoring session with the individual running the application and when he gets that response I don't see anything in the monitoring session.

Could it be a variable issue? I have created a variable for passing data from the gallery.selected to the detail screen, could that be the issue? If so, why does it impact the user but not me?

On my gallery, the arrow for the record OnSelect is: Navigate(DetailRecordScreen, ScreenTransition.None, {displayItem:ThisItem})

On my DetailRecordScreen: item=displayItem

Any thoughts? Seems like I'm missing something obvious and I'm still new to powerapps so definitely possible.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bkatz

Try the following:

In the arrow just have Navigate(DetailRecordScreen, ScreenTransition.None)

In the Item property of the Form on the record screen have: Lookup(yourtable, ID=Gallery1.Selected.ID)

Replace yourtable with the name of your SQL connected table and Gallery1 with the name of the gallery on the first screen.

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bkatz

This would be an app issue rather than a licensing issue. This is because if it were a licensing issue, the user would not get as far as being able to view the list of records in the gallery. I assume that the user has a trial license?

It might be worth republishing your app just to confirm that your user is using the same version of the app that you're developing.

If @Drrickryp's suggestion doesn't work, perhaps you could clarify the items on your details form. For example, do you have any dropdown/lookups that would require additional data retrieval?

Was this reply helpful? Yes No
bkatz 36 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I updated the form to item: LookUp('[dbo].[ASMDataDetails]', ID=VisitsListGallery.Selected.ID)

and I have a red x with "invalid argument type"

Any thoughts?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What is the datasource property of your form?

Was this reply helpful? Yes No
bkatz 36 on at

Like (0)

Report
Copy link

Link copied!

Where do they confirm what kind of license they have? I agree that they certainly shouldn't be able to write to my SQL DB if they didn't have the proper license.

The details form has nothing but values from the the submitted form. It doesn't even have an edit button, just delete. I want it to purely be a view of the data submitted for the record.

Was this reply helpful? Yes No
bkatz 36 on at

Like (0)

Report
Copy link

Link copied!

datasource: '[dbo].[ASMDataDetails]'

It is saying the name isn't valid. Identifier isn't recognized for "ID" which is underlined in red. Not sure if that helps.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bkatz

I would start again and let PowerApps build your app for you from your data. It will build a three screen app with a gallery screen, a view screen and an edit screen. Something is definitely wrong with your app if the datasource is not correctly defined.

Was this reply helpful? Yes No
bkatz 36 on at

Like (0)

Report
Copy link

Link copied!

Is this just to test the connection? I have a lot of hours into the app with fields and radio buttons, pull downs, sorts/filters, etc. The idea of fully starting over isn't attractive. The most confusing part is that it ran perfectly fine for me, I can pull the items up and view details with no problem. Just doesn't work for my first user I shared it with.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@bkatz

You could remove the connection and reconnect it. Then all of your controls will be ok. as you have written them. @timl 's suggestion that you may not have published changes in your app before your user tried it may be the answer as to why it works for you but not the user. Also have the user close out and reopen the app after you have published it. Sometimes we miss the obvious.

Was this reply helpful? Yes No
bkatz 36 on at

Like (0)

Report
Copy link

Link copied!

Yeah, I tried disconnecting and reconnecting the data sources and have republished the app with a new version number to make sure the user was seeing the correct version number and he does. I tried the recreate from the SQL DB but the draft of the app would take a lot to get it to a working place. My users when adding a new "visit" get a list of visit types, depending on which they select, hides/shows fields (changes required fields), then they submit a record and should be able to view it. It is only the "viewing" that on the details screen that is an issue.

the issue with the invalid argument seems like a syntax issue, doesn't it?

Was this reply helpful? Yes No