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 :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Subgrid always show &q...
Customer experience | Sales, Customer Insights,...
Suggested answer

Subgrid always show "No available data"

(0) ShareShare
ReportReport
Posted on by Carlik 55

Hello,

I have to insert a subgrid in my Lead form

I need more Accounts for each Lead

So I create a new N:N relation 

NN-REL.png between Lead and Account;

then I add a subgrid in my Form.

I set it in this way

3157.Subgrid.png

When I add items in subgrid, subgrid is always "No available data" status

Can anyone help me?

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at
    RE: Subgrid always show "No available data"

    Hello,

    What is "Account_Shipyard" view? Does it apply any additional filtration on top of your associations?

  • Suggested answer
    LuHao Profile Picture
    LuHao 40,890 on at
    RE: Subgrid always show "No available data"

    Hi Carlik,

    I think the cause of the problem is the filtering of the Account_Shipyard view in the sub-grid.

    The records that appear in the subgrid are filtered strictly by view.

    For example, if I select the "Inactive Account" view for the subgrid, then even if I add active accounts into this subgrid, it will still be "No available data" status because the Inactive Account view is filtered to only show status as Inactive's account.

    pastedimage1604370376775v1.png        pastedimage1604370409881v2.png

    So can you check the filtering of the Account_Shipyard view, or change another view for this subgrid?

  • Carlik Profile Picture
    Carlik 55 on at
    RE: Subgrid always show "No available data"

    Hello, thanks for reply

    Account_Shipyard is a view on Account list. It returns Account with "Shipyard" customized field checked

    Ok, I inserted items from right view and it's ok

    Thanks so much

  • LuHao Profile Picture
    LuHao 40,890 on at
    RE: Subgrid always show "No available data"

    Hi Carlik,

    Glad it worked.

    Please click Yes under "Did this answer your question?" to close this thread.

    Thanks.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 165

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 148 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans