I am using an Excel file on OneDrive. It has two seperate tables, one for people (first name, their photo, email, etc) and the other table contains appointments for these people.
There's a field called "ID" which is unique to the person in both tables.
Under a screen, I can display the value of the "ID" field, but not their first name.
I wanted to know how to do this.
In the comments of this tutorial there is some information
When you wish to display the First Name of the particular ID, you have to use
Please provide more info in order to clarify in more details.
Have a nice day.
What would the formula be?
I am just realizing that I dont want a text box, but a drop down that is connected to a different table and calls the ID of the patient I want. But instead of showing the ID, I want it to display the first name, middle name and last name (all seperate fields) of the person that has the appointment.
If you wish to use DropDown, then please always remember to use DISTINCT (DS< FieldName).
Distinct(Datasource, middlename), etc.
Hope this helps.
Have a nice day and g9
How to display the name in the dropdown field, name comes from an excel table, and this dropdown on a card inside Form.
But when submitting, I write in the table the unique_id value of the person, not the person's name.
I have noticed that dropdown can only show a value. This is true?
Filter returns a table? And so Distinct selects only one field. that's how it works?
In order to accomplish this, we need to make a new collection based off your existing data. You can attach the following logic to the "OnVisible" property of the screen in which you want to use it:
ClearCollect(FullNames, DropColumns(AddColumns(People, "FullName", Concatenate(FirstName, " ", MiddleName, " ", LastName)),"FirstName", "LastName", "MiddleName", "email"))
Even though we're calling "DropColumns()" and "AddColumns()", the data source will not be modified. These functions return new tables.
To summarize, this command:
At this point, we can create a drop down, let's call it "PatientSelect", and set its "Items" property to our newly created collection "FullNames". You should set its display value to "FullName".
We can then reference appointments for this selected patient by using something like the following:
This is a simple filter matching the PatientID of any given appoint with the ID corresponding to the displayed "FullName" of the patient selected in the drop down. Note that the ID here will be the same as it was in the original "People" table, so it will match to your "Appointments" table.
Let me know if you have any other questions,
I'm trying to understand how to do with unique_id (primary key), reference data from another table to show in a gallery / form.
Also, how to make the field in the field show the name of the area of the house, and chosen the location of the house show the items related to this location. But when writing the data to the worksheet, write the unique_id (not the name of the house area)
It is possible for you or someone to make an application / tutorial and make it available.
In this link has the model spreadsheet I'm trying to learn how to deal with id and references and other columns.
Because I'm thinking that this reference would only be possible using the CDS
Or via CDS with the relationship tab would be the correct one to do this relationship between tables?
Thank you for listening.
I've replied to your original thread with an answer. If you've got any questions about it, please respond there and I'll try to answer them.
I am having this same issue. In the below example I have two tables, Clients and Hospital. I created a relationship between them. If I set the Value 1 to HospitalID, the HospitalName field is populated with the values but only in ID format. When I set it to HospitalName (like in the below image) I get nothing back. How do I get it to show the name and not the ID in the Hospital Name dropdown?
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand