I have a document library with document status as pending, approved, rejected. I want to show status of document in power BI. But column fields are not visible. What must be the connector I have to use?
The “Approval Status” column is the default column in SharePoint, then you could create a custom column in the library. Then set the value of the custom column as the value of the “Approval Status” column.
Sorry for giving your confusion.
The “Approval Status” column is a lookup field and not applicable in the calculated fields.
Then we can use SharePoint designer workflow to set the value of the custom column as the value of the “Approval Status” column.
Because the “Approval Status” column is the lookup column, we cannot get the string value of the “Approval Status” column, we only can get the number of the “Approval Status” column.
But that column need to be updated manually? Sep 16, 2019 at 16:07
you could create a calculated column, and set the value of the column equal to the value of the “Approval Status” column. then you do not need to update the custom column manually.– Amy_MSFTSep 17, 2019 at 0:39
Its showing me technical error, can u tell me exact formula? Sep 18, 2019 at 7:18
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.- this is the error Sep 18, 2019 at 14:20
I have updated my reply.– Amy_MSFTSep 19, 2019 at 2:45