Share
Report
135Hi,
I have a SQL view which joins several tables with information about products and kit parts needed to make them. This data is getting pushed into a Sharepoint List, which then run every 2 days to look for new products that need made. My issue is that under Get Items Sharepoint List, i cant then use a Filter Query to check and run my condition against which will populate any new records.
Example data that's getting pulled in, as you can see below i created a NEWID() field in my SQL view, with the hope that it would create a unique reference for each line., but when running the flow i am getting an error.
The expression "sqlid eq 166FF276-BB4D-45BD-8CD0-236A3866126D" is not valid. Creating query failed.
clientRequestId: 2dae14dd-248b-4306-9a40-067b5dfb2b97
serviceRequestId: 0a698aa1-2078-b000-cd0e-fe091ef379fc
clientRequestId: 2dae14dd-248b-4306-9a40-067b5dfb2b97
serviceRequestId: 0a698aa1-2078-b000-cd0e-fe091ef379fc
Item TAJ100.K10 has two components TAM900/V10 + TAM906.V10, we have one being made against Document 33578 , and Document 33701.. With out a UniqueID field i cant control the information flow correctly.
Any help would be appreciated.
Thanks
Categories:
All responses (
Answers (
