Hi
I am using execute SQL connection in Power Automate Desktop to connect it with SharePoint.
[Connection String]
Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=0;RetrieveIds=Yes; DATABASE=https://TENANT_NAME.sharepoint.com/sites/SITE_NAME/;LIST=LIST_ID_GUID;
[SQL Statement]
INSERT INTO list (Title, FirstName, LastName, PhoneNumber) VALUES ('Item01', 'Alice', 'White', '0123')
[SQL Statement]
SELECT * FROM list WHERE Name="abc"
My select statement was working fine . But now sometimes it skips the data. and get less records.
I have 200 records but it gets only 100 like that it is not getting proper records. Anyone plz help me in this. Is the issue is from SharePoint or from PAD? How can I overcome this
