Hello everyone! Could someone can solve this problem? Thank you!
Purpose: extract data from excel table to sharepoint list
Backgroud: I made a flow and used [control] action. If the [ title] column data from the excel（source） is the same with the [title] data in the sharepoint list （target）, the corresponding items in the sharepoint list(target) will be updated by the data from excel(source). And if it is not, the new data record in excel will be copied to the sharepoint list. I tested and found an error. Because of the single quotation mark in the title, The query in the [get items] action did not work. The [get items] action is for getting the column data in sharepoint list , the query in it is to decide the title is the same with the title in excel or not. The query what I wrote is title eq 'dynamic content title'
What I did: For solving this problem, I used 2 variable actions. First variable action name: single-quote, type: string, Value: ' Second variable action name: single-quote-esc, type: string, Value: '' 　
then I set the query in the [List rows present in a table ] action which is for getting the data from the excel（source）. I set the query like this replace(item()?['Title'],variables('single-quote'),variables('single-quote-esc')) And I set the same query to the [get items] action.
Problem: After what did, the test still failed. The error is [
Unable to process template language expressions in action 'get items' inputs at line '0' and column '0': ''The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Null'. ] I think the problem is the query, but I don't know how to improve it.
replace(item()?['Title'],variables('single-quote'),variables('single-quote-esc'))
And I set the same query to the [get items] action.
The flow architecture what I made
manually trigger → variable (for counting ) →variable single quote →variable single-quote-esc→do until（for get data more than 256）→get items →apply to each → control
∟　true → [create item]
∟　false →for each → [update item]
8
Share
Report
All responses (
Answers (
