web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to bring the recor...

Power Apps

Answered

How to bring the records from column in a table view

(0) Share

Report

Report

Posted on by MIA27

2

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

cdwhite 1,069 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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
MIA27 2 on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation