cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Need help with transition from Browse Gallery to Detail Form

Hello,

 

I have an app with a database and several tables in Azure. 

 

The "master table" is a list of voters populated with public information.  I also have a 1-to-1 relationship with a table of "tagging" data and a 1-to-many relationship with "notes".  Basically, I want to be able to associate tags, such as "donor" or "follow-up", and text notes sorted by date.

 

I have two of these working perfectly, but cannot figure out why the 3rd is giving me so much trouble.

 

Here' s a screenshot of the Voter_BrowseScreen and Voter_BrowseGallery:PowerApps1.png

 

 

* When I click the Person icon it transitions to the Voter_DetailScreen, bringing up the data associated with the exact same record in the public voter file.  I set the Voter_DetailForm..DataSource to the correct table and the Voter_DetailForm.Item to Voter_BrowseGallery.Selected.  Works Perfectly!

 

* When I click the Tag icon it transitions to the Tags_DetailScreen, however, there is NO DATA in the screen.  I set the Tags_DetailForm.DataSource to the correct table (the fields are there in design view) and the Tags_DetailForm.Item to Voter_BrowseGallery.Selected, but it throws a WARNING in the PowerApps editor.  It says "Invalid formula.  Expected a value compatible with 'DataSource'."  It's as if I can't access the same Voter_BrowseGallery.Selected property here that I used flawlessly in the Voter_DetailScreen above.

 

What am I missing?

 

Thanks for your time.  Jason

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Need help with transition from Browse Gallery to Detail Form

Hi Jason,

 

I think you're seeing this error because the datasource for Tags_DetailForm is set to your 'Tags' table, but the item property of the form is set to a row in your 'Voter' table.

Assuming that the tables for your one-to-one setup look like this:

Voter(VoterID, Firstname, Address)
Tag(VoterID, Tag1Desc, Tag2Desc)

The formula that you would use for the item property of the Tags_DetailForm would look something like this:

Lookup('[dbo].[Tag]', Voter_BrowseGallery.Selected.VoterID = VoterID)

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Need help with transition from Browse Gallery to Detail Form

Hi Jason,

 

I think you're seeing this error because the datasource for Tags_DetailForm is set to your 'Tags' table, but the item property of the form is set to a row in your 'Voter' table.

Assuming that the tables for your one-to-one setup look like this:

Voter(VoterID, Firstname, Address)
Tag(VoterID, Tag1Desc, Tag2Desc)

The formula that you would use for the item property of the Tags_DetailForm would look something like this:

Lookup('[dbo].[Tag]', Voter_BrowseGallery.Selected.VoterID = VoterID)

View solution in original post

Highlighted
Helper I
Helper I

Re: Need help with transition from Browse Gallery to Detail Form

This makes total sense and it works perfectly.

 

Thanks for your help!

Highlighted
Super User
Super User

Re: Need help with transition from Browse Gallery to Detail Form

Glad that worked for you!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,285)