Answered

Dataflows Web API to get Entity data including Formatted Values

(0) Share

Report

Posted on by davidyc

I'm using the web api in the Dataflows to get entity data where i would also like to retrieve the formatted values. I can see from the link below from MS documentation that this needs to be defined, but i can't work out how to do this in the context of a dataflow web api URL?

Any help much appreciated

Query Data using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Docs

Categories:

All responses (3)

Answers (1)

Verified answer

davidyc 99 on at

Like (0)

Report

Re: Dataflows Web API to get Entity data including Formatted Values

turns out it was a simple tweak to the syntax and I now have an infinitely better dataset with all OptionSet value labels:
davidyc 99 on at

Like (0)

Report

Re: Dataflows Web API to get Entity data including Formatted Values

Hi Chris, it seems the web connector from your link is different to the Web API when connecting with the Dataverse in dataflows - do you know how I would add a header from this point?
ChrisPiasecki 6,389 Most Valuable Professional on at

Like (1)

Report

Re: Dataflows Web API to get Entity data including Formatted Values

Hi @davidyc,

You should be able to specify HTTP headers in the dataflow Web connector options. The header Prefer: odata.include-annotations="OData.Community.Display.V1.FormattedValue" indicates to the API to return the formatted values in the response.

If you're bringing back related data through lookups and want the formatted values from that, you can specify the header Prefer: odata.include-annotations="*".

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.