I’m currently trying to use the Power Automate integration to create an excel spreadsheet that summarises data from Inspection Reports from a specific template, with the last column in the inspection to include a photo/image of the defect from the inspection. The photos from inspection are stored as media during in the inspection - and when downloading the inspection reports + media, they are given a unique name.
Playing around with Power Automate there is a HTTPS link to the photo available as an output, but when trying to access this link I get a forbidden or “this page isn’t working error”. Example output and link as per the below:
[{"parent_id":"257116-b5a2-40ba-9ce-2e284979d9","item_id":"32aac8-58b2-4578-bcb7-9626f56d9a","label":"Photos","type":"media","options":{"is_mandatory":true},"responses":{},"media":[{"date_created":"2025-04-01T11:26:24Z","file_ext":"png","label":"Screenshot 2025-02-11 132511.png","media_id":"b77d2b78-7346-44a4-82bb-3cf89c517f4d","href":"https://api.safetyculture.io/audits/audit_fe8bd2450603995c79e9f6659288/media/b77d2b78-7346-44a4-82bb-3cf89c517f4d"}]}]
As far as I can tell the green text is the unique name given to the media.
Is there a way to get access to these links, so they can be shared in a SharePoint spreadsheet, so the images can be attached to a cell in the spreadsheet using the IMAGE() function in excel?
e.g.: =IMAGE("https://api.safetyculture.io/audits/audit_fe8bd2450603995c79e9f6659288/media/b77d2b78-7346-44a4-82bb-3cf89c517f4d",,0)
At the very least, is there a way to download just the media from inspections so they can be stored on a common SharePoint directory so the spreadsheet can then provide a link based on the last part of the “href” address?
Following on from this, if a common SharePoint address was used, a formula within the Flow or Excel spreadsheet would just need to reference the change in filename as shown in green above.
For some further context, I’m trying to utilise the Power Automate Integration to generate a table with multiple custom dropdown lists that the current analytics tab does not allow, which would allow other users and our client to filter the data by their different fields (area codes, gridlines, defect types, condition, etc - the majority of these fields are set as dropdown lists in the Template).