Data shows up in PowerApps form but does not in SharePoint custom form

[Berny]

Hello All,

I have just been getting started with PowerApps. I have made a couple test apps so I am getting the hang of things but I just ran into something that is getting me confused. 

My core use (right now) is to customize some SharePoint list input forms (which do look really nice in PowerApps). In my form I want to pull some data from another SharePoint list (filtered down to the current person entering creating the new item - the DataSource for this data is unique records for each UserName.) I have not been able to get the SharePoint custom form to show the data when it is filtered.

So I decided to try it in a blank PowerApp and see what happens. In this format I was able to get the data to show up as I wanted it to. 

Now I am trying to figure out what is different between these two PowerApps?

Here is the form I created in PowerApps directly

 

Here is the form that was created as a SharePoint List

 

Any thoughts would be really appreciated

[Jeff_Thorpe]

If both PowerApps forms are using the same list why are the field names different in the data source?

[Berny]

Arg this forum is anoying. it does not keep me logged in to respond to these messages and keeps logging me out.

Jeff - I changed the display values for the fields. After I posted the pictures I updated the second form to have the same display text.

[Berny]

One other thing I should mention - for the SharePoint form I also tried setting the default filter to be equal to both the user profile (O365 profile.DisplayName) in the employee detail list and also to the title (strait text) and neither of those filters showed any information either. 

[Jeff_Thorpe]

I assume the filter formula was in the Items property of the Data Table for both examples. If that is the case then a little troubleshooting is probably needed. I would start with verifying the values that are being return to be sure that they match.

Example.

set Items in DataTable1 = Employee List

This should bring back results in your data table

Then create a button and set the OnSelect to Set(SelectedTitleValue,DataTable1.Selected.Title)

Click on the Play button and then select table row that represents you and click the new button

This will store the value of the title field in the table list into a variable called SelectedTitleValue which you can use to manually compare it to User().FullName by using a label field

[v-micsh-msft]

Hi @Berny,

I just tried the scenario you mentioned in your posts.

And it works from my side.

 

Please take a try to do some customizations and see if the data could show up correctly.

Regards,

Michael

[Berny · Accepted solution]

Well I ended getting things working. Somehow I ended up seeing that there was a collection of items associated with the form. Once I set that to clear things started working. I have no idea why the collection was created nor do I know why that messed things up but at least now it is working correctly again.