Unanswered

Updating Rows in Dataverse Table based on Array Result

(0) Share

Report

Posted on by Joseph Nasr

Hello,

I am building a flow to update the exchange rate of the currencies in my "Currencies" Table using an API from the 'Get Exchange Rates' Action based on the video: How to filter a JSON object with dynamic keys with Power Automate - YouTube

The output of Action called Select is as follows:

{
 "body": [
 {
 "Currency": "USD",
 "Rate": "1"
 },
 {
 "Currency": "AED",
 "Rate": "3.6725"
 },
 {
 "Currency": "AFN",
 "Rate": "71.154"
 },
 {
 "Currency": "ALL",
 "Rate": "95.1122"
 },
 ...
 ,
 {
 "Currency": "ZWL",
 "Rate": "5798.6005"
 }
 ]
}

In the Dataverse Table 'Currencies', how can I update the 'exchangerate' (based on the relevant 'isocurrencycode', where the 'isocurrencycode' column should be equal to the 'Currency' Key in the returned output above)? I am not being able to set the new rate.

Eg: If the returned Dataverse row's 'isocurrencycode' is 'USD', the 'exchangerate' should be set to 1 (as returned above by Select).

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @Joseph_Nasr
According to your description, you want to update the Dataverse table.
This is my flow:
The result in the table is like this:
You can refer to this screenshot:
item()?['Currency']
length(outputs('List_rows')?['body/value'])
int(0)
outputs('List_rows')?['body/value']?[0]?['cr667_currenciesid']
float(items('Apply_to_each')?['Rate'])

You need to replace your initial column name in your side.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Joseph Nasr 67 on at

Like (0)

Report

Hi @v-yueyun-msft,
Thank you so much for the assistance. It is working, but the flow is getting marked as failed because it is also trying to modify the exchangerate of the base currency which in my case right now is US Dollar (isocurrencycode: USD).

Where should I add the condition that isocurrencycode should not be equal to USD?

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

Hi , @Joseph_Nasr
Do you mean you want to judge by the specail isocurrencycode in your Excel file?
If this , you can add the condition here to judge if the isocurrencycode="USD".
You can use the items('Apply_to_each')?[Curreny] to get your isocurrencycode in the 'Apply to each' loop.

If I misunderstand what you mean, you can give me some sample data and the end result you want to get so that I can help you better!

Now I'm off work lala.., and I'll get back to you tomorrow if need !

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Joseph Nasr 67 on at

Like (0)

Report

Nevermind I added it in the condition but it added a ForEach on its own. Nevertheless it is working! Thank you so much

Was this reply helpful? Yes No