Forum Discussion
aaa12
Helper II
Helper IIDealing with blanks in PowerBI Integration
Hello - I'm imbedding a PowerApp in PowerBI. The connection is established. When the Submit button is pressed, a flow (CSVAttachement) should trigger, however, in adding logic to pass data from ...
SaiTejaTalasila
Super User
Super UserHi aaa12 ,
Try this one-
- Collect(
check_null,
ShowColumns(
[@PowerBIIntegration].Data,
"Environment", 'Created at'
),
{
'Created at': If(
IsBlankOrError('Created at'),
0,
Value('Created at')
),
Environment: If(
IsBlankOrError(Environment),
"Unknown",
)
}
);
CSVAttachement.Run(
JSON(
check_null,
JSONFormat.IncludeBinaryData
),
Dropdown1.SelectedText,
Comments.Text
);
aaa12Helper II
Helper IISaiTejaTalasila Thank you for your response. I tried your solution but the column is not recognized in the isBlankError function. In the screenshot below, I'm attempting to enter "created at" but the field is not among the options to select.
Could you offer addtional guidance?