
I have an Excel file with a table. I use a Power Automate flow to import that data from Excel into a Dataverse table. One of the columns in the table is of the datatype Whole Number (called Relatienummer). When the flow reads from the Excel file it turns all the columns into strings.
I have added the action Add a New Row to the flow. When I click other fields (strings) I can choose from Dynamic Content. When I click the column Relatienummer (Whole Number), the columns from the previous steps disappear from Dynamic Content.
I've tried all other things like int(body('Lees de tabel Relaties uit Excelbestand')?['Relatienummer']), or working with triggerBody, but I keep getting errors.
I'm not trying to something strange! I just want to put a string into a integer.
Can anyone help me?
Ha! Finally found it myself. I tried Items, but the wrong way. I used it with the previous step.
This worked: int(items('Vul_records_in_de_tabel_Relaties_in_Dataverse')?['Relatienummer'])