Why do you use the choice field and not just have the Owning BU field on the form?

Thanks for the video; it was really useful. I just wanted to add two points related to this. One is that if you deploy this BR to other environments, the BR would fail to deploy/activate because of invalid reference due to hard coded BU GUIDs in the BR. The other point is that if someone assigns a record manually using the Assign button in the command bar, the record will most likely move out of that business unit and onto the new owner's unit.

Fantastic demo. MVPs really suck at explaining this concept.. you nailed it.

This Video was very informative. Make more videos on Business Rules and Dataverse Table relationships

hi flow alt delete. really appreciate the video! But i ran into a problem that others might have aswell. My problem is that my new users, being added to the business units in the way you've said, cant view the table of interest in dataverse. Instead, an error message appears: 'We couldn't load your data. Please try again later'. What my general background is: - I am an admin in a dataverse development environment. In this environment I created a table in which i need row level security. - i created a new test user, and have just added it to this development environment in hope it will enable the user to see the table. - and i have followed the steps in this video to implement record level security in this table, and have assigned the new test user to a 'child' business unit. I have been stuck on this for ages! Let me know a solution (anyone)

What if the file I have is not a table yet? I still need the flow which just created the file to find it and then be made into a table.

This is great! However, I note that "when a file is created in a folder" is now deprecated. Is there an alternative to get the file identifier like you did here?

Thanks mate, Helped me a lot✌🏻👍🏻

This was very helpful. I changed a user to a different business unit and updated her security role to Parent Child Business Units level on all my custom tables. She can no longer see the records on the Lookup tables that someone else entered in the Original Business Unit. Can you tell me what I might have done wrong?

Hello - thanks for putting together this video. This was very helpful. Looking at the fields in a Dataverse table i see there is Owning Business Unit, Owning Team, and Owning User. I will also do some research into the Owning Team and Owning User fields to see how they can be used. Any chance you want to make a video on those ....😁

Thank you for this video! Is there a way we can set more than one teams as owning team of the record?

How would this work with Power Pages and the Contact List? I would want users from one client to only see their client records. Some users (internal or consultants) could see more than just the one client's records. Right now I have been trying table permissions per Account but that doesn't allow viewing more than one account at a time. Looks like permissions are linked to a person through Contacts or Accounts.

Thanks for sharing. Maybe expand it to have a global role that will see all the records.

can i do when file created in one drive or from ms forms then dynamic i needed the file uploaded from ms forms then summarize the flow by creating a new file

Thanks a lot!

I get the following error when following the exact instructions. Any idea how to fix? ..................Cannot read properties of undefined (reading 'parameterGroups')

Great demo Josh!

Hi!! Thank you so much! Is there a way to change the list rows expression to get the second table ? Thanks in advance!

Thank you for sharing this video. It is what I am looking for. However, the file was read fine with "List Row", but when I try to "Update Row", I could not get the column header in the table to show.

Thank you for sharing this video. It is what I am looking for. However, the file was read fine with "List Row", but when I try to "Update Row", I could not get the column header in the table to show.

tells me the list rows step "Array elements can only be selected using an integer index" ect...

Is there a method to specify the table by name? My excel file has more than one table and I need to target the data within a specific table.

Too complicated for me :( How woukd you specify file name dynamically. i.e. I want to copy file with the name Employees-YYYY-MM.xlsx, where YYYY, MM are current year and month respectively?

Thanks brother so much. You saved me. Lots of Love.

Is there a way for this to work for a specific file? Instead of everything within the folder?

Hi Josh, Thank you for the video. It was exactly what I was looking for. I do have a follow up question though. After we've listed all the rows present in the Excel Table I'd like to also list rows from the dataverse (D365CRM/CE) and use the information in the excel rows to filter. I was able to do this with a flow that was based on an Excel File in OneDrive Business, but can't get it to work with this solution. Any idea? I tried it to just list the rows again and also with a condition (apply to each) but I can't get it to work. Your help is greatly appreciated.

How can we rename file in SharePoint dynamically

Thank you so much for this video! Exactly what I needed and works perfectly. I had a follow on question- in my specific flow case, the next step is an "Apply to each" with a yes/no condition based on the row values in a specified column (i.e., if "yes", the specified column contains a certain row value, send out a templated email, if "no", do nothing). For static Excel files, I normally set the output to dynamic content "value" (i.e., outputs("Get_tables")?['body/value'] ) and then specify the variable of interest for the condition using dynamic content as well (i.e., items('Apply_to_each')?['Column Name'] ). I have universal column names that will exist in the different versions of my spreadsheet of interest. When writing out these expressions with this dynamic file name however, I am getting a "unable to process template language expressions" error. How do you specify a column variable name with dynamic Excel file names? Thank you in advance!

Thanks for the video. One thing through me off in your video was around 3:54 mark, you placed the ?['id'] inside the parenthesis. In the video you setup the List rows present in a table step for the Table like this: first(outputs('Get_tables')?['body/value']?['id']) It should be first(outputs('Get_tables')?['body/value'])?['id'] After I made the change it worked great!

Nice Video !!!! Josh. Keep going!

YESSSSSS - So happy to see you doing video!!!

Hey Josh, all the best with your videos.

Great video! Keep up the good work.