
Hi
I have written a flow to connect to a .csv file using the One Drive Connector.
The connector returns all of the fields and blank fields are returned as """". So I know if a field is blank by the length of the field.
It has been decided that instead we will read the data from a SQL Server database which has been loaded using SMSS and importing the .csv file.
The SQL Server connector, as far as I can see, only returns the fields in a database record which contains data and returns the data as an object. Is this correct ? So I have to check each time that the field has been requested it is not empty.
Is this a correct interpretation of how SQL Server connector returns data ?
Thanks
Nigel
Hi,
Yes, you are correct. The SQL Server connector in Power Automate only returns the fields in a database record that contain data and returns the data as an object .
Therefore, you will have to check each time that the field has been requested it is not empty.
Gill