Hello Community,
Hope all is well with you!
I have a requirement,
I have data coming from a Power BI Dataset, I need to Update this data into Excel file. If the record exist then Update the Row else create a New Row.
My Approach:
The below Image is my approach but it is failing in the Last Step where I am unable to figure out what should I need to do after the Create HTML 2 Step.
I used the Create HTML steps to make sure I was getting the right data (For my reference).
The Primary Column in from Power BI is 'Contract[ContractId]' and in Excel is ContractId
I request you to help me with final step where I need to Check if the record Exist by using the contractId if not create a new row.
Many Thanks in Advance 😊
Hope all is well with you!
I have a requirement,
I have data coming from a Power BI Dataset, I need to Update this data into Excel file. If the record exist then Update the Row else create a New Row.
My Approach:
The below Image is my approach but it is failing in the Last Step where I am unable to figure out what should I need to do after the Create HTML 2 Step.
I used the Create HTML steps to make sure I was getting the right data (For my reference).
The Primary Column in from Power BI is 'Contract[ContractId]' and in Excel is ContractId
I request you to help me with final step where I need to Check if the record Exist by using the contractId if not create a new row.
Many Thanks in Advance 😊
243
