Unanswered

Get column display names

(0) Share

Report

Posted on by tagustin

Hello Paul,

I've been hoping to hear back from the community on this post for several weeks now so I thought I would try pinging you in hopes you have some advice for me on the question below. I'd be grateful for any help you could offer. Thank you! Teresa

___________________________________________________________________________________________________________________________________

A while back Will Page was trying to give me some advice on how to retrieve and display the Title/Display Names of columns rather than the Static/Internal names. Since I'm so new to Power Automate, I'm having trouble following the guidance that can be found in the link below. Since the post was getting long and my original question was around removing properties, I thought I would start a fresh post.

I've gotten as far as retrieving the display names via a "Send an HTTP request to SharePoint" action and putting the results into a Compose action, but I'm having trouble tying the column display names together with the results of whether or not the column has changed. I was wondering if you could help me get across the finish line.

Solved: Re: removeProperty Object vs Array Error Message - Power Platform Community (microsoft.com)

I'm getting both the StaticName and the Title (display name) back from the Compose step.

But the FilterArrayGetChanges step only returns the StaticNames. I'm not clear on what steps and expressions I need to add to the flow steps below.

Here are the steps I have so far:

I ran the flow and copied the body of what was returned from the "Send an HTTP..." step into a Compose action.

The expression in the right hand field is string(':true')

The expression in the right hand field is item()?['StaticName']

Part of the And expression got cut off in the screenshot so here is the whole thing.

(not(equals(item(),'Modified')),not(equals(item(),'PCFormVersion')), not(equals(item(),'CDWHeadsetURL')), not(equals(item(),'CDWKeyboardURL')))

---------

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,647 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If you have an array with both the internal and display names of the columns then you should be able to use a Lookup() based on the static name you have to find the display name you want. For example if the static name is "Title" and the displayname is "Fullname" you should be able to do something like this

1) Filter the ArrayofNames by the staticName

2) use First(filteredArray).DisplayName to get the DisplayName.

Was this reply helpful? Yes No
tagustin on at

Like
a
(0)

Report
Copy link

Link copied!
@Pstork1

Hi Paul,

Thank you for the advice, but I'm afraid I'm too new to Power Apps to figure out how to implement it without you showing me step by step. Here is the Output of my "FilterArrayGetChanges" step.

When I attempt to compare the outputs of my 'ComposeTitles' step which has both the static names and titles in it with the 'FilterArrayGetChanges' step I get the following error "The 'from' property value in the 'query' action inputs is of type 'Null'. The value must be an array." I'm pretty sure this is happening because flow isn't able to read it in its current "comparing apples to oranges" formatting issue. I'm not familiar enough with expressions yet to know how to extract the static names where the "has column changed?" value is equal to true and then compare that against the titles/display names that are being returned in the 'ComposeTitles' step which I think is what you are advising to do in Step 1 of your reply. I can't try Step 2 until I get over this hurdle. I'm really new to this so if there is an advanced expression necessary to mine this I would be very grateful for your help.

Here is a sample of what the Outputs from my 'ComposeTitles' step looks like.
{ "d": { "results": [ { "__metadata": { "id": "https://fortive.sharepoint.com/sites/TEKCSOEmployees/_api/Web/Lists(guid'e9bae1f6-5440-414f-93c9-f9862ed0e1e2')/Fields(guid'1d22ea11-1e32-424e-89ab-9fedbadb6ce1')", "uri": "https://fortive.sharepoint.com/sites/TEKCSOEmployees/_api/Web/Lists(guid'e9bae1f6-5440-414f-93c9-f9862ed0e1e2')/Fields(guid'1d22ea11-1e32-424e-89ab-9fedbadb6ce1')", "type": "SP.Field" }, "StaticName": "ID", "Title": "ID" },
Thank you, Teresa

Was this reply helpful? Yes No
pvia 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@tagustin were you able to get this figured out? I'm stuck in a similar spot

Was this reply helpful? Yes No