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

11/17/19 Edited 12/09/19

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???

Comments

  • Paul NewcomePaul 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.

    thinkspi.com

Sign In or Register to comment.