Unanswered

BadRequest. The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.

(0) Share

Report

Posted on by JuanMartinRP

Greetings dear, I have been struggling for a few days and looking for options in forums about this error and I have not been able to solve it, my intention is to take some data from Power BI and send it by mail with automated power but in the step where I select the data I get the error of null, if you could help me I would greatly appreciate it.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Add a Compose between the trigger and the Data Select. put the Dynamic content you are using in the source of the data select in the Compose. This will let you look at the actual data coming from the trigger. The error you are getting would suggest that the source you are using is a null table. That means either something is wrong with the trigger from Power BI or you are using the wrong dynamic content entry.

Was this reply helpful? Yes No
JuanMartinRP 8 on at

Like (0)

Report
Copy link

Link copied!

I DID WHAT YOU TOLD ME AND THE ERROR STILL PERSISTS, THE TABLE IS NOT NULL SINCE I USE THEM IN THE BI REPORT

Was this reply helpful? Yes No
Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you show me the output of the Compose you added?

Was this reply helpful? Yes No
JuanMartinRP 8 on at

Like (0)

Report
Copy link

Link copied!

Here is what I did it still gives me the error

Was this reply helpful? Yes No
Pstork1 68,898 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

And if you click on the link in the compose output does it show you any data or just a blank screen? That link normally means there is too much data to show or that the array of data is null. Given the error I expect it is null. That means you aren't getting the output you think you are from Power BI.

Was this reply helpful? Yes No