Power Platform Community Forum Thread Details

I'm creating a canvas app in Microsoft Power Apps. my data source is a sharepoint list. I'm storing some suppliers inside my sharepoint list and showing them in a gallery. sometimes under a certain supplier there are another subsidiaries. I want when the user clicks to edit a supplier he/she will have another gallery that shows the subsidiaries falling under that supplier. if there where no subsidaries it will allow to edit the supplier directly by navigating to an edit form.

How can I do this?

Categories:

Building Power Apps

Hi @S2_0452 ,

You can achieve this using the IsBlank/IsEmpty or CountRows function depending on how you are using the Data Source in your App/ gallery.

1. If your subsidiaries are stored in the same list you can do a lookup and see if its Blank (using IsBlank function or IsEmpty function)or not if it is blank or Empty then you can Navigate the User to the Edit Screen else you can load the subsidiaries into a collection and show them in your gallery.

2. If you are loading the subsidiaries from another SP list , then you can use CountRows to check if they are any subsidiaries associated with (by using CountRows>0) if yes , then you load the items by creating a collection else navigate the user to edit form.

Hope this helps!

Thanks,