Hey All,
Trying to see if my app can get a little bit clever but not sure how to go about it.
I have 1 SP list that holds most of my data. Then I want to have another list that has additional data that corresponds to original item.
As an example SP List A holds the tickets coming into our and List B holds the additional details and depending on what ticket is selected from the dashboard the system goes and checks for the 'Title' and loads any data from SP list B if the 'Title' matches.
So in the below. I have TEST123456 in SP List A and SP List B. I've pulled in the value of Title card from the 'Main' tab to 'Permit Conditions' tab with DataCardValue1_2.Text but its not returning the cost value which I've manually put into SP list B.
I'm wondering if this because of the item ID is different between the 2 because of the 2 list issue.
I guess the main question, is there a way to search 2 different lists if the 'Title' is matching.
Thanks
L
Solved! Go to Solution.
Rightly or Wrongly I've managed to get this to work. I ended up using the lookup function, Although feel like I shouldn't need to but it works)
So on the individual data cards I've inputted this function in the Text property.
LookUp('Permit Conditions', DataCardValue1_1.Text = DataCardValue1_1.Text, SubmittedbyName)
This cross checks the title and see if it has any matching titles in 'Permit Conditions' list then retrieves the record from the column. I may walk into issues with this later but for now I'm happy.
L
Everything is referential in PowerApps, so the tabs will not produce a problem for you.
However, on your second tab, is this going into a form or are these manually entered controls you are showing? If it is a form, what is the Item property of that form? If it is separate controls, then what is the formula and property that you are using to try and fill in the cost value from the other list?
Firstly, thanks for taking a look @RandyHayes.
So the 2nd tab is a form. Currently in the form I have nothing for item property.
I've tried to add the same property as the 'Main' form but that's throwing me an error due to data source.
Sorry if this is bit obvious. I'm new to all this.
Thanks L
So I just wanted to add bit more information here as i've been messing about.
On my main dashboard i've added the following to my OnSelect property
Set(varFormData,Defaults('Permit Conditions')); EditForm(Form2_1);Navigate('Form Screen',ScreenTransition.Cover)
Then in my Item property on the 'Permit Conditions' form I added varFormData.
now I see the form item in preview but it doesn't seem to be showing the data that I've entered into Cost in my SP list.
Rightly or Wrongly I've managed to get this to work. I ended up using the lookup function, Although feel like I shouldn't need to but it works)
So on the individual data cards I've inputted this function in the Text property.
LookUp('Permit Conditions', DataCardValue1_1.Text = DataCardValue1_1.Text, SubmittedbyName)
This cross checks the title and see if it has any matching titles in 'Permit Conditions' list then retrieves the record from the column. I may walk into issues with this later but for now I'm happy.
L
User | Count |
---|---|
260 | |
110 | |
97 | |
56 | |
40 |