Create PDF from filtered data

(0) Share

Report

Posted on by nottheOther

Hi,

1. My data is stored in SharePoint list

2. In application I'm using Data Table to show records, records can be filtered and sorted. This is based on quite big IF in DataTable Items property.

3. How can I create pdf with filtered records (like in DataTable)? For example to see records based on date I use:

Sort(Filter(SharePointList; (FirstDate>DateStart)&&(FirstDate<DateEnd)); ID; Descending);

Best regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 155,656 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @nottheOther ,

Here is a good video from Shane Young on the subject and another one a bit more advanced.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
nottheOther 65 on at

Like (0)

Report
Copy link

Link copied!

Well, in those videos he's using Gallery to show data from SP List. I am using DataTable.
He didn't show how to filter rows based on value let's say collect only items recorded in between registered dates. (StartDate, EndDate).

Was this reply helpful? Yes No
WarrenBelz 155,656 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@nottheOther ,

You cannot select a record from a Data Table and refer to it, so you will need to consider a Gallery.

Also it is not a filter you need - the SharePoint URL needs to be in the table (GalleryName.Selected.SPUrl) so you can send this to the Flow as per the video.

I am happy to look at any code after you have put it together.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 155,656 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @nottheOther ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No