You’re offline. This is a read only version of the page.
Hi
I have a weird situation. First let me explain what I am doing. We have a Deskktop Application, we generate data from here. Data is exported in an Excel File. User simply press CTRL+T and convert data to a Excel Table. Then this file is uploaded as a list attachment. Then later a flow is called from Power Apps which uses this file from list attachment and created new items in another sharepoint list for each row in excel file. So far so good. This was running perfectly since last 1 year.
No we need to add 4 additional column in Source file, I created a VBA code for that and 4 fields are added with data validation for dropdowns.
a line of code converts data to a Table so that user need not to press CTRL+T and data can be uploaded on sharepoint
VBA code to perform this task is given below:
Share
ReportActiveSheet.ListObjects.Add(xlSrcRange, Range(myRange), , xlYes).Name = _
"TblATRMSUploader"
Range("TblATRMSUploader[#All]").SelectNow file generated from VBA code is not going through my flow.
I have action to get all Tables in files. flow keep trying and ultimately it fails
If I create table manually for same data it goes through.
if you look at Excel file generated from VBA and normal file there is no diffrence
I am using below code to save this file
ARMS_uploader.SaveAs ThisWorkbook.Path & "\ARMS_uploader_" & SourceFileName, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Range("A1").Select
Any idea or solution to resolve it
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
All responses (
Answers (