Unanswered

Internal Sharepoint library field name of ThisItem.'Folder path'

(1) Share

Report

Posted on by RathwynAE

This may be a more appropriate question for the SharePoint forum, but I'm worries no one there will know what I'm talking about.

I have built a dynamic link in PowerApps that opens a document from a gallery into Preview mode. The OnSelect formula looks like this:

Launch(
 Concatenate(
 "https://<organization>.sharepoint.com/sites/<SiteName>/<LibraryName>/Forms/
AllItems.aspx?id=/sites/<SiteName>",
 ThisItem.'Folder path',
 ThisItem.'File name with extension',
 "&parent=/sites/<SiteName>",
 ThisItem.'Folder path'
 )
)

I have realized later that I could replace ThisItem.'Folder path' + ThisItem.'File name with extension' with ThisItem.'Full path' but this works perfectly well. Now I am trying to do something similar directly within a library, and I can't find what the actual internal field name for 'Folder path' is.

ThisItem.'Full path' = [$FileRef]

ThisItem.'File name with extension' = [$FileLeafRef]

ThisItem.'Folder path' = ???

Anyone know the answer to this?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @RathwynAE ,

ThisItem.'Link to item'

will get you the full URL for the file.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
RathwynAE 56 on at

Like (1)

Report

Thanks for your response. 'Link to item' opens the document in Edit mode. I've built the specified custom URL so that clicking the link automatically opens the document in Preview mode - which, as I mentioned in my post, works as expected, so I do not need alternative ways to create this link in PowerApps. I'm asking about what the internal SharePoint field name is for the equivalent statement in PowerApps.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
@RathwynAE ,

To clarify

ThisItem.'File name with extension'

(obviously) gives the file name

ThisItem.'Folder path'

gives the folder structure from the site base up

ThisItem.'Full Path'

adds these two together

ThisItem.'Link to item'

puts the Site URL in front for the full "external" URL.

What other part are you requiring ?

Was this reply helpful? Yes No
RathwynAE 56 on at

Like (1)

Report

@WarrenBelz

PowerApps gets these values from SharePoint via the connector. To reference these values within a PowerApp, I would use what you wrote. I have no issues or misunderstanding about this.

However, I need to reference these values within SharePoint. What PowerApps calls these values is different than what SharePoint calls these values. I am trying to ask: what is the SharePoint equivalent name for the value that PowerApps calls ThisItem.'Folder path'.

I apologize for the very delayed response, my automation efforts are side work and my main work has been taking up the majority of my time lately.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

Hi RathwynAE

If you are meaning the "get link" URL obtained directly from the SharePoint interface, then that is not available from the SharePoint connector in Power Apps.

Was this reply helpful? Yes No
RathwynAE 56 on at

Like (1)

Report

Hi WarrenBelz, I really appreciate your response even after so much time. However, I don't think we are talking about the same things.

I am not trying to write anything in PowerApps, or reference anything from PowerApps.

I wrote a formula in PowerApps (included in the original post) that I am trying to translate to SharePoint column formatting JSON.

I have not been successful in translating the PowerApps code to SharePoint JSON because I don't know what ThisItem.'Folder path' is in SharePoint JSON.

For example, the translation of PowerApps's ThisItem.'Full path' in SharePoint JSON is [$FileRef]. But I cannot find anywhere what ThisItem.'Folder path' translates to. I am asking here instead of on the SharePoint forum because I felt that no one on the SharePoint forum would know what ThisItem.'Folder path' even was.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

Hi RathwynAE,

Sorry, I am not aware of the JSON value either.

Was this reply helpful? Yes No