How to call odata in PowerApps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

How to call odata in Dynamics 365 SCM.

I made an entity called JournalTransferHeaders at D365 SCM.

And I want to create the next function.

1) 'Refresh" button click.

2) https://AAABBB1face947e5269a3aaos.cloudax.dynamics.com/data/JournalTransferHeaders?$select=Journal&?$filter=dataAreaId eq 'USMF'&cross-company=true

JournalTransferHeaders = entity name

* select field = journal, fillter = USMF

3) get data and save collect

Q1) How do I code in power apps?

Q2) Do I need Power Automae to implement these features?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to call data in Dynamics 365 SCM?

I'm afraid it's not supported in powerapps now.

For now, there's no standard connector could call Dynamics 365 SCM.

I suggest you try to use Power Automate to call odata in Dynamics 365 SCM and then send the result back in powerapps.

Like this:

Here's a doc about how to use http to send a request in power automate for your reference:

https://flow.microsoft.com/en-us/blog/http-card-tutorial/

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

thank. v-yutliu-msft.

I tried it that way.

However, it was blocked from the Authentication.

I have set the following settings.

Authentication : Active Directory OAuth

i know that tenant id and secret and Client ID.

I don't know what price to put in Audience.

Where can I find Audience? LCS? Azure portal?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Have you registered D365 SCM in the Azure Active Directory?

If you don't or want to know more please see Register an App in the Azure Active Directory Oauth v1.0.

(Firstly, you need to make sure you have D365 SCM in the Azure Active Directory.)

Then, you could check this blog to see how to fill the data in this action:

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/The-Sweetest-Graph-Call-You-ve-Ever-Seen-Hiding-Data-in-Flow/ba-p/262599

If the problem still exists, you could try to use the Client ID value in Audience .

Here's a similar issue for your reference:
https://powerusers.microsoft.com/t5/Connecting-To-Data/Http-Action-Connect-to-Web-API-with-Active-Directory-OAuth/m-p/176067

Best regards,

Was this reply helpful? Yes No