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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
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

    Hello,

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

  • Suggested answer
    LuHao Profile Picture
    LuHao 40,892 on at

    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

    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,892 on at

    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

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Nagaraju_Matta Profile Picture

Nagaraju_Matta 121

#2
ManoVerse Profile Picture

ManoVerse 71 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans