You’re offline. This is a read only version of the page.
10
Dear Brainstrust,
Looking for help with a complex app with datadrawn from sharepoint list which includes some lookup columns.
The sharepoint list has the following items
From that I've created a gallery screen using some search and sort code from the brilliant @Shanescows
In order to get the sort and search features to work on the [contact name] lookup field I had to add a new column to the dataset
SortByColumns(Search(AddColumns(Owners,"Contact",'Contact Name'.Value),inpSearchText.Text,"Title","Contact"),varSortBy,If(varSortOrder,Ascending,Descending))
This all works brilliantly BUT when I select a specific item and pass the value to an input form I get an error message that;
Property expects record values. Rule produces table values which are incompatible
This didn't happen before I added the column and I was able to use the Gallery.Selected.Item as the input code on the Form.
Which is odd because I only have one value for the selected item
Any suggestions on how to populate the form would be greatly appreciated.
Thanks in advance
Karl
In the end the SOLUTION proved simple, by changing the Item property on the Form from a Filter funtion to Lookup
LookUp(Owners,SelectedShareholder=ID)
Hi @KarlNixon2 ，
Since your problem has been solved, could you change your issue's status to "Answered"?
Thanks!
Best regards,
Phoebe
Share
Report
All responses (
Answers (
