Self_solved:辞書変数dictの1行をDataRow配列arr_DataRowに変換したい

日本 フォーラム
1

こんにちは
UiPath Studio 2025.0.161 Community editionのユーザです。

ForEachアクティビティで、辞書変数dictをkvをkeyにして回しています。

dictの変数の型はDictionary<String,DataRow□>です。

dictの1行をDataRow配列arr_DataRowに変換する構文が下図のとおり静的エラーを起こしています。
どう修正すればよいでしょうか？

The image shows a Japanese error message in a programming interface indicating that a 'KeyValuePair(Of String, DataRow())' value cannot be converted to a 'String'. (Captioned by AI)
The image shows a Japanese error message in a programming interface indicating that a 'KeyValuePair(Of String, DataRow())' value cannot be converted to a 'String'. (Captioned by AI)1014×408 19.7 KB

2

Hi @gorby

You are using a For Each on dict variable. So where is kv coming from?

3

Hi @gorby

Can you try the following:

Approach 1:

arr_dataRow = New System.Data.DataRow() { currentKeyValuePairOfTextAndDataRow.Value }

The image shows a UiPath workflow configuring a "For Each" loop that iterates over dictionary rows and assigns a new DataRow array. (Captioned by AI)
The image shows a UiPath workflow configuring a "For Each" loop that iterates over dictionary rows and assigns a new DataRow array. (Captioned by AI)1275×451 32.7 KB

Approach 2: If you want to Add/Concat DataRow to the array, then Do the following:

  1. initialize the arr_dataRow using Default New System.Data.DataRow() {}
  2. use the below code in assign:
arr_dataRow = arr_dataRow.Concat(New DataRow() { currentKeyValuePairOfTextAndDataRow.Value }).ToArray()

This image shows a UiPath workflow where a activity iterates through a dictionary of rows, with an activity appending new DataRows to an array. (Captioned by AI)
This image shows a UiPath workflow where a activity iterates through a dictionary of rows, with an activity appending new DataRows to an array. (Captioned by AI)1416×720 49.9 KB

4

kv comes from keyvalue of dict.

5

Hi, I noted you misunderstood browse for types of dict.
Browse for types of dict is Dictionary<String, datarow□> NOT Dictionary<String, datarow>.

6

Oh. In that case you can directly assign

arr_datarow = currentKeyValuePairOfTextAndDataRow.Value

Obviously, rename the item to something smaller.

7

Before receiving your second suggestion, I managed to find the same answer by myself.
Thank you for your support anyway.

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.