cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Caroline_G
Frequent Visitor

Display records in a display form

Hello,

 

I have created an app starting from a blank canvas, with a SharePoint List (with contact info) as datasource. 

The idea is very simple: search for someone using dropdown controls to filter and then get all info about one particular person. 

 

The first step (search for someone) is working well. Here is a screenshot of this first screen with the formula i used (and adapted to each dropdown of course). Results are displayed into a control gallery called 'list-result'.powerapp-1.png

'

Then, when people click on the "NextArrow", i want them to be able to get all info about the contact on a second screen. So, i added a FormWiever, select the same datasource as for my first screen ('champions-test') and in the property "item" i put: 'list-result'.selected.... and it doesn't work! Everytime i found a topic about that, this is the answer. I don't know why it is not working for me. 

 

When i click on the NextArrow, i move to the second screen and there is this message "no item to display" (sorry, french traduction). And in the "back office" i got this error message: Invalid FormulaExpected a value compatible with 'DataSource'. I tried to reduce the number of records in my list (now there are less than 500). I tried to change ' ' for " ". Nothing seems to work... if anyone has an idea that would be great ! 🙂 

 

For info, i tried to use the button "PowerApps" directly from SharePoint. If i click on the nextarrow on my list, all info are displayed correctly on a second screen. I checked their "code" and this is exactly what i try to do. Only the success is not the same 😉

 

Thanks a lot for your help!

 

Caroline

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
TimRohr
Solution Sage
Solution Sage

Couple of points to clarify...

 

Single quotes are used for names:

'Some Datasource'.'That Field'

 

Dashes are problematic, as they are treated as minus signs by the compiler if they are not properly escaped. You might want to rename "list-selected" to "list_selected".

 

Then, try a First(Filter()) construction for the Item property of your detail form, filtering to the Selected item from your gallery.

 

If that doesn't work, just throw a label on your detail form and see if you can get it to return a particular piece of the Selected item from the Gallery.

 

And if none of that works, post back the specific info you are using... Gallery name and Item formula, etc.

View solution in original post

3 REPLIES 3
TimRohr
Solution Sage
Solution Sage

Couple of points to clarify...

 

Single quotes are used for names:

'Some Datasource'.'That Field'

 

Dashes are problematic, as they are treated as minus signs by the compiler if they are not properly escaped. You might want to rename "list-selected" to "list_selected".

 

Then, try a First(Filter()) construction for the Item property of your detail form, filtering to the Selected item from your gallery.

 

If that doesn't work, just throw a label on your detail form and see if you can get it to return a particular piece of the Selected item from the Gallery.

 

And if none of that works, post back the specific info you are using... Gallery name and Item formula, etc.

View solution in original post

Thank you for your answer! I'll try that and let you know !

Thanks again @TimRohr ! It works!

I added this formula to the Item property of my formviewer: First(Filter(championstest;Nom=list_result.Selected.Result))

I also renamed the gallery and my source to get ride of dashes.

Thanks for your help!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (40,208)