How to call odata in PowerApps

Like (0) Share

Report

Posted on 20 Mar 2020 02:38:34 by Community Power Pla...

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?

All responses (3)

Answers (1)

Verified answer

v-yutliu-msft on 23 Mar 2020 at 03:39:05

Like (1)

Report

Re: How to call odata in PowerApps

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,
Community Power Pla... on 20 Mar 2020 at 10:20:23

Like (0)

Report

Re: How to call odata in PowerApps

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?
v-yutliu-msft on 20 Mar 2020 at 08:40:32

Like (0)

Report

Re: How to call odata in PowerApps

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,