Share
Report
1,207This might be a bit ambitious to explain.
I have created a report in Power Automate for displaying completed inspections which will be sent by email. Ideally I wanted to create a PDF but my report contains too many images so I can't use the free OneDrive conversion from HTML to PDF method as that is limited to 2MB.
The inspection is created in Power Apps and stored in a SharePoint list. Associated images are stored in a SharePoint library.
An asset can have multiple observations - one observation = a sharepoint record.
An observation can have multiple images. Stored in SharePoint library.
I have managed to output HTML in the following format:
Asset Number 1
| Observation Number | Observation Name | Result | Score |
| 1 | Obs 1 | Pass | 60 |
| 2 | Obs 2 | Fail | 30 |
Observation 1 Images
| Image 1 | Image 1 comment for obs 1 |
| Image 2 | Image 2 comment for obs 1 |
Observation 2 Images
| Image 1 | Image 1 comment for obs 2 |
| Image 2 | Image 2 comment for obs 2 |
Asset Number 2
Observation 1 Images
| Image 1 | Image 1 comment for obs 1 |
| Image 2 | Image 2 comment for obs 1 |
I would prefer the Observation images to appear directly underneath the related observation. For example:
Asset Number 1
| Observation Number | Observation Name | Result | Score |
| 1 | Obs 1 | Pass | 60 |
Observation 1 Images
| Image 1 | Image 1 comment for obs 1 |
| Image 2 | Image 2 comment for obs 1 |
| Observation Number | Observation Name | Result | Score |
| 2 | Obs 2 | Fail | 30 |
Observation 2 Images
| Image 1 | Image 1 comment for obs 2 |
| Image 2 | Image 2 comment for obs 2 |
I have an array of asset numbers that I am using Appy to each to filter the related images and observations.
This gives me an array of observations and an array of images that are related to the asset inspected.
I am then using Create HTML Table to produce a table of observations and a table of images.
What I want instead is to produce a single row table with the observation followed by the table of images.
Sorry if this is a bit vague and impenetrable. Happy to provide more detail.
All responses (
Answers (
