Column content show's as number's

[IMK]

I have an Access app in SharePoint Online that I have connected to PowerApps.

In my Access app I have 2 tables, customer and billing. My customer table contains only ID and customer name. In billing table, I connect customer to one billing row via Lookup column from customer table.

Now I am trying to create a new PowerApp using the billing table which works other way's fine but the customer name is not text. It's number. And when I try to create a new billing via PowerApp, customer column in PowerApp only accepts number's.

How could I get the app to show and accept input customer's name by text and not by number?

[Steelman70]

Apologies, forgot the [ ] please try this

First('[Access].[Asiakas]').Asiakas

[IMK]

I also tested using

First('Access.Laskut').Asiakas

and

First('Access.Laskut').ID

hoping that it would give me some result but the result was the same. Error "Invalid name".

Access.Laskut is the table that I used to create the app so I believe it should have give me some output...

[Steelman70]

You are missing the square brackets [ ] around the data source name...apologies

[IMK]

Code

First('[Access].[Asiakas]').Asiakas

didn't give nothing but

First('[Access].[Laskut]').Asiakas

gave me number.

[Steelman70]

If you have not added the Asiakas table as a source to your PowerApp then you need to do so...

[IMK]

I have addedd Asiakas table as data source but for some reason it didn't show up as a data source. I added it again and now it shows up. Now with

First('[Access].[Asiakas]').Asiakas

I get first customer name in every row. So I tested

LookUp( '[Access].[Asiakas]', '[Access].[Asiakas]'[@ID] = MyCustomerID).Asiakas

and now I got a customer name to show up. It's just that if I use MyCustomerID, I get same name in every row. Same thing if I use numbers in place of MyCustomerID. Number 1 gives the name of the first customer in Customers table for every row, number 2 gives second customer name for every row and so on..

[Steelman70 · Accepted solution]

Sure, now we need to do the next step and substitute MyCustomerID

Please try this:

LookUp( '[Access].[Asiakas]', '[Access].[Asiakas]'[@ID] = ThisItem.Asiakas).Asiakas

Or something similar

[IMK]

Using

LookUp( '[Access].[Asiakas]', '[Access].[Asiakas]'[@ID] = ThisItem.Asiakas).Asiakas

I got the customer name to show up as ecpected in BrowseScreen and DetailScreen but I dont know where to place the code in EditScreen? I dont find data text field for that...

[Steelman70]

Good, things seem to work as normal.

In the edit screen it depends on the type of control.

If it is a customer then I assume that you would like a drop-down control to choose the customer (if you have less than 10-15 customers or so) or some kind of cascading lookups or search if more than 20 or so customers. (Unfortunately there is no autocomplete control in PowerApps yet)

How many customers do you have to choose from?

What control do you have for selecting the customer?

Or is the customer pre-selected by the way you reach the edit screen?

A screenshot of your edit screen would be useful

[IMK]

Like in the Access Web App, I would like it to be a text box, to where I can start type a name and mobile app would give succestions from Customer table, when creating new row to Laskut (Bills) table.

When modifying excisting row, customer name should be prepopulated text box with same function as when creating new row.

At the moment, my EditScreen is the default EditScreen created by PowerApps.