cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Solution Sage
Solution Sage

Re: Display records in a display form

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
Solution Sage
Solution Sage

Re: Display records in a display form

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

Highlighted
Frequent Visitor

Re: Display records in a display form

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

Highlighted
Frequent Visitor

Re: Display records in a display form

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,604)