Answered

Powerapps flow to get PDF file from sharepoint

(0) Share

Report

Posted on by icturion

Hello,

I want to beable to open a PDF file from a Sharepoint document library within my powerapp. for this to work using Power Automate.

I start with a https get Request as trigger and tha i'm trying to get the itemid by using Variable:

trigger()['outputs']['queries']['itemid']

i want to use the itemid to get the file contact of the pdf file that triggerd the flow.

And then i deliver the file contact back to my powerapp.

The problem is that

trigger()['outputs']['queries']['itemid'] is not working i get an error:

Unable to process template language expressions in action 'Initialize_variable' inputs at line '1' and column '2871': 'The template language expression 'trigger()['outputs']['queries']['itemid']' cannot be evaluated because property 'queries' doesn't exist, available properties are 'headers'. Please see https://aka.ms/logicexpressions for usage details.'.

hopefully someone knows a better way

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @icturion ,

queries exist in triggerBody.
use Compose action to check what is available in queries like this :
triggerBody()?['queries']

Thanks

Was this reply helpful? Yes No
icturion 83 on at

Like (0)

Report
Copy link

Link copied!

thx for the quick respons.

if i use trigger or triggerbody the only options are:
- UriPathAndQuery
- uriQuery
I got queries from the http get function.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @icturion ,

Please provide flow screenshot of initial steps.

Thanks

Was this reply helpful? Yes No
icturion 83 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
icturion 83 on at

Like (0)

Report
Copy link

Link copied!

Hi,

this article does the same steps: https://centricconsulting.com/blog/how-to-use-powerapps-to-view-pdfs-step-2-microsoft-flow_portal/

But this doesn't work.

Maybe someone knows a better way to make the PDF viewer work with pdf that are located in a sharepoint document library.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report
Copy link

Link copied!

Hi @icturion ,

itemid is passed from Powerapp and this request should be set as "Get" under Show advanced option. Once you do this it should be working fine.

Thanks

Was this reply helpful? Yes No
yabela 53 on at

Like (0)

Report
Copy link

Link copied!

Hi, have you managed to solve this, please? Getting the same error with the below flow:

Thanks.

Was this reply helpful? Yes No
Verified answer

icturion 83 on at

Like (0)

Report
Copy link

Link copied!

Hi Yabela,

i got i to work.

This is my powerautomate that i use:

This is the code in my PowerApp.
screen - Onvisible:
pdateContext({ loading_v: true });;
UpdateContext({
pdf_v:
DocumentophalenPowerAppBHV.Run(
Concatenate( First( Split( selecteditem_v.Naam; "." ) ).Result; ".pdf" )
)
});;
UpdateContext({ loading_v: false })

PDF viewer - Document:
pdf_v.pdf

Was this reply helpful? Yes No
Laur_Adri 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The flow you use was working for me for about 2-3 months until yesterday...
Did the same happen to you or is yours still working?

Didn't change anything in the code.

Was this reply helpful? Yes No
icturion 83 on at

Like (0)

Report
Copy link

Link copied!

Hi,

For us the flow is still working.

Was this reply helpful? Yes No