How to bring the records from column in a table view

(0) Share

Report

Posted on by MIA27

I am working on PowerApp for teams, has build table within the teams,

My requirement is as below which I have tried to explain

Kindly advise a method to solve this requirement :

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

cdwhite 1,067 Most Valuable Professional on at

Like (1)

Report
Re: How to bring the records from column in a table view

Hi @MIA27 ,

You could create a separate collection when you click on a gallery item. The collection can store the x3 service dates in order to then be displayed. You can achieve this by adding the following Power Fx to the OnSelect property of the gallery showing the Serial No & Model:

ClearCollect( colServiceDates, {ServiceDate: ThisItem.FirstSvcDate}, {ServiceDate: ThisItem.SecondSvcDate}, {ServiceDate: ThisItem.ThirdSvcDate} );

You can then display the results of the additional collection as another gallery, like so:

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

Was this reply helpful? Yes No
MIA27 2 on at

Like (0)

Report
Re: How to bring the records from column in a table view

Dear,
Thank you for your details advise, which I applied with one addition field and it worked, tested it.
ClearCollect( colServiceDates, {ServiceDate: ThisItem.ExtraSvc1Field1, ServiceSMR: ThisItem.ExtraSvc1Field2}, {ServiceDate: ThisItem.ExtraSvc2Field1, ServiceSMR: ThisItem.ExtraSvc2Field2}, {ServiceDate: ThisItem.ExtraSvc3Field1, ServiceSMR: ThisItem.ExtraSvc3Field2})

But the user need more details of the service carried out, expectation is as below shown image - Its an example from another software :

As the space of the canvas has no much of space, so want to put one of the field under the other 3 field of the record. Please note in the above image that it is showing 4 records (it is screen shot taken from MS Access continuous Form)

Cannot understand how to approach:
Gallery : it allow only 3 field, not added more fields
EditForm Or Display Form : cannot be designed as it auto creates and dont allow edit in the design inside.
Table View : cannot allow design the field arrangement.

Can you please given me an idea, how to acheive this requirement, by your help I have reached till the level to collect data and implement in the table but cannot proceed further

Was this reply helpful? Yes No