web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power Automate - Creat...

Power Apps

Unanswered

Power Automate - Create Folder in Sharepoint from Dataverse Table with Lookup Column

(0) Share

Report

Report

Posted on by jbc1

10

I have created two Dataverse tables, a Matters table, and a Clients table.

The Matters table has a LookUp column with the related table being the Clients table.

There is another Description column which is a simple text column to type in a short description of the Matter.

I would like to create a Flow in Power Automate so that when a new matter is added to the Matters table, a folder is created in a Sharepoint document library titled "Client Name - Description".

The description comes out just fine, but the Client Name is a bunch of random letters and numbers.

In the Flow I am choosing Client(Value) in the dynamic content.

Any help would be appreciated.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Fubar 8,487 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
The "random letters and numbers" will be the (unique) internal guid of the record. The answer may depend on exactly what/how you are retrieving the values, but to get the Primary Column value of the lookup generally
_yourlookupfieldname_value@OData.Community.Display.V1.FormattedValue

Was this reply helpful? Yes No
jbc1 10 on at

Like (0)

Report
Copy link

Link copied!

Thanks, yes, it is the Primary Column value that I am looking for, with the Primary Column of the Clients table being "Name".

I've tried copying and pasting the above as an expression in Power Automate replacing "yourlookupfieldname" with "name", but that doesn't seem to be valid, can't seem to figure out how to put that in to make it work.

Was this reply helpful? Yes No

Join the conversation