cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
billw
Level: Powered On

Flow access SharePoint list disagreement

I am getting a conflicting answer to a failed flow. While building an HTML table, I get this error:

 

InvalidTemplate. The execution of template action 'Create_HTML_table' failed. The column values could not be evaluated: 'The template language expression 'item()['Prime_x0020_Manager']['Value']' cannot be evaluated because property 'Prime_x0020_Manager' doesn't exist, available properties are '@odata.etag, ItemInternalId, ID, Title, Contract_x0020_No, Period_x0020_of_x0020_Performanc, ClosedOut, Portfolio_x0020_Manager, Portfolio_x0020_Manager#Id, grsn, d1u7, JobPostings, Modified, Created, Author, Author#Claims, Editor, Editor#Claims, {Identifier}, {IsFolder}, {Thumbnail}, {Link}, {Name}, {FilenameWithExtension}, {Path}, {HasAttachments}, {VersionNumber}'. Please see https://aka.ms/logicexpressions for usage details.'.

 

Yet in the inputs it shows that Prime_x0020_Manager does indeed exist:

...   

"Prime_x0020_Manager": {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      "Id": 3,
      "Value": "XXXXXXXXXXXXXXXXX"
    },
    "Prime_x0020_Manager#Id": 3,

...

 

Furthermore, this worked yesterday.

 

1 ACCEPTED SOLUTION

Accepted Solutions
billw
Level: Powered On

Re: Flow access SharePoint list disagreement

Found my problem ... I was missing a ? in my item() expression

View solution in original post

1 REPLY 1
billw
Level: Powered On

Re: Flow access SharePoint list disagreement

Found my problem ... I was missing a ? in my item() expression

View solution in original post

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Users online (6,483)