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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

BigInt

(1) ShareShare
ReportReport
Posted on by 1,084
Recently my company decided to use BigInt data types in dataverse for ids.
 
I have power automate flows I am building that need to List Rows from dataverse and filter on this column.
 
I am getting weird error about the data types dont match GUID vs Int...
 
But obviously it's not GUID it is BigInt.  So there's something wrong with that error.
 
But I cant figure out how to get the odata filter to work on this bigint column?  Is it just not possible or has someone found a way?
 
Thanks,
Terry
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    51,803 Super User 2025 Season 2 on at
    BigInt
    Hi
     
    So I am not sure what your company did, but Tables in Dataverse use a GUID for its row identifier, there is no way to make it anything else.
     
    Maybe your company added a new column and made that a big it, but it sounds like you are trying to use the BigInt in the ID column of a System Table or Custom table doesn't matter its a guid
     
    Feel free to share a picture of a Table in your Dataverse, in the Columns and then share your flow where you are trying to use a BigInt instead of the GUID.
     
    never going to work.
  • Mattw112b Profile Picture
    1,084 on at
    BigInt
    I didnt say row identifier... just a different identifier in the table.  Seems like BigInts arent supported though.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard