Hi team,
I have an excel file that when i update i need the list i created to update as i have automated actions in the list to nofity the person needed of the changes. The flow runs successfully, but i have made changes and the list still isn't updating. I have the excel file in the document folder of the sharepoint and the list is in the sharepoint. After Recurrence i have list rows present in a table which points to the excel file the next flow is apply to each @{outputs('List_rows_present_in_a_table')?['body/value']} within apply to each i have compose: @{trim(coalesce(items('Apply_to_each')?['JOB #'], items('Apply_to_each')?['JOB # '], items('Apply_to_each')?['JOB'], ''))} then Get Items: which points the list on the sharepoint and have a filter query: @{concat('Title eq ''',replace(trim(coalesce(string(outputs('Compose')),'')),'''',''''''),'''')} under get items i have condition: Left box @{length(body('Get_items')?['value'])} Middle = is greater than right box = 0.. you then have true flase. and they both contain: @{outputs('Get_items')?['body/value']}
The flow is supposed to update the list if there is a change and add if there is a row in my table that isn't on the list.
I also tried to add a Yes / No to the list. If column __ says True click yes, leave blank if not true
