cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
afernando

support for access web apps lookup fields

Submitted by Kudo Kingpin on ‎08-23-2016 01:19 AM

It would be great if you can add support for lookup fields in access web apps. At the moment it's not possible to save data into a lookup field. 

Status: Under Review

Adding @GregLi to validate status.

See more ideas labeled with:
8 Comments (8 New)
Comments
Steelman70
Power Participant
Power Participant
‎08-23-2016 04:19 AM

Hi afernando, it is possible to save data to a lookup field, you just need to save the lookup ID as a number.  Or is that not the issue?

What is not supported is to be able to display data other than the ID of a lookup field without making reference to the lookup table.

afernando
Kudo Kingpin
Kudo Kingpin
‎08-23-2016 09:59 PM

Hi Steelman70,

 

Thanks for your comment. I just tried saving the lookup ID as a number in Web studio but couldn't go much further as it keeps acting weird. My Windows app doesn't work as I recently updated to the latest Windows 10 build. So I'll try again when I get the Powerapps studio working and let you know if had any luck.
And I know you're pretty good at Access web apps and I'd like to know if you're  happy to help with an issue that I'm stuggling with for a while. Thanks!

Anton

 

Steelman70
Power Participant
Power Participant
‎08-23-2016 11:44 PM

I am happy to help, you can send me a direct message if it is only about Access Web Apps or open up a new topic on the forum if it is about AWA and PowerApps..

In regards to Studio, it was acting weird recently for me as well, so now I only use the web designer and it seems to work very well with Chrome.

radtadBrad
Helper I
Helper I
‎12-01-2016 05:16 AM

I'm curious if you ever found a solution?  I'm having the same issues.  I want to use Access Web Apps to input and view data, but I also want to be able to view and edit the same data from PowerApps.  Connecting to the Access SQL server works fine, however the lookup values in the WebApp only show up as numbers in PowerApps.  I'm new to both, so maybe there is a simple fix that I don't know about.  Any feedback would be greatly appreciated. Thanks!  

Meneghino
Community Champion
Community Champion
‎12-01-2016 05:19 AM

Hi there is a simple fix, you use the LookUp function but there are ways to make it efficient.

Please start a thread in PowerApps forum and I or someone else will help.

radtadBrad
Helper I
Helper I
‎12-01-2016 05:25 AM

That's great!  I just posted a message in the forum, hopefully someone will help.  Thanks!

 

Audrie-MSFT
Power Automate
Power Automate
‎03-21-2017 12:33 AM
Status changed to: Under Review

Adding @GregLi to validate status.

DKShah
New Member
‎04-07-2017 11:00 AM

on 30 th ms declared that AWA will be retireing from o365. RIP the only relational database on O365.