web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate Blocker
Power Automate
Unanswered

Power Automate Blocker

(0) ShareShare
ReportReport
Posted on by
"I am building a Power Automate flow triggered by a Microsoft Form. The flow needs to create items in a SharePoint list from an Excel source. The list name is built dynamically from form inputs. I keep getting 'List not found' even when the list exists with the correct name. I also need Choice fields (Phase, FIT Stage, Primary Owner) to populate correctly from Excel values. Here is my flow structure and JSON: [paste your current JSON]. My SharePoint site is on Microsoft 365. I do not have admin access. Can someone help me identify what is going wrong?"
Categories:
I have the same question (0)
  • Ellis Karim Profile Picture
    12,163 Super User 2026 Season 1 on at
     
     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
    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!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard