cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

FormViewer

Necesito que mi FormeViewer me muestre elementos relacionados con una fecha.Captura.PNG

2.PNG

 

 

por ejemplo, puse 10/08/2019 en mi tarjeta de datos, por lo que mi visor de formularios me mostrará 

 

Nombre = ....

Fecha = 10/08/2019

Medidor de A = 200

Medidor Interno = 200 ...

..

...

..

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: FormViewer

Hi @Anonymous 

If you are going to use a form without referencing either a gallery or datatable, you have to have a way for the form to show only one record. If there is only one record per day, you can add a datepicker control outside of the form and set the item property of the form to LookUp(datasource, datefield=DatePicker1.SelectedDate).  The datefield in the formula would be the column in your datasource that contains the date you wanted to lookup. If there are several records with the same date, then the form will show the first one. 

View solution in original post

7 REPLIES 7
Highlighted
Super User
Super User

Re: FormViewer

Hi @Anonymous 

Un ViewForm solo puede mostrar datos de un único registro.  Hay varias maneras de obtener ese registro.  El más común en PowerApps es usar una galería para mostrar todos los registros que coinciden con un criterio específico.  A continuación, seleccione el registro que desea mostrar.  El ViewForm debe usar el mismo DataSource que la galería y tener su Items propiedad establecida en el registro elegido en la galería es decir. Gallery1.Selected
En su caso, establezca la galería Items propiedad que se filtrará por la fecha en un DatePicker control.  Una vez que seleccione el registro en la galería, ViewForm mostrará los detalles de ese registro.

Por favor, disculpe mi español, ya que no es mi primer idioma.

Highlighted
Anonymous
Not applicable

Re: FormViewer

Thanks for your answer @Drrickryp 

I dont use gallery, do you know other form for make this ?

Highlighted
Super User
Super User

Re: FormViewer

Hi @Anonymous 

If you are going to use a form without referencing either a gallery or datatable, you have to have a way for the form to show only one record. If there is only one record per day, you can add a datepicker control outside of the form and set the item property of the form to LookUp(datasource, datefield=DatePicker1.SelectedDate).  The datefield in the formula would be the column in your datasource that contains the date you wanted to lookup. If there are several records with the same date, then the form will show the first one. 

View solution in original post

Highlighted
Anonymous
Not applicable

Re: FormViewer

 

Es asi como dices ? @Drrickryp 

Tengo un error.

cual podria ser la solucion?

 Sin título.png

Highlighted
Super User
Super User

Re: FormViewer

Hi @Anonymous 

Check out this image. the form has been resized to make room for the datepicker.  Capture.PNG

 

Highlighted
Anonymous
Not applicable

Re: FormViewer

@Drrickryp  Gracias por tu paciencia 

 

Al colocar todo a como me dices, se genera un error 'La operacion solicitada no es valida: 2019-08-09' sera que es un problema del formato de la fecha?

 

enviar.png

Highlighted
Super User
Super User

Re: FormViewer

No hay problema, no puedo explicarlo. Funciona bien en mi aplicación de prueba.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,028)