Here is my flow structure and JSON: [paste your current JSON].
Please share your flow and the JSON expressions
(1) List name
The list name is built dynamically from form inputs. I keep getting 'List not found' even when the list exists with the correct name.
You must ensure that the list name that you are constructing using expressions matches exactly, the SharePoint list name. For example, adding an accidental space before or after the list name will cause the flow to fail with a "List not found" error:
✅ "Test List"
❌ "Test List "
❌ " Test List"
You can use the trim() function to remove spaces the before and after the list string.
Note that using a custom value to specify the "list name" means that the dynamic content for the list is no longer available.
(2) Choice field
Please show how the values are stored in the Excel.
The example below shows how I created a new a new SharePoint Item. I specified the Stage choice column using the value property:
Here is a closer look at the stage column, which is a choice field in SharePoint:
Here, the new item was created:
Hope this helps.
Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!