SmartSheet (A) > MS Flow > SmartSheet (B)

thomasbeaty111566

I have a Master SmartSheet from which I pull new rows into a SmartSheet Report. That works fine for Report users who are safe to have access to all the information in the Master SmartSheet. However, I have other users who need some row data but not all row data (I need to restrict user view of certain data). To do this I flow row data through Zapier into another SmartSheet (I use Zapier as my firewall) SmartSheet (A) > Zapier > SmartSheet (B)...works The PROBLEM: I would prefer to use MS Flow rather than Zapier as my firewall. Hence, SmartSheet (A) > MS Flow > SmartSheet (B) ...doesn’t seem to work???

Paul Newcome

If you build a separate report with the restricted view then publish it, users can view the report through the published link without having access to the main sheet.