Share
Report
30I put this formula for the button to upload the excel data:
Clear(Pending); ForAll(Substitute(Split(Substitute(Substitute(importdatafromcustomexcel1.Output,"[",""),"]",""),"},{"),"}",""),With({SingleObject:Substitute(Substitute(Value,",",":"),Char(34),"")},Collect(Pending, {LEDGER_NAME:Last(FirstN(Split(SingleObject,":"),2)).Value, PERIOD_NAME:Last(FirstN(Split(SingleObject,":"),4)).Value, SEGMENT1_CODE:Last(FirstN(Split(SingleObject,":"),6)).Value, SEGMENT2_CODE:Last(FirstN(Split(SingleObject,":"),8)).Value, SEGMENT3_CODE:Last(FirstN(Split(SingleObject,":"),10)).Value, SEGMENT4_CODE:Last(FirstN(Split(SingleObject,":"),12)).Value, SEGMENT5_CODE:Last(FirstN(Split(SingleObject,":"),14)).Value, SEGMENT6_CODE:Last(FirstN(Split(SingleObject,":"),16)).Value, SEGMENT7_CODE:Last(FirstN(Split(SingleObject,":"),18)).Value, SEGMENT8_CODE:Last(FirstN(Split(SingleObject,":"),20)).Value, SEGMENT9_CODE:Last(FirstN(Split(SingleObject,":"),22)).Value, SEGMENT10_CODE:Last(FirstN(Split(SingleObject,":"),24)).Value, DISPLAY_AMOUNT:Last(FirstN(Split(SingleObject,":"),26)).Value})))
For data table, I put the formula, Pending, under "Items" property.
Result: During testing, I clicked the button to upload the excel file into the collection and the data from collection transfered to data table.
How will I use the button to upload the excel file and transfer data into the data table without using collection? Data table is connected to dataverse. Please advice.
All responses (
Answers (
