Answered

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

(0) Share

Report

Posted on by 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

SharePoint Form.PNG

Any thoughts would be really appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Berny 93 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Berny 93 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Berny 93 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No